Re: Question about RMAN Datafile + Archivelog Backups
From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Wed, 2 Dec 2009 12:34:04 -0800 (PST)
Message-ID: <232273.73424.qm_at_web113210.mail.gq1.yahoo.com>
Date: Wed, 2 Dec 2009 12:34:04 -0800 (PST)
Message-ID: <232273.73424.qm_at_web113210.mail.gq1.yahoo.com>
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_at_OneNeck.com> To: "Goulet, Richard" <Richard.Goulet_at_parexel.com>; "Oracle-L_at_freelists.org" <oracle-l_at_freelists.org> 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 J 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_at_parexel.com] 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.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 02 2009 - 14:34:04 CST