Re: Question about RMAN Datafile + Archivelog Backups

  • From: Robert Freeman <robertgfreeman@xxxxxxxxx>
  • To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>, "Oracle-L@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 2 Dec 2009 15:24:49 -0800 (PST)

>>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.



 Robert G. Freeman
Oracle ACE
Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it!
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON ITS WAY SOON!
OCP: Oracle Database 11g Administrator Certified Professional Study Guide 
Oracle Database 11g New Features (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Other various titles
Check out my new blog series on installing Oracle Database 11gR2 on Windows 
using VMWare!

From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
To: Robert Freeman <robertgfreeman@xxxxxxxxx>; "Oracle-L@xxxxxxxxxxxxx" 
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@xxxxxxxxx] 

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.

Other related posts: