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