Error opening database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Error opening database

  1. #1
    Join Date
    Jan 2001
    Posts
    642
    hi,
    I have restored the log files(LOG2ORCL.ora, LOG1ORCL.ora) from my cold backup. While trying to start the database I get the following error

    ORA-00322: Log 1 of thread 1 is not current copy
    ORA-00312: Online log 1 thread 1:'D:\ORANT\DATABASE\LOG2ORCL.ORA'.

    The docu says, to check for all instances, I am sure there are no other instance running.

    The database earlier was on archiver log mode.
    Suggest me to start the database please.
    Badrinath

  2. #2
    Join Date
    Jun 2000
    Posts
    417
    If you restored only the logs from the cold backup and nothing else, than that error should be expected. You're restoring logs with an old SCN, while your control files have the newer SCN.

    Assuming you don't need the contents of your logs, and the database is otherwise in stable condition, you will probablly have to startup mount, fake a recovery by alter database recover until cancel, and then alter database open resetlogs.

  3. #3
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    It shows that you have not taken the backup when the Database is closed. May be you can try to use RECOVER DATABASE.

    It will start applying Archive Log files and may be able to open the database. Provided that you have archive logs available prior to the Backup you are using.
    Thanks
    Kishore Kumar

  4. #4
    Join Date
    Apr 2000
    Location
    Bangalore
    Posts
    16
    hi badri,


    To bring up the database, follow these steps.

    svrmgrl> startup mount;
    svrmgrl> recover database until cance;

    At proplt enter cancel

    svrmgrl> alter database open resetlogs;

    This will create online redo log files.

    Thanks,
    Bhaskar

Posting Permissions

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



Click Here to Expand Forum to Full Width