RE: backup best practices

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Fri, 7 Oct 2005 11:13:54 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF35FCC6@EXCNYSM0A1AJ.nysemail.nyenet>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Susan White Sent: Friday, October 07, 2005 10:38 AM
To: 'Oracle-L_at_FreeLists.org'
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

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 07 2005 - 10:17:36 CDT