| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Recovery with hot backup
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.
Jack
Senior @ xol
ocp X 2
-----Original Message-----
From: pschauss_at_parker.com [mailto:pschauss_at_parker.com]
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
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 longerneeded for this recovery
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
Parker Hannifin Corporation
Smithtown, NY
-- Author: INET: pschauss_at_parker.com 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: ListGuru_at_fatcity.com (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 mayReceived on Fri Jun 30 2000 - 15:51:35 CDT
 |
 |