ORA-00314

Error:  ORA-314 

Text:   log of thread , expected sequence # does not match

       

-------------------------------------------------------------------------------

Cause:  The online log is out of sequence, probably because it is corrupted or

        an old version.

Action: For more information on recovery procedures, see the

        Administrator's Guide>.

*** Important: The notes below are for experienced users - See Note:22080.1

Support Notes:

  If the database is from a clean shutdown and no restore has been

  performed then it may be just the Online logs have been over-written.

  A useful quick check is:

     select * from v$recover_file;

  If this shows no rows then the following steps may be useful:

    a. If you do not know why the current online log is an old copy

       take a backup of all existing datafiles (V$datafile),

       controlfile (v$controlfile) and the online logs (even though old)

       (v$logfile). This ensures you can never get into a worse position

       than you are in now.

    b. Once you have a safe backup copy:

         startup mount

         recover database until cancel;

         ## This should report "Media recovery complete."

         alter database open resetlogs;

        如果报ora-01113 ora-01110使用_allow_resetlogs_corruption隐含参数

    c. Now shutdown take a FULL backup of all datafiles / logfiles and

       controlfile as you cannot perform recoveries through a resetlogs.

 

 

请使用浏览器的分享功能分享到微信等