Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005

    Unanswered: control file problem

    This is only for the proof of concept: Using a binary backup of controlfile to recover the database.

    Here is what I have done:

    1. The database is healthy, up and running.
    2. alter database backup controlfile to '/export/home/oracle/bkp.ctl';
    3. shutdown abort
    4. rm /u01/oradata/control01.ctl (This is the only ctl file.)
    5. cp /export/home/oracle/bkp.ctl /u01/oradata/control01.ctl
    6. Startup mount;


    SQL> alter database open;
    alter database open
    ERROR at line 1:
    ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

    Please suggest , how should I approach the solution..??

    Thanks, Raj

  2. #2
    Join Date
    May 2004
    Dominican Republic
    You must use RESETLOGS clause when opening the DB, because by the time you backed up the control file and shut down the db, Oracle could have changed the log sequence number, thus needing it to be reset back to 1, archiving current logs if needed.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts