Recovery with hot backup

From: <pschauss_at_parker.com>
Date: Fri, 30 Jun 2000 13:07:39 -0700
Message-Id: <10544.111008@fatcity.com>

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;

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

thanks,
Peter Schauss Received on Fri Jun 30 2000 - 15:07:39 CDT