Fermin, I don’t want to de-motivate you, but
I really doubt whether your backup strategy really works. The command that you
have mentioned below will NOT do a complete recovery as it’s a cold
backup. As for your questions: 1) You can recover your entire database in
either case (Cold or Hot), If you have your archive logs. Difference
being, You have recreate your control file if it’s a cold DB backup and
recover the DB using ‘BACKUP CONTROL FILE’ option. 2) Lets look at it the other way; you do NOT
need any downtime for Hot backups while you need
downtime for Cold backups. Downtime could be very expensive depending on the type
of database. Secondly, you can take a
hot backup very frequently as it does not involve any downtime. Recent backup
means less recovery is required and less time to bring up the database. Let me know if you need anymore info. Cheers! Venu -----Original Message----- I've been reading your messages with much interest. I have some
experience with database administration and I have done many tests, but I've
not tried what I am going to expose in this message, maybe you can help. We do
cold backups on a regular basis (every weekend) then just backup the archive
log every day, then delete them every time a new cold backup is done. We have
tested it and if all database files (parameters file, datafiles, control files)
except for one control file and the archived logs were lost we could recover
the entire database issuing the following commands after restoring all missing
files and mounting the database: SET AUTORECOVERY ON RECOVER DATABASE ALTER DATABASE OPEN My questions are: 1 -
Could a complete restore be done even if we lost ALL control files? can we
recover the entire database from a cold backup provided we have all archived
logs until the failure time? 2 - If the answer is yes, what is the advantage of doing on-line
backups of datafiles and control files? Thanks for your answers, I always learn so much from this list!! Fermin.
|
- RE: Change based recovery Mercadante, Thomas F
- RE: Change based recovery Venu Gopal
- Change based recovery Dobson, Lisa
- RE: Change based recovery Fermin Bernaus
- RE: Change based recovery Hand, Michael T
- RE: Change based recovery DENNIS WILLIAMS
- RE: Change based recovery Venu Gopal
- RE: Change based recovery Venu Gopal
- RE: Change based recovery Fermin Bernaus
- RE: Change based recovery Fermin Bernaus
- RE: Change based recovery Fermin Bernaus
- RE: Change based recovery DENNIS WILLIAMS