In article <a67sf5$4le$1_at_malgudi.oar.net>, "Dale says...
>
>We are discussing how we will backup our Oracle 8.1.7 database. We are going
>to be doing hot backups for the most part. I'm lobbying for a cold backup
>once a month. I find it confusing. Oracle recommends a cold backup, and then
>says that hot backups should be ok? What do people with experience say?
>What's the trade off? What are the implications of not doing a cold backup.
>Thanks for any information.
>
>
In archivelog mode, there is no need to ever do a cold backup. If you have the
scripts to do hot, just do hot always. You never need a cold backup, you always
have the ability to take a hot and do a point in time recovery -- either
complete (all data restored) or partial -- just restore upto 12 noon for
example, skip the updates that happened after that.
--
Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/
Opinions are mine and do not necessarily reflect those of Oracle Corp
Received on Thu Mar 07 2002 - 10:26:15 CST
