Question on Incomplete Media Recovery

From: Rozz Williams <satarnag_at_hotmail.com>
Date: 17 Oct 2004 10:38:06 -0700
Message-ID: <bc356f74.0410170938.6823828c@posting.google.com>

Hi,

Here is my scenario:

Disk A: Windows 2000 OS, Oracle install binaries, One controlfile Disk B: All database datafiles, online redo logs, archived redo logs, a copy of a controlfile.

The database is in ARCHIVELOG mode. A Hotbackup is taken every day.

Now, let's say Disk B crashes and I replace the Disk and restore from the previous day's hot backup. What do I need to do with the controlfiles to recover? Do I recover the database with "recover database until cancel using backup controlfile" or just "recover database until cancel"?

I'm thinking the following:

1. delete the newly restored control file on Disk B
2. Copy the controlfile from Disk A to Disk B
3. startup mount
4. recover database until cancel
5. issue a "cancel" (because I do not have any archived redo logs from

the last backup to the point of failure) 6. alter database open resetlogs

Please let me know if I am on the right track.

Regards... Received on Sun Oct 17 2004 - 12:38:06 CDT