RE: Question about RMAN Datafile + Archivelog Backups
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <robertgfreeman@xxxxxxxxx>, <Brandon.Allen@xxxxxxxxxxx>, "'Goulet, Richard'" <Richard.Goulet@xxxxxxxxxxx>, "'Oracle-L@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 2 Dec 2009 16:54:18 -0500
So it might be misleading to a naïve user if the command description said it
backed up archives, but of course then it wouldn?t in noarchivelog mode.
Interesting point, Robert.
Also of course, if you want RMAN to be able to maximally automatic for
recoveries then you need to backup the archives via RMAN so it knows where
they are already and you don?t have to tell it. But there is utility in
backing up the archive logs at the OS level. If you?ve got a complete backup
in RMAN but the wheels fall off, but you also have tape sets (or DVDs or
even JBOD) with all the archives outside of RMAN, then you can still save
your database from older pieces or a lagged standby or even all the way from
nothing if you?ve got everything logged from creation. It?s also useful for
using busnet or upsnet to ?test recovery? at an old fashioned physical DR
site. And I really don?t want to ever just have one backup copy of anything
I really care about.
mwf
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Robert Freeman
Sent: Wednesday, December 02, 2009 3:34 PM
To: Brandon.Allen@xxxxxxxxxxx; Goulet, Richard; Oracle-L@xxxxxxxxxxxxx
Subject: Re: Question about RMAN Datafile + Archivelog Backups
I've always thought that the archivelog backup should be the default
condition with a switch to turn it off. Maybe it's a programitic constraint
since the same command (backup database) is used for both ARCHIVELOG and
NOARCHIVELOG mode backups.
Robert G. Freeman
Oracle ACE
Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it!
Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON ITS WAY
SOON!
OCP: Oracle Database 11g Administrator Certified Professional Study Guide
(Sybex)
Oracle Database 11g New Features (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Other various titles
Blog: http://robertgfreeman.blogspot.com
Check out my new blog series on installing Oracle Database 11gR2 on Windows
using VMWare!
_____
From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
To: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>; "Oracle-L@xxxxxxxxxxxxx"
<oracle-l@xxxxxxxxxxxxx>
Sent: Wed, December 2, 2009 12:23:12 PM
Subject: RE: Question about RMAN Datafile + Archivelog Backups
Yes, I like my backups to be recoverable :-) I was just pointing out the
caveat that they?re not included if you just run ?backup database?. It
seems to me that it would be a good idea to make the backup command include
archivelogs by default and only have an option to exclude them if desired
for some reason ? maybe in 12x.
From: Goulet, Richard [mailto:Richard.Goulet@xxxxxxxxxxx]
True, don't you include the archive logs in the backup set??
_____
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions
and other information in this message that do not relate to the official
business of this company shall be understood as neither given nor endorsed
by it.
Other related posts:
