Re: Question on Incomplete Media Recovery

Rozz Williams wrote:

> 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"?

Answer your own question: do you have a backup control file? Or do you have a surviving copy of your real, live controlfile on disk A?

More technically, would the checkpoint change number in the control file, be ahead of, or the same as, the checkpoint change number in the data files? Or would it be behind them?

You only need the 'using backup controlfile' clause if the checkpoint change number the controlfile you're working with is 'misleading' -ie, behind where the rest of the database has gotten to.

> 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.

Your six points seem to me entirely correct.

I would want to know why a multiplexed member of your redo logs isn't on disk A, as well, though.

Regards
HJR
>
> Regards...
Received on Sun Oct 17 2004 - 14:31:40 CDT