While starting database error- ORA-01589:must use RESETLOGS or NORESETLOGS
178976May 23 2006 — edited May 24 2006Hi ,
I have a test database and while I tried to open the test database I have got following error.
SQL> startup;
ORACLE instance started.
Total System Global Area 57170424 bytes
Fixed Size 453112 bytes
Variable Size 54525952 bytes
Database Buffers 2048000 bytes
Redo Buffers 143360 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
I then tried running "Alter database open RESET LOGS" but then get : ERROR at line 1:
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:\ORACLE9I\DATABASE\ORADATA\MDW\SYSTEM.DBF'
Then i tried
SQL> recover database using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-01190: controlfile or data file 3 is from before the last RESETLOGS
ORA-01110: data file 3: 'D:\ORACLE9I\DATABASE\ORADATA\MDW\MDW_DATA.DBF'
I am still unable to recover the database. Please help me ....