Recovery. Have you been there before???

From: Igor <espiaui_at_hotmail.com>
Date: 1 Dec 1998 11:40:27 GMT
Message-ID: <01be1d1f$63559f60$5646ea9e@ukp02062.logica.co.uk>

Suppose there was an earthquake and you lost your production machine today (Thursday).
You have a COLD backup from last Sunday and a HOT backup from yesterday(Wednesday) + all the necessary archived log files. There is an identical(same configuration) brand new machine waiting for you to recover from your backups.

I would like to know:

1)What is the quickest way for recovery?? 2)Can I recover by using the hot backup only. If so how do I recreate the physical on-line redo log files as they are never part of an on-line backup?
3)When backing up the datafiles as part of the hot backup, do I need to include rollback segments and temp datafiles?

Thanks in advance
Igor Received on Tue Dec 01 1998 - 05:40:27 CST