ORA-00322 ORA-00312 恢复----惜分飞

转载：http://www.xifenfei.com/2018/11/ora-00322-ora-00312.html

数据库mount报ORA-00214错误

C:\Users\Administrator>sqlplus / as sysdba   SQL*Plus: Release 11.2.0.4.0 Production on 星期二 11月 27 14:41:15 2018   Copyright (c) 1982, 2013, Oracle.  All rights reserved.     连接到: XIFENFEIle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options   SQL> select open_mode from v$ database ; select open_mode from v$ database                        * 第 1 行出现错误: ORA-01507: ??????     SQL> alter database mount; alter database mount * 第 1 行出现错误: ORA-00214: ???? '' D:\APP\ADMINISTRATOR\ORADATA\XIFENFEI\CONTROL01.CTL '' ?? 14709 ??? '' D:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\XIFENFEI\CONTROL02.CTL '' ?? 14681 ???

使用其中一个控制文件启动数据库报ORA-00322 ORA-00312错误

SQL> startup mount; XIFENFEILE 例程已经启动。   Total System Global Area 5127602176 bytes Fixed Size                  2290120 bytes Variable Size            1056968248 bytes Database Buffers         4060086272 bytes Redo Buffers                8257536 bytes 数据库装载完毕。   SQL> recover database ; ORA-00283: recovery session canceled due to errors ORA-00322: log 1 of thread 1 is not current copy ORA-00312: online log 1 thread 1: 'D:\APP\ADMINISTRATOR\ORADATA\XIFENFEI\REDO01.LOG'

alert日志报ORA-00322 ORA-00312 ORA-00314 等错

Tue Nov 27 14:42:44 2018 ALTER DATABASE RECOVER  database  Media Recovery Start   started logmerger process Parallel Media Recovery started with 24 slaves Tue Nov 27 14:42:45 2018 Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\XIFENFEI\XIFENFEI\trace\XIFENFEI_pr00_4168.trc: ORA-00322: log 1 of thread 1 is not current copy ORA-00312: online log 1 thread 1: 'D:\APP\ADMINISTRATOR\ORADATA\XIFENFEI\REDO01.LOG' Tue Nov 27 14:42:45 2018 Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\XIFENFEI\XIFENFEI\trace\XIFENFEI_m000_3876.trc: ORA-00322: log 1 of thread 1 is not current copy ORA-00312: online log 1 thread 1: 'D:\APP\ADMINISTRATOR\ORADATA\XIFENFEI\REDO01.LOG' Media Recovery failed with error 322 Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\XIFENFEI\XIFENFEI\trace\XIFENFEI_pr00_4168.trc: ORA-00283: recovery session canceled due to errors ORA-00322: log 1 of thread 1 is not current copy ORA-00312: online log 1 thread 1: 'D:\APP\ADMINISTRATOR\ORADATA\XIFENFEI\REDO01.LOG' Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\XIFENFEI\XIFENFEI\trace\XIFENFEI_m000_3876.trc: ORA-00314: log 2 of thread 1, expected sequence # 722 doesn't match 719 ORA-00312: online log 2 thread 1: 'D:\APP\ADMINISTRATOR\ORADATA\XIFENFEI\REDO02.LOG' Checker run found 4 new persistent data failures ORA-283 signalled during: ALTER DATABASE RECOVER  database  ...

通过Oracle Database Recovery Check脚本检查数据库结果

---

通过这里可以看出来,数据库需要的redo确实是721,但是recover无法应用成功,出现该问题的原因是由于控制文件信息不对导致

使用备份控制文件恢复

D:\>sqlplus / as sysdba   SQL*Plus: Release 11.2.0.4.0 Production on 星期二 11月 27 14:44:00 2018   Copyright (c) 1982, 2013, Oracle.  All rights reserved.     连接到: XIFENFEIle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options   SQL> recover database using backup controlfile; ORA-00279: 更改 4034899 (在 11/27/2018 10:37:04 生成) 对于线程 1 是必需的 ORA-00289: 建议: D:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\XIFENFEI\ARCHIVELOG\2018_11_27\O1_MF_1_721_%U_.ARC ORA-00280: 更改 4034899 (用于线程 1) 在序列 #721 中     指定日志: {<RET>=suggested | filename | AUTO | CANCEL} D:\APP\ADMINISTRATOR\ORADATA\XIFENFEI\REDO02.LOG ORA-00310: archived log contains sequence 719; sequence 721 required ORA-00334: archived log: 'D:\APP\ADMINISTRATOR\ORADATA\XIFENFEI\REDO02.LOG'     SQL> recover database using backup controlfile; ORA-00279: 更改 4034899 (在 11/27/2018 10:37:04 生成) 对于线程 1 是必需的 ORA-00289: 建议: D:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\XIFENFEI\ARCHIVELOG\2018_11_27\O1_MF_1_721_%U_.ARC ORA-00280: 更改 4034899 (用于线程 1) 在序列 #721 中     指定日志: {<RET>=suggested | filename | AUTO | CANCEL} D:\APP\ADMINISTRATOR\ORADATA\XIFENFEI\REDO02.LOG ORA-00310: archived log contains sequence 719; sequence 721 required ORA-00334: archived log: 'D:\APP\ADMINISTRATOR\ORADATA\XIFENFEI\REDO02.LOG'     SQL> D:\APP\ADMINISTRATOR\ORADATA\XIFENFEI\REDO02.LOG SP2-0734: 未知的命令开头 "D:\APP\ADM..." - 忽略了剩余的行。 SQL> recover database using backup controlfile; ORA-00279: 更改 4034899 (在 11/27/2018 10:37:04 生成) 对于线程 1 是必需的 ORA-00289: 建议: D:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\XIFENFEI\ARCHIVELOG\2018_11_27\O1_MF_1_721_%U_.ARC ORA-00280: 更改 4034899 (用于线程 1) 在序列 #721 中     指定日志: {<RET>=suggested | filename | AUTO | CANCEL} D:\APP\ADMINISTRATOR\ORADATA\XIFENFEI\REDO01.LOG 已应用的日志。 完成介质恢复。 SQL> alter database open resetlogs;   数据库已更改。

实现数据0丢失恢复,数据库open之后可以直接使用