Re: [Networker] General Oracle RMAN backup/recover question?

2007-05-02 01:24:59
Subject: Re: [Networker] General Oracle RMAN backup/recover question?
From: Ronny Egner <Ronny.Egner AT SIV DOT DE>
Date: Wed, 2 May 2007 07:23:33 +0200
George Sinclair schrieb:

General question here about Oracle backups using RMAN with the NetWorker Oracle module.
1. Is is recommended to take a level full backup after the database has
been re-started?
We're thinking that just because the database is shut down for whatever
reason and later
restarted that we should be able to simply continue with the same backup
schedule as before.
So, if the next scheduled backup calls for an incremental then that's
what we run. However,
would re-starting the database in any way require you to run a full?

2. What if you recover an older version of the database? Then should you take a full backup
after the recovery?

Our current backup strategy is level 0 (full) once per week with level 1 backups (cumulative incrementals)
all other days of the week.

you do *not* need to backup your database after a restart
(even if it was shut down with 'shutdown abort' or 'startup force').
You should always take a full backup when changing something (i.e.
adding a tablespace, a datafile, open the database with 'resetlogs').

If you recovery your database you should take a full backup afterwards.
If you did an incomplete recovery (i.e. until sequence or time) see
point 1 - you have to to an 'open resetlogs' in that case - so you need
to backup your database.

Mit freundlichen Grüßen

Ronny Egner
Diplom-Ingenieur (BA)
Systeme & Service
Oracle DBA

Telefon: +49 381 2524-422
Telefax: +49 381 2524-399

mailto:ronny.egner AT siv DOT de

SIV.AG - Service für Informationsverarbeitung AG
Hauptsitz: Konrad-Zuse-Str. 1, 18184 Roggentin
Handelsregister: Amtsgericht Rostock, HRB 8677, Ust.-IdNr.: DE 137477226
Vorstand: Jörg Sinnig (Vorsitzender), Andreas Lehmann, Arno Weichbrodt
Aufsichtsratsvorsitzender: Peter Gronemeier
Aus Rechtsgründen ist die in dieser E-Mail gegebene Information nicht
rechtsverbindlich. Eine rechtsverbindliche Bestätigung reichen wir Ihnen auf Anforderung in schriftlicher Form nach. Diese Nachricht ist ausschließlich für den
bezeichneten Adressaten oder dessen Vertreter bestimmt.

The information contained in this email is not legally binding. At your request, we will provide you with a legally binding confirmation in written form. This
message is intended solely for the addressee, entity to which the email
is addressed or the authorised agent.

To sign off this list, send email to listserv AT listserv.temple DOT edu and type 
"signoff networker" in the body of the email. Please write to networker-request 
AT listserv.temple DOT edu if you have any problems with this list. You can access the 
archives at or
via RSS at

<Prev in Thread] Current Thread [Next in Thread>