Oracleの障害処理

ORA-00322ORA-00312リカバリ---- Feifei



Ora 00322 Ora 00312 Recovery Feifei



転載： http://www.xifenfei.com/2018/11/ora-00322-ora-00312.html

データベースマウントレポートORA-00214エラー



C:UsersAdministrator>sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Tuesday November 27 14:41:15 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: 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$ databaseselect open_mode from v$ database* Error on line 1: ORA-01507: ?????? SQL> alter database mount alter database mount * Error on line 1: ORA-00214: ???? '' D:APPADMINISTRATORORADATAXIFENFEICONTROL01.CTL '' ?? 14709 ??? '' D:APPADMINISTRATORFAST_RECOVERY_AREAXIFENFEICONTROL02.CTL '' ?? 14681 ???

制御ファイルの1つを使用して、データベース・レポートを開始します。ORA-00322ORA-00312エラー

SQL> startup mount The XIFENFEILE routine has been started. Total System Global Area 5127602176 bytes Fixed Size 2290120 bytes Variable Size 1056968248 bytes Database Buffers 4060086272 bytes Redo Buffers 8257536 bytes The database is loaded. SQL> recover databaseORA-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:APPADMINISTRATORORADATAXIFENFEIREDO01.LOG'

アラートログが報告されましたORA-00322ORA-00312 ORA-00314



Tue Nov 27 14:42:44 2018 ALTER DATABASE RECOVER database Media Recovery Startstarted logmerger process Parallel Media Recovery started with 24 slaves Tue Nov 27 14:42:45 2018 Errors in file D:APPADMINISTRATORdiag dbmsXIFENFEIXIFENFEI raceXIFENFEI_pr00_4168.trc: ORA-00322: log 1 of thread 1 is not current copy ORA-00312: online log 1 thread 1: 'D:APPADMINISTRATORORADATAXIFENFEIREDO01.LOG' Tue Nov 27 14:42:45 2018 Errors in file D:APPADMINISTRATORdiag dbmsXIFENFEIXIFENFEI raceXIFENFEI_m000_3876.trc: ORA-00322: log 1 of thread 1 is not current copy ORA-00312: online log 1 thread 1: 'D:APPADMINISTRATORORADATAXIFENFEIREDO01.LOG' Media Recovery failed with error 322 Errors in file D:APPADMINISTRATORdiag dbmsXIFENFEIXIFENFEI raceXIFENFEI_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:APPADMINISTRATORORADATAXIFENFEIREDO01.LOG' Errors in file D:APPADMINISTRATORdiag dbmsXIFENFEIXIFENFEI raceXIFENFEI_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:APPADMINISTRATORORADATAXIFENFEIREDO02.LOG' Checker run found 4 new persistent data failures ORA-283 signalled during: ALTER DATABASE RECOVER database ...

沿って Oracleデータベースリカバリチェック スクリプトチェックデータベースの結果
データファイルヘッダー
ログファイル

このことから、データベースに必要なREDOは確かに721であることがわかりますが、リカバリを正常に適用することはできません。この問題の理由は、制御ファイルの情報が正しくないためです。

バックアップ制御ファイルの回復を使用する

D:>sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Tuesday November 27 14:44:00 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: 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: Change 4034899 (generated at 11/27/2018 10:37:04) is required for thread 1 ORA-00289: Suggestions: D:APPADMINISTRATORFAST_RECOVERY_AREAXIFENFEIARCHIVELOG2018_11_27O1_MF_1_721_%U_.ARC ORA-00280: Change 4034899 (for thread 1) in sequence #721 Specify the log: CANCEL D:APPADMINISTRATORORADATAXIFENFEIREDO02.LOG ORA-00310: archived log contains sequence 719 sequence 721 required ORA-00334: archived log: 'D:APPADMINISTRATORORADATAXIFENFEIREDO02.LOG' SQL> recover database using backup controlfile ORA-00279: Change 4034899 (generated at 11/27/2018 10:37:04) is required for thread 1 ORA-00289: Suggestions: D:APPADMINISTRATORFAST_RECOVERY_AREAXIFENFEIARCHIVELOG2018_11_27O1_MF_1_721_%U_.ARC ORA-00280: Change 4034899 (for thread 1) in sequence #721 Specify the log: AUTO D:APPADMINISTRATORORADATAXIFENFEIREDO02.LOG ORA-00310: archived log contains sequence 719 sequence 721 required ORA-00334: archived log: 'D:APPADMINISTRATORORADATAXIFENFEIREDO02.LOG' SQL> D:APPADMINISTRATORORADATAXIFENFEIREDO02.LOG SP2-0734: Unknown command begins 'D:APPADM...' - Ignore the remaining lines. SQL> recover database using backup controlfile ORA-00279: Change 4034899 (generated at 11/27/2018 10:37:04) is required for thread 1 ORA-00289: Suggestions: D:APPADMINISTRATORFAST_RECOVERY_AREAXIFENFEIARCHIVELOG2018_11_27O1_MF_1_721_%U_.ARC ORA-00280: Change 4034899 (for thread 1) in sequence #721 Specify the log: AUTO D:APPADMINISTRATORORADATAXIFENFEIREDO01.LOG Applied log. Complete media recovery. SQL> alter database open resetlogs The database has been changed.

データ0損失回復を実現し、データベースを開いた直後に使用できます