Home » RDBMS Server » Server Administration » Error occured when doing recovery
Error occured when doing recovery [message #53768] Thu, 10 October 2002 05:12 Go to next message
David Wang
Messages: 2
Registered: October 2002
Junior Member
Hi All,

I encountered an error when I tried to do the recovery after the restoring the databases. the following were the outputs:

SVRMGR> recover database using BACKUP CONTROLFILE
ORA-00279: change 175676 generated at 10/10/2002 16:01:27 needed for thread 1
ORA-00289: suggestion : 34.arc
ORA-00280: change 175676 for thread 1 is in sequence #1974
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

Log applied.
ORA-00279: change 175681 generated at 10/10/2002 16:07:10 needed for thread 1
ORA-00289: suggestion : /u03/oracle/product/8.1.6/dbs/arch/arch_1_1975.arc
ORA-00280: change 175681 for thread 1 is in sequence #1975
ORA-00278: log file '/u03/oracle/product/8.1.6/dbs/arch/arch_1_1974.arc' no longer needed for this recovery
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log '/u03/oracle/product/8.1.6/dbs/arch/arch_1_1975.arc'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

Actually the archive file '/u03/oracle/product/8.1.6/dbs/arch/arch_1_1975.arc' didn't exist in the backup. Does Anyone has any idea? Thanks for the help in advance.
Re: Error occured when doing recovery [message #53783 is a reply to message #53768] Thu, 10 October 2002 14:31 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
During the hot backup, redo logs are generated as well. Failing to switch the redo logs and archiving those redo logs leads to this error.

Complete list of steps to follow in order to avoid such errors and backup corruption, are well discussed and described Here

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Previous Topic: UTL_FILE Remote path in win NT
Next Topic: maximum no of processes exceeded
Goto Forum:
  


Current Time: Thu Sep 19 17:08:07 CDT 2024