I have taken the backup of a database (Oracle 9i, installed in UNIX AIX OS), and when I restore the backup and start the Oracle database, the database is mounted. Then when I issue the "alter database open resetlogs" command, I get the following error:
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/data/oracle/NYP15S1D/data03/SYSTEM_01.dbf'
How can I resolve the issue?
To get past this issue and since you tried to open with RESETLOGS, you will have to perform incomplete recovery. Do the following:
ALTER DATABASE RECOVER UNTIL CANCEL;
Apply the redo logs. When done, enter CANCEL
ALTER DATABASE OPEN RESETLOGS;
This was first published in August 2010