Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Recovery with hot backup
Exactly. That is why you always have to open resetlog if you are recovering
from a backup controlfile.
Winnie
Jack Silvey <JSilvey_at_XOL.com> on 06/30/2000 02:56:25 PM
Please respond to ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)
Subject: 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-----
Sent: Friday, June 30, 2000 4:26 PM
To: Multiple recipients of list ORACLE-L
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-LReceived on Fri Jun 30 2000 - 16:45:11 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Author: Jack Silvey INET: JSilvey_at_XOL.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 may