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.

ITPub博客

ORA-00314