Dear Robert Prendin
Saw your article over the net and found it very interesting. I have some
confusion regarding the hot backup and archivelog mode backup.Please
bear with me.
If your database is running in archive log mode, thenis it necessary to
take hot backup also or achive log along with cold backup will suffice.
Let us say we take cold backup on sunday and backup of offline redolog
files everyday. If on tuesday or wednesday (assume) whole of the system
crashes ( you lose every datafile, every control file) and you have to
roll forward you database from scratch. The onvious thing would be to
put the cold backup into the machine and apply your redo logs. But (the
catch) when you put cold backup and mount your database and give recover
database command, wont it say that no recovery required. Since
everything is in sync, the control file, datafiles etc, they have the
same time stamp, same SCN. Can you enlighten me on this thing, I tired
and failed to roll forward the databse.
I am having great hopes and anticipations from your side, please do
reply.
Reagrds
Devinder
Received on Mon Aug 10 1998 - 14:47:31 CDT
