RC: Trace과다생성 문의 ( Error ORA-1410 ) (Doc ID 2573513.1)

Last updated on MARCH 14, 2023

Applies to:

Symptoms

아래의 메시지 관련된 trace 가 과다 현상이 발생함.

On : 18.5.0.0.0 version, Corruption
 

ERROR
-----------------------
Trace file /log/diag/rdbms/DBNAME/DBNAME/trace/DBNAME_p000_89718.trc <<<<<<<<<<-- file# 224, obj: 44484008 objn: 44484008 임!!
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.5.0.0.0
Build label: RDBMS_18.1.0.0.0_LINUX.X64_180103.1
ORACLE_HOME: /u01/app/oracle/product/18.0.0.0/dbHome_1
System name: Linux
Node name: DBNAMEdb77.####.com
Release: 4.1.12-124.24.3.el6uek.x86_64
Version: #2 SMP Mon Jan 14 15:08:09 PST 2019
Machine: x86_64
Storage: Exadata
Instance name: DBNAME
Redo thread mounted by this instance: 7
Oracle process number: 84
Unix process pid: 89718, image: oracle@DBNAMEdb77.####.com (P000)

*** 2019-07-26T12:35:38.439220+09:00
*** SESSION ID:(26322.47490) 2019-07-26T12:35:38.439242+09:00
*** CLIENT ID:() 2019-07-26T12:35:38.439248+09:00
*** SERVICE NAME:(SYS$BACKGROUND) 2019-07-26T12:35:38.439254+09:00
*** MODULE NAME:() 2019-07-26T12:35:38.439260+09:00
*** ACTION NAME:() 2019-07-26T12:35:38.439265+09:00
*** CLIENT DRIVER:() 2019-07-26T12:35:38.439270+09:00

*** TRACE FILE RECREATED AFTER BEING REMOVED ***

kcbzib: encounter logical error ORA-1410, try re-reading from other mirror..
cursor valid? 1 warm_up abort 0 makecr 0 line 18445
kcbds 0x7fffa0792970: pdb 0, tsn 1170, rdba 0x0266cde3, afn 224, objd 44484008, cls 1, tidflg 0x0 0x0 0x0
dsflg 0x8000, dsflg2 0x8000, lobid 0x0:0, cnt 0, addr 0x0, exf 0x0, dx 0x0, ctx 0
whr: 'kdiwh27: kdiulk'
BH (0x13cf08b258) file#: 224 rdba: 0x0266cde3 (1024/40291811) class: 1 ba: 0x13c88b6000
set: 193 pool: 3 bsz: 8192 bsi: 0 sflg: 0 pwc: 0,25
dbwrid: 0 obj: 44484008 objn: 44484008 tsn: [0/1170] afn: 224 hint: f
hash: [0x1aa738708,0x1aa738708] lru: [0x145ee4b8c0,0x13df07cae0]
ckptq: [NULL] fileq: [NULL]
objq: [0x116ee592a8,0x6d057dcb8] objaq: [0x37f3983b8,0x6d057dca8]
use: [0x188cfc788,0x188cfc788] wait: [NULL]
st: READING md: EXCL tch: 0 le: 0x13ff876330
flags: only_sequential_access
Printing buffer operation history (latest change first):
cnt: 4
01. sid:02 L122:zgb:set:st 02. sid:02 L830:olq1:clr:WRT+CKT
03. sid:02 L951:zgb:lnk:objq 04. sid:02 L372:zgb:set:MEXCL
05. sid:02 L123:zgb:no:FEN 06. sid:02 L083:zgb:ent:fn
07. sid:12 L778:chg1_mn:bis:FMS 08. sid:12 L325:chg1:set:MEXCL
09. sid:02 L122:zgb:set:st 10. sid:02 L123:zgb:no:FEN
11. sid:02 L371:zgb:set:MEXCL 12. sid:02 L896:z_mkfr:ulnk:objq
13. sid:02 L083:zgb:ent:fn 14. sid:01 L836:z_age_hot:mv:cld
15. sid:12 L836:z_age_hot:mv:cld 16. sid:01 L836:z_age_hot:mv:cld
......
ksfdafReadMirror: Read success from mirror side=1 logical extent number=0 disk=DATAC1_CD_11_DBNAMECL82 path=o/nnn.nnn.nnn.49;nnn.nnn.nnn.50/DATAC1_CD_11_DBNAMEcl82
Mirror I/O done from ASM disk o/nnn.nnn.nnn.49;nnn.nnn.nnn.50/DATAC1_CD_11_DBNAMEcl82
ksfdrnms:Mirror Read file=+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399 fob=0x180ba8f8 bufp=0x7f55110b2000 nbytes=8192
TRCMIR:- ksfdrnms :next :40318566:2:+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399
TRCMIR: - ksfdaf :next :40318566:2:+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399
ksfdafReadMirror: Read success from mirror side=2 logical extent number=1 disk=DATAC1_CD_11_DBNAMECL80 path=o/nnn.nnn.nnn.45;nnn.nnn.nnn.46/DATAC1_CD_11_DBNAMEcl80
Mirror I/O done from ASM disk o/nnn.nnn.nnn.45;nnn.nnn.nnn.46/DATAC1_CD_11_DBNAMEcl80
ksfdrnms:Mirror Read file=+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399 fob=0x180ba8f8 bufp=0x7f55110b2000 nbytes=8192
TRCMIR:- ksfdrnms :next :40318566:3:+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399
TRCMIR: - ksfdaf :next :40318566:3:+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399
TRCMIR:kcf_reread :done :40318566:0:+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399
kcbzib: encounter logical error ORA-1410, try re-reading from other mirror..
cursor valid? 1 warm_up abort 0 makecr 0 line 18445
kcbds 0x7fffa0792970: pdb 0, tsn 1170, rdba 0x02667083, afn 224, objd 44484008, cls 1, tidflg 0x0 0x0 0x0
dsflg 0x8000, dsflg2 0x8000, lobid 0x0:0, cnt 0, addr 0x0, exf 0x0, dx 0x0, ctx 0
whr: 'kdiwh27: kdiulk'
BH (0x121ee985f8) file#: 224 rdba: 0x02667083 (1024/40267907) class: 1 ba: 0x1216258000
set: 216 pool: 3 bsz: 8192 bsi: 0 sflg: 0 pwc: 0,25
dbwrid: 11 obj: 44484008 objn: 44484008 tsn: [0/1170] afn: 224 hint: f
hash: [0x33f28a5a8,0x17add8628] lru: [0x11feee15a0,0x125ece6dc0]
ckptq: [NULL] fileq: [NULL]
objq: [0x119f0cf428,0x6d0294bd8] objaq: [0x119f0cf438,0x6d0294bc8]
use: [0x188cfc788,0x188cfc788] wait: [NULL]
st: READING md: EXCL tch: 0 le: 0x115ff03330
flags: only_sequential_access
Printing buffer operation history (latest change first):
......
kcbzib: encounter logical error ORA-1410, try re-reading from other mirror..
cursor valid? 1 warm_up abort 0 makecr 0 line 18445
kcbds 0x7fffa0792970: pdb 0, tsn 1170, rdba 0x02669d8c, afn 224, objd 44484008, cls 1, tidflg 0x0 0x0 0x0
dsflg 0x8000, dsflg2 0x8000, lobid 0x0:0, cnt 0, addr 0x0, exf 0x0, dx 0x0, ctx 0
whr: 'kdiwh27: kdiulk'
BH (0x12aec8e238) file#: 224 rdba: 0x02669d8c (1024/40279436) class: 1 ba: 0x12a3a2c000
set: 218 pool: 3 bsz: 8192 bsi: 0 sflg: 0 pwc: 0,25
dbwrid: 1 obj: 44484008 objn: 44484008 tsn: [0/1170] afn: 224 hint: f
hash: [0x178a6d458,0x178a6d458] lru: [0x12dec2bae0,0x141f30fd20]
ckptq: [NULL] fileq: [NULL]
objq: [0x115f194e68,0x58b98db80] objaq: [0x33ef970f8,0x58b98db70]
use: [0x188cfc788,0x188cfc788] wait: [NULL]
st: READING md: EXCL tch: 0 le: 0x120fdd9640
flags: only_sequential_access
......
TRCMIR:kcf_reread :start:40264554:0:+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399
TRCMIR:kcf_reread :first:40264554:1:+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399
ksfdrfms:Mirror Read file=+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399 fob=0x180ba8f8 bufp=0x7f55110b2000 blkno=40264554 nbytes=8192
TRCMIR:- ksfdrfms :first:40264554:1:+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399
TRCMIR: - ksfdaf :first:40264554:1:+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399
ksfdafReadMirror: Read success from mirror side=1 logical extent number=0 disk=DATAC1_CD_06_DBNAMECL81 path=o/nnn.nnn.nnn.47;nnn.nnn.nnn.48/DATAC1_CD_06_DBNAMEcl81
Mirror I/O done from ASM disk o/nnn.nnn.nnn.47;nnn.nnn.nnn.48/DATAC1_CD_06_DBNAMEcl81
ksfdrnms:Mirror Read file=+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399 fob=0x180ba8f8 bufp=0x7f55110b2000 nbytes=8192
TRCMIR:- ksfdrnms :next :40264554:2:+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399
TRCMIR: - ksfdaf :next :40264554:2:+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399
ksfdafReadMirror: Read success from mirror side=2 logical extent number=1 disk=DATAC1_CD_06_DBNAMECL82 path=o/nnn.nnn.nnn.49;nnn.nnn.nnn.50/DATAC1_CD_06_DBNAMEcl82
Mirror I/O done from ASM disk o/nnn.nnn.nnn.49;nnn.nnn.nnn.50/DATAC1_CD_06_DBNAMEcl82
ksfdrnms:Mirror Read file=+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399 fob=0x180ba8f8 bufp=0x7f55110b2000 nbytes=8192
TRCMIR:- ksfdrnms :next :40264554:3:+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399
TRCMIR: - ksfdaf :next :40264554:3:+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399
TRCMIR:kcf_reread :done :40264554:0:+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399
kcbzib: encounter logical error ORA-1410, try re-reading from other mirror..
cursor valid? 1 warm_up abort 0 makecr 0 line 18445
kcbds 0x7fffa0792970: pdb 0, tsn 1170, rdba 0x0266fe2d, afn 224, objd 44484008, cls 1, tidflg 0x0 0x0 0x0
dsflg 0x8000, dsflg2 0x8000, lobid 0x0:0, cnt 0, addr 0x0, exf 0x0, dx 0x0, ctx 0
whr: 'kdiwh27: kdiulk'
BH (0x135f2e1598) file#: 224 rdba: 0x0266fe2d (1024/40304173) class: 1 ba: 0x135b6ba000
set: 194 pool: 3 bsz: 8192 bsi: 0 sflg: 0 pwc: 0,25
dbwrid: 1 obj: 44484008 objn: 44484008 tsn: [0/1170] afn: 224 hint: f
hash: [0x1aae08688,0x1aae08688] lru: [0x124eb88fa0,0x133f303060]
ckptq: [NULL] fileq: [NULL]
objq: [0x118ee31a88,0x6d02960d8] objaq: [0x118ee31a98,0x6d02960c8]
use: [0x188cfc788,0x188cfc788] wait: [NULL]
st: READING md: EXCL tch: 0 le: 0x4dfb7f390
flags: only_sequential_access
Printing buffer operation history (latest change first):
cnt: 2
01. sid:02 L122:zgb:set:st 02. sid:02 L830:olq1:clr:WRT+CKT
03. sid:02 L951:zgb:lnk:objq 04. sid:02 L372:zgb:set:MEXCL
05. sid:02 L123:zgb:no:FEN 06. sid:02 L896:z_mkfr:ulnk:objq
07. sid:02 L083:zgb:ent:fn 08. sid:09 L192:kcbbic2:bic:FBD
09. sid:09 L191:kcbbic2:bic:FBW 10. sid:09 L822:bic1_int:ent:rtn
11. sid:09 L832:oswmqbg1:clr:WRT 12. sid:09 L930:kubc:sw:mq
......
kcbzib: encounter logical error ORA-1410, try re-reading from other mirror..
cursor valid? 1 warm_up abort 0 makecr 0 line 18445
kcbds 0x7fffa0792970: pdb 0, tsn 1170, rdba 0x0266ebf0, afn 224, objd 44484008, cls 1, tidflg 0x0 0x0 0x0
dsflg 0x8000, dsflg2 0x8000, lobid 0x0:0, cnt 0, addr 0x0, exf 0x0, dx 0x0, ctx 0
whr: 'kdiwh27: kdiulk'
BH (0x127efb91d8) file#: 224 rdba: 0x0266ebf0 (1024/40299504) class: 1 ba: 0x127788e000
set: 241 pool: 3 bsz: 8192 bsi: 0 sflg: 0 pwc: 0,25
dbwrid: 0 obj: 44484008 objn: 44484008 tsn: [0/1170] afn: 224 hint: f
hash: [0x11deaffda8,0x19c113f48] lru: [0x12deef9ee0,0x11cf260d40]
ckptq: [NULL] fileq: [NULL]
objq: [0x144f441d68,0x5d14a54e8] objaq: [0x11ef20e938,0x5d14a54d8]
use: [0x188cfc788,0x188cfc788] wait: [NULL]
st: READING md: EXCL tch: 0 le: 0x12ef9a3890
flags: only_sequential_access
Printing buffer operation history (latest change first):
......
TRCMIR:kcf_reread :start:40299504:0:+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399
TRCMIR:kcf_reread :first:40299504:1:+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399
ksfdrfms:Mirror Read file=+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399 fob=0x180ba8f8 bufp=0x7f55110b2000 blkno=40299504 nbytes=8192
TRCMIR:- ksfdrfms :first:40299504:1:+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399
TRCMIR: - ksfdaf :first:40299504:1:+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399
ksfdafReadMirror: Read success from mirror side=1 logical extent number=0 disk=DATAC1_CD_01_DBNAMECL77 path=o/nnn.nnn.nnn.39;nnn.nnn.nnn.40/DATAC1_CD_01_DBNAMEcl77
Mirror I/O done from ASM disk o/nnn.nnn.nnn.39;nnn.nnn.nnn.40/DATAC1_CD_01_DBNAMEcl77
ksfdrnms:Mirror Read file=+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399 fob=0x180ba8f8 bufp=0x7f55110b2000 nbytes=8192
TRCMIR:- ksfdrnms :next :40299504:2:+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399
TRCMIR: - ksfdaf :next :40299504:2:+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399
ksfdafReadMirror: Read success from mirror side=2 logical extent number=1 disk=DATAC1_CD_11_DBNAMECL76 path=o/nnn.nnn.nnn.37;nnn.nnn.nnn.38/DATAC1_CD_11_DBNAMEcl76
Mirror I/O done from ASM disk o/nnn.nnn.nnn.37;nnn.nnn.nnn.38/DATAC1_CD_11_DBNAMEcl76
ksfdrnms:Mirror Read file=+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399 fob=0x180ba8f8 bufp=0x7f55110b2000 nbytes=8192
TRCMIR:- ksfdrnms :next :40299504:3:+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399
TRCMIR: - ksfdaf :next :40299504:3:+DATAC1/DBNAME/datafile/ts_DBNAME_proe_pi003.865.1005881399
TRCMIR:kcf_reread :done

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.