ORA-00322 ORA-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 ???

ใช้หนึ่งในไฟล์ควบคุมเพื่อเริ่มรายงานฐานข้อมูลข้อผิดพลาด ORA-00322 ORA-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-00322 ORA-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 ผลลัพธ์ฐานข้อมูลการตรวจสอบสคริปต์
datafile-header
ไฟล์บันทึก


จะเห็นได้จากสิ่งนี้ว่าการทำซ้ำที่ฐานข้อมูลต้องการคือ 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 การสูญเสียสามารถใช้งานได้โดยตรงหลังจากเปิดฐานข้อมูล