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;
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading