重庆思庄Oracle、Redhat认证学习论坛

标题: Bug 31104809 - ORA-600: [kcbr_apply_change_11] during adg recovery [打印本页]

作者: 刘泽宇 时间: 2023-7-16 00:44
标题: Bug 31104809 - ORA-600: [kcbr_apply_change_11] during adg recovery
在DG备库开启日志应用后出现报错ORA-600 [kcbr_apply_change_11] during Active Data Guard (ADG) media recovery.
ORA-600 [kcbr_apply_change_11] during Active Data Guard (ADG) media recovery due to two identical change vectors with the same scn to format  the same block
in ASSM tablespace

REDISCOVERY INFORMATION:
- ORA-600 [kcbr_apply_change_11] during Active Data Guard (ADG) media
recovery.
- The affected datafile tablespace is ASSM (Automatic Segment Space
Management).
- The ORA-600 [kcbr_apply_change_11] trace file shows that the error is due
to two identical change vectors with the same scn to format the same block in
ASSM tablespace with operation code OP:13.21 / function ktspbfredo - Format
Pagetable Datablock:

REDO RECORD - Thread:2 RBA: 0x001c1d.0069a7b8.00a0 LEN: 0x0064 VLD: 0x01
CON_UID: 3428113596
SCN: 0x00000d73379d9876 SUBSCN:  1 03/31/2020 00:24:15
(LWN RBA: 0x001c1d.0069a7b8.0010 LEN: 0x00000072 NST: 0x0001 SCN:
0x00000d73379d9873)
CHANGE #1 CON_ID:3 TYP:1 CLS:1 AFN:13 DBA:0x0489fc31 OBJ:255643
SCN:0x00000d73379d8d90 SEQ:1 OP:13.21 ENC:0 RBL:0 FLG:0x0000
ktspbfredo - Format Pagetable Datablock
Parent(l1) DBA:  0x0489e007 typ: 1 objd: 255643 itls: 2 fmt_flag: 0 poff: 0
  cscn: 0x00000d73379d9876 inc#:0

REDO RECORD - Thread:2 RBA: 0x001c1d.0069a7bb.0110 LEN: 0x0064 VLD: 0x01
CON_UID: 3428113596
SCN: 0x00000d73379d9876 SUBSCN:  1 03/31/2020 00:24:15
CHANGE #1 CON_ID:3 TYP:1 CLS:1 AFN:13 DBA:0x0489fc31 OBJ:255643
SCN:0x00000d73379d9876 SEQ:1 OP:13.21 ENC:0 RBL:0 FLG:0x0000
ktspbfredo - Format Pagetable Datablock
Parent(l1) DBA:  0x0489e007 typ: 1 objd: 255643 itls: 2 fmt_flag: 0 poff: 0
  cscn: 0x00000d73379d9876 inc#:0

.
WORKAROUND:
In ADG, mount the database (do not open it) and restart media recovery; once
the affected redo log sequence is applied, open the ADG in read only mode.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)