startup open error message
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: startup open error message

  1. #1
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    oracle 8.1.7
    OS - NT
    Mode - archivelog

    I have several instances on this windows NT .
    All the instances have started and the database is open.

    For this particular instance testing i am getting this error.

    SVRMGR> alter database open;
    alter database open
    *
    ORA-00314: log 1 of thread 1, expected sequence# doesn't match
    ORA-00312: online log 1 thread 1: 'D:\ORACLE817\ORADATA\TESTING\REDO03.LOG'

    what is error and how this can be resolved.




  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Do you keep backups on this? On such case, startup the database on mount, do a recovery until cancel and then do alter database open resetlogs;

    The error was because that your controlfile and the redo log files are not in sync. You either recoverd the controlfile and did not recover the online log file that you backed up or vice versa.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    Did the steps as said by sambavan Thanks sambhavan

    Case closed

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