RE: RMAN question(s)

Hmmm, now I'm wondering.   I only have ... 'backup database archivelog
all;'   Does this mean I am at risk?

 

e.g.  Should it be 'backup database plus archivelog;' instead?

 

crosscheck backup;

crosscheck archivelog all;

crosscheck copy;

delete noprompt expired backup;

delete noprompt expired archivelog all;

delete noprompt expired copy;

 

Backup database archivelog all;

 

List backup;

Delete noprompt obsolete;

Restore database validate;

 

 

 

Joel Patterson 
Database Administrator 
joel.patterson@xxxxxxxxxxx 
x72546 
904  727-2546 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of goran bogdanovic
Sent: Tuesday, August 28, 2007 5:39 AM
To: JSweetser@xxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: RMAN question(s)

 

if you use "plus archivelog" in rman backup then rman do the following:
 - alter system archive log current
 - backup all archive logs i.e. backup archivelog all
 - database backup is done specified by your backup stmt. 
 - the "alter system archive log current" statement is executed
 - back up of archived redo logs created by previous stmt.




On 8/28/07, Sweetser, Joe <JSweetser@xxxxxxxx> wrote:

Hi all -

My question is what do people around here do?  Backup database and
backup archivelog?  Backup database...plus archivelog?  I realize this
is somewhat "nuancy" but, personally, I like the idea of at least being 
able to get the database back (and opened) with a single night's backup
that is copied to tape.  Opinions/thoughts/experiences?

Thanks,
-joe
--
http://www.freelists.org/webpage/oracle-l

Other related posts: