Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Unable to rebuild database from hot backup

RE: Unable to rebuild database from hot backup

From: Robert Pegram <>
Date: Fri, 26 Oct 2001 05:41:46 -0700
Message-ID: <>


> You can not simply cancel a "recover
> database using backup
> controlfile" since Oracle is expecting you perform a
> complete recovery (
> since your not using the UNTIL CANCEL/TIME/CHANGE )
> and canceling a complete
> recovery leaves the stop SCN in the controlfile at
> infinity... Therefore,
> the recovery is never complete and you will always
> receive the "needs media
> recovery message"...

I don't think this is 100% true for every situation. I am no recovery expert, but I just did this the other day, and to verify it, I ran the test again this morning.

  1. Shutdown abort
  2. Delete all current controlfiles
  3. Replaced the binary controlfiles from last hot backup (they were copied as part of the backup script)
  4. Startup mount
  5. Recover database using backup controlfile
  6. Kept applying logs - only trick was that the last log was an online redo log, so I had to type in that log explicitly. There I received the message Media Recover Complete.
  7. Alter database open resetlogs.

Rob Pegram
Oracle Certified DBA

SVRMGR> shutdown abort
ORACLE instance shut down.
SVRMGR> startup mount
ORACLE instance started.

SVRMGR> alter database open

     2> ;
alter database open
ORA-01122: database file 1 failed verification check ORA-01110: data file 1:
ORA-01207: file is more recent than controlfile - old controlfile

SVRMGR> recover database using backup controlfile; ORA-00279: change 546459 generated at 10/26/2001 06:59:20 needed for thread 1
ORA-00289: suggestion :
C:\ORACLE\ORADATA\ORCL\ARCHIVE\ORCLT001S00015.ARC ORA-00280: change 546459 for thread 1 is in sequence #15
Specify log: {<RET>=suggested | filename | AUTO | CANCEL} Log applied.

.............. cut .......

ORA-00280: change 566491 for thread 1 is in sequence #21
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
Log applied.
Media recovery complete.

SVRMGR> alter database open resetlogs;
Statement processed.

Do You Yahoo!?
Make a great connection at Yahoo! Personals.
Please see the official ORACLE-L FAQ:
Author: Robert Pegram

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Oct 26 2001 - 07:41:46 CDT

Original text of this message