DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Logfile sequence no. problem

Hybrid View

  1. #1
    Join Date
    May 2002
    Location
    Mumbai, India
    Posts
    27
    Hi ,
    While starting the database an error is throwing :
    ORA-314 log 2 of thread 1 expected sequence no. does not match
    ORA-312 ...... online log ....... (name and location of the log).

    The database could not be opened.

    So how to get out of this situation ????

    This is very urgent ....

    Thanks in Advance

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    most probably your log is either too old or corrupted, shutdown the database, delete the corrupted file and copy from another member of SAME group

  3. #3
    Join Date
    May 2002
    Location
    Mumbai, India
    Posts
    27

    Successfully recovered

    Hi Pando,
    I've recovered the database in 2 steps (got the feedback from dbasupport.com previous entries)

    Database is in mount state.

    i) alter database recover until cancel.
    ii) alter database open resetlogs.

    Thanks for the help.


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