Re: Question about RMAN Datafile + Archivelog Backups
From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Wed, 2 Dec 2009 15:24:49 -0800 (PST)
Message-ID: <982036.59082.qm_at_web113206.mail.gq1.yahoo.com>
>>This simple change would probably have saved a few people their jobs over the years J Not to be curt, but understanding the software they are using (Oracle), the tool they are using (RMAN) and *TESTING* their backup/recovery strategy would be the better solution to saving those people's jobs. There is *no* excuse for not being able to recover from a backup just because one forgot to use the plus archivelog switch. It just means they were lazy and did not test their recovery solution and the deserved to, at the very least, carry around perhaps five pounds less flesh on their backside. Software is what it is, works like it works, and unless it's buggy then you are responsible to use it as it's intended. Suggest enhancements all day long, but if you choose to use the software, know how to use it. Cheers! RF 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: Robert Freeman <robertgfreeman_at_yahoo.com>; "Oracle-L_at_freelists.org" <oracle-l@freelists.org> Sent: Wed, December 2, 2009 1:41:45 PM Subject: RE: Question about RMAN Datafile + Archivelog Backups Yeah, but seems like it should be pretty simple to make the command check the database’s archivelog status and only try to backup archivelogs if it’s in archivelog mode. This simple change would probably have saved a few people their jobs over the years J From:Robert Freeman [mailto:robertgfreeman_at_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. ________________________________ 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.
Date: Wed, 2 Dec 2009 15:24:49 -0800 (PST)
Message-ID: <982036.59082.qm_at_web113206.mail.gq1.yahoo.com>
>>This simple change would probably have saved a few people their jobs over the years J Not to be curt, but understanding the software they are using (Oracle), the tool they are using (RMAN) and *TESTING* their backup/recovery strategy would be the better solution to saving those people's jobs. There is *no* excuse for not being able to recover from a backup just because one forgot to use the plus archivelog switch. It just means they were lazy and did not test their recovery solution and the deserved to, at the very least, carry around perhaps five pounds less flesh on their backside. Software is what it is, works like it works, and unless it's buggy then you are responsible to use it as it's intended. Suggest enhancements all day long, but if you choose to use the software, know how to use it. Cheers! RF 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: Robert Freeman <robertgfreeman_at_yahoo.com>; "Oracle-L_at_freelists.org" <oracle-l@freelists.org> Sent: Wed, December 2, 2009 1:41:45 PM Subject: RE: Question about RMAN Datafile + Archivelog Backups Yeah, but seems like it should be pretty simple to make the command check the database’s archivelog status and only try to backup archivelogs if it’s in archivelog mode. This simple change would probably have saved a few people their jobs over the years J From:Robert Freeman [mailto:robertgfreeman_at_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. ________________________________ 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 - 17:24:49 CST