Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Recovery with hot backup

RE: Recovery with hot backup

From: Jack Silvey <>
Date: Fri, 30 Jun 2000 15:51:35 -0500
Message-Id: <>

Recovery with backup controlfile bad!

I think that after you have applied the last redo log you have to cancel the recovery and open resetlogs.

Since you have a backup controlfile, Oracle cannot know what the last logfile number was, so just asks you for another. I think you gotta tell it there aint no more.

Senior @ xol
ocp X 2

-----Original Message-----
From: [] Sent: Friday, June 30, 2000 4:26 PM
To: Multiple recipients of list ORACLE-L Subject: Recovery with hot backup

I am testing out my backup/recovery strategy. As noted in my previous posting, I am using the following to back up my database while it is on line:

alter tablespace xxx begin backup;

<copy data files for tablespace xxx>

alter tablespace xxx end backup;

... ( for all tablespaces)

alter system switch logfile;

alter database backup controlfile to 'xxxx';

To simulate a complete system failure, I then shut down the database, and deleted all data and control files, including my online redo logs.

Then I copied my data files and backup control file back to their original locations and ran svrmgrl:

SVRMGR> connect internal
SVRMGR>startup mount
Database mounted.
SVRMGR> recover database using backup controlfile;

SVRMGR responds:

ORA-00279: change 124216483 generated at 06/30/00 13:01:49 needed for thread 1
ORA-00289: suggestion : /u010/oradata/fiao3/arch.log1_10298.dbf ORA-00280: change 124216483 for thread 1 is in sequence #10298 Specify log: {<RET>=suggested | filename | AUTO | CANCEL} AUTO
Log applied.
ORA-00279: change 124216530 generated at 06/30/00 13:13:45 needed for thread 1

ORA-00289: suggestion : /u010/oradata/fiao3/arch.log1_10299.dbf
ORA-00280: change 124216530 for thread 1 is in sequence #10299
ORA-00278: log file '/u010/oradata/fiao3/arch.log1_10298.dbf' no longer
needed for this recovery
ORA-00308: cannot open archived log
'/u010/oradata/fiao3/arch.log1_10299.dbf' ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory Additional information: 3

arch.log1_10299.dbf does not exist and, as far as I know, never did. I did not delete it, in any event.

What am I doing wrong here?

Why svrmgr think that there should be another archived log file?\

BTW, I am doing this on a test instance for which I have a cold backup, so, if there is something missing from my backup I do have the option to put the whole thing back to the status quo ante and start over with the a revised online backup.

Peter Schauss
Parker Hannifin Corporation
Smithtown, NY


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
Received on Fri Jun 30 2000 - 15:51:35 CDT

Original text of this message