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博客 ” ,链接:http://blog.itpub.net/15747463/viewspace-1178910/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15747463/viewspace-1178910/