RE: backup best practices

  • From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • To: <swhite@xxxxxxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
  • Date: Fri, 7 Oct 2005 11:13:54 -0400



We run a data warehouse that is loaded during a 3 day period once a
week.  They are not interested in running in archivelog mode, so we do a
cold backup once a week.


All of our Oltp databases run in archivelog mode and we only use Rman
for backups for these databases.  We never shut the databases down
unless there is some maintenance (hardware/software) being done.





From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Susan White
Sent: Friday, October 07, 2005 10:38 AM
To: 'Oracle-L@xxxxxxxxxxxxx'
Subject: backup best practices


Should off-line backups (RMAN or otherwise) be a part of a standard
backup strategy? In the "old" days, cold backups were recommended for
consistency - or at least that's how I understood it. Now, it seems that
these are not deemed essential. What is the recommended best practice
for off-line/on-line backups?


Related to this:  Should the DB be "bounced" occasionally?  In my last
oracle class, this was implied, although not stated.  Any thoughts




Susan White


This email has been scanned by the MessageLabs Email Security System.
For more information please visit 

Other related posts: