Recovery Problem! please help.

From: <lkj741_at_my-deja.com>
Date: Tue, 14 Mar 2000 21:22:36 GMT
Message-ID: <8amail$ak0$1@nnrp1.deja.com>

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 bytes

Database mounted.
SVRMGR> alter database open;

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 - 15:22:36 CST