RE: RMAN question(s)
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <goran00@xxxxxxxxx>, <JSweetser@xxxxxxxx>
- Date: Tue, 28 Aug 2007 08:14:11 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
