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_at_crowley.com
x72546
904 727-2546

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of goran bogdanovic Sent: Tuesday, August 28, 2007 5:39 AM
To: JSweetser_at_icat.com
Cc: oracle-l_at_freelists.org
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_at_icat.com> 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



 


--
http://www.freelists.org/webpage/oracle-l