【 alert 日誌報錯資訊】

Thu Jul 02 01:53:28 2015

RFS[3]: Assigned to RFS process 37758

RFS[3]: Selected log 220 for thread 2 sequence 13279 dbid 2048376234 branch 878583729

Archived Log entry 16066 added for thread 2 sequence 13279 ID 0x7bd065cf dest 1:

Media Recovery Log /oradata/archive/1_16612_878583729.dbf

Media Recovery Log /oradata/archive/2_13278_878583729.dbf

Thu Jul 02 01:53:31 2015

RFS[4]: Assigned to RFS process 37764

RFS[4]: Selected log 201 for thread 1 sequence 16613 dbid 2048376234 branch 878583729

Thu Jul 02 01:53:58 2015

Media Recovery Waiting for thread 1 sequence 16613 (in transit)

Media Recovery of Online Log [Thread=1, Seq=16613]

Recovery of Online Redo Log: Thread 1 Group 201 Seq 16613 Reading mem 0

Mem# 0: /oradata/redo/IRRACD/onlinelog/o1_mf_201_1j-X4kRbS_.log

Thu Jul 02 01:54:24 2015

Hex dump of (file 52, block 720409) in trace file /opt/oradiag/diag/rdbms/irracd/irracd1/trace/irracd1_dbw1_37675.trc

Corrupt block relative dba: 0x0d0afe19 (file 52, block 720409)

Bad header found during preparing block for write

Data in bad block:

type: 67 format: 7 rdba: 0x37223a22

last change scn: 0x0acb.8b347985 seq: 0x1 flg: 0x34

spare1: 0x64 spare2: 0x65 spare3: 0x3434

consistency value in tail: 0x79854301

check value in block header: 0xdf5e

computed block checksum: 0x0

Errors in file /opt/oradiag/diag/rdbms/irracd/irracd1/trace/irracd1_dbw1_37675.trc (incident=1536347):

ORA-00600: internal error code, arguments: [kcbzpbuf_1], [4], [1], [], [], [], [], [], [], [], [], []

Incident details in: /opt/oradiag/diag/rdbms/irracd/irracd1/incident/incdir_1536347/irracd1_dbw1_37675_i1536347.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Errors in file /opt/oradiag/diag/rdbms/irracd/irracd1/trace/irracd1_dbw1_37675.trc:

ORA-00600: internal error code, arguments: [kcbzpbuf_1], [4], [1], [], [], [], [], [], [], [], [], []

DBW1 (ospid: 37675): terminating the instance due to error 471

Thu Jul 02 01:54:27 2015

System state dump requested by (instance=1, osid=37675 (DBW1)), summary=[abnormal instance termination].

System State dumped to trace file /opt/oradiag/diag/rdbms/irracd/irracd1/trace/irracd1_diag_37641_20150702015427.trc

Dumping diagnostic data in directory=[cdmp_20150702015427], requested by (instance=1, osid=37675 (DBW1)), summary=[abnormal instance termination].

Instance terminated by DBW1, pid = 37675

【irracd1_dbw1_37675.trc 檔案資訊】

Corrupt block relative dba: 0x0d0afe19 (file 52, block 720409)

Bad header found during preparing block for write

Data in bad block:

type: 67 format: 7 rdba: 0x37223a22

last change scn: 0x0acb.8b347985 seq: 0x1 flg: 0x34

spare1: 0x64 spare2: 0x65 spare3: 0x3434

consistency value in tail: 0x79854301

check value in block header: 0xdf5e

computed block checksum: 0x0

kcra_dump_redo_internal: skipped for critical process

kcbz_try_block_recovery <63, 218824217>: tries=0 max=5 cur=1435773263 last=0

BH (0x9ded71238) file#: 52 rdba: 0x0d0afe19 (52/720409) class: 0 ba: 0x9d3d2c000

set: 110 pool: 3 bsz: 8192 bsi: 0 sflg: 2 pwc: 0,0

dbwrid: 1 obj: 607845 objn: -1 tsn: 63 afn: 52 hint: f

hash: [0x12b5437140,0x12b5437140] lru: [0x9ded714c8,0x9ded71188]

ckptq: [0x9ef3a4c38,0x9ded71098] fileq: [0x9dedb01c8,0x9eecf1ae8] objq: [NULL] objaq: [NULL]

st: MEDIA_RCV md: NULL rsop: 0x12c89eeaf0 tch: 1 le: (nil) rlscn: 0x0acb.8b347985

flags: buffer_dirty being_written only_sequential_access block_written_once

kcra_dump_redo_internal: skipped for critical process

Incident 1536347 created, dump file: /opt/oradiag/diag/rdbms/irracd/irracd1/incident/incdir_1536347/irracd1_dbw1_37675_i1536347.trc

ORA-00600: internal error code, arguments: [kcbzpbuf_1], [4], [1], [], [], [], [], [], [], [], [], []

error 471 detected in background process

ORA-00600: internal error code, arguments: [kcbzpbuf_1], [4], [1], [], [], [], [], [], [], [], [], []

kjzduptcctx: Notifying DIAG for crash event

----- Abridged Call Stack Trace -----

ksedsts()+465<-kjzdssdmp()+267<-kjzduptcctx()+232<-kjzdicrshnfy()+63<-ksuitm()+5570<-ksbrdp()+3507<-opirip()+623<-opidrv()+603<-sou2o()+103<-opimai_real()+250<-ssthrdmain()+265<-main()+201<-__libc_start_main()+253

----- End of Abridged Call Stack Trace -----

*** 2015-07-02 01:54:27.110

DBW1 (ospid: 37675): terminating the instance due to error 471

ksuitm: waiting up to [5] seconds before killing DIAG(37641)

[oracle@irora01 ~]$

【dbv 檢查結果】

[oracle@irora01 ~]$ dbv file=/orassd/data3/order_dat10.dbf

DBVERIFY: Release 11.2.0.4.0 - Production on Thu Jul 2 09:14:05 2015

DBVERIFY - Verification starting : FILE = /orassd/data3/order_dat10.dbf

kdrchk: row is marked as both F and P

prow=0x7fdc174fb493 flag=0x2e

Block Checking: DBA = 218824217, Block Type = KTB-managed data block

data header at 0x7fdc174fb064

kdbchk: bad row tab 0, slot 7

Page 720409 failed with check code 6252

DBVERIFY - Verification complete

Total Pages Examined : 2048000

Total Pages Processed (Data) : 2040956

Total Pages Failing (Data) : 1

Total Pages Processed (Index): 388

Total Pages Failing (Index): 0

Total Pages Processed (Other): 6655

Total Pages Processed (Seg) : 0

Total Pages Failing (Seg) : 0

Total Pages Empty : 1

Total Pages Marked Corrupt : 0

Total Pages Influx : 0

Total Pages Encrypted : 0

Highest block SCN : 2335867086 (2763.2335867086)

[oracle@irora01 ~]$

【處理方法】

1，關閉備庫所有例項。
2，啟動日誌接收節點資料庫例項到 mount 狀態。
3，透過以下 RMAN 命令，從主庫備份出現壞塊的資料檔案到備庫。
rman target sys/"xxxxx"@bj_irracdstb auxiliary sys/"xxxx"@sd_irracdstb

run {
allocate channel d1 type disk ;
allocate channel d2 type disk ;
backup as copy reuse
datafile 52 auxiliary format '/orassd/data3/order_dat10.dbf';
}

4，啟動日誌應用程式，追日誌。

sqlplus 下執行：

ALTER DATABASE RECOVER managed standby database using current logfile disconnect;

5，追平日誌後，取消日誌應用程式，把資料庫更改到 open 狀態。

sqlplus 下執行：

ALTER DATABASE RECOVER managed standby database cancel;

alter database open;

6，再次開啟日誌應用程式，進行資料同步。

sqlplus 下執行：

ALTER DATABASE RECOVER managed standby database using current logfile disconnect;

Oracle 11.2.0.4.4 ADG 備庫資料檔案壞塊處理

相關文章