ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
Hi Friends,
I am a new oracle dba. I have installed and created a oracle10gR2 database on linux server.
Also i have configured the database on archive mode. But after using a month , when i restarted the server , i am unable to open the database.
The system restaretd when database was up and running.
I didnot take any backup for that database instance.
Please suggect how the recover the database.
SQL> startup
ORACLE instance started.
Total System Global Area 918552576 bytes
Fixed Size 1222600 bytes
Variable Size 264243256 bytes
Database Buffers 645922816 bytes
Redo Buffers 7163904 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open RESETLOGS;
alter database open RESETLOGS
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/software/oracle/ORCLDB/system01.dbf'
SQL>
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/software/oracle/archives/ORCLDB
Oldest online log sequence 174
Next log sequence to archive 176
Current log sequence 176
SQL>
SQL> recover database until cancel using backup controlfile;
ORA-00279: change 7502961 generated at 07/14/2010 22:02:27 needed for thread 1
ORA-00289: suggestion :
/u01/software/oracle/archives/ORCLDB/1_176_710424799.dbf
ORA-00280: change 7502961 for thread 1 is in sequence #176
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00308: cannot open archived log
'/u01/software/oracle/archives/ORCLDB/1_176_710424799.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-00308: cannot open archived log
'/u01/software/oracle/archives/ORCLDB/1_176_710424799.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u01/software/oracle/ORCLDB/system01.dbf'
SQL>
Regards,
P.K.Nayak