RE: backup best practices

Susan,

 

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.

 

Tom

 

________________________________

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

 

Thanks

 

Susan White

 


______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________

Other related posts: