How to perform incomplete recovery to overcome Oracle database error

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?

    Requires Free Membership to View

    Login

To get past this issue and since you tried to open with RESETLOGS, you will have to perform incomplete recovery. Do the following:

STARTUP MOUNT

ALTER DATABASE RECOVER UNTIL CANCEL;

Apply the redo logs. When done, enter CANCEL

ALTER DATABASE OPEN RESETLOGS;

This was first published in August 2010

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top