Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Recovery Problem!!!
MY PROBLEM....Please help.
SVRMGR> startup mount;
ORACLE instance started.
Total System Global Area 8744464 bytes Fixed Size 48656 bytes Variable Size 7487488 bytes Database Buffers 1126400 bytes Redo Buffers 81920 bytesDatabase mounted.
alter database open
*
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SVRMGR> alter database open resetlogs;
alter database open resetlogs
*
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/db0/u01/oradata/db01/system01.dbf'
SVRMGR> recover datafile '/db0/u01/oradata/db01/system01.dbf' ORA-00283: recovery session canceled due to errors ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SVRMGR> recover database using backup controlfile;
ORA-00279: change 579666 generated at 03/13/00 17:45:02 needed for
thread 1
ORA-00289: suggestion : /db0/u05/oradata/db01/archive/arch0000001737.log
ORA-00280: change 579666 for thread 1 is in sequence #1737
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived
log '/db0/u05/oradata/db01/archive/arch0000001737.log'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Any Idea? It seems nothing working. When I checked my arch.log. I couldn't find 1737. But #1736 and #1738 is there.
Please help! Datatabase was running archive mode and it is enable. I don't think recreating control file would help. It is a development database. No live data in it.
Thanks
Ashadul Khan
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Mar 14 2000 - 00:00:00 CST