Re: Recovery. Have you been there before???

From: John P. Higgins <jh33378_at_deere.com>
Date: Tue, 01 Dec 1998 10:25:54 -0600
Message-ID: <36641892.A543D866@deere.com>

You would restore the complete database, including the rollback segments and the temp tablespace, from the hot backup. Then you would RECOVER UNTIL CANCEL. When you reached the end of your archived logs, you would reply CANCEL. You would lose all the transactions after that point.
You would then ALTER DATABASE OPEN RESETLOGS.

If you restored the cold backup, you would have to process more logs to reach this same point.

The point is that only your backed up archived logs are available in the disaster you described. We backup the archived logs multiple times per day and send a copy offsite.

Igor wrote:

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 - 10:25:54 CST