2024-11-13
断电Bad header found during buffer read (logical check)
alert日志如下：
2024-11-13T11:53:49.551460+08:00
ADVISORY: Please collect redo for investigation of ORA-8103. Use command:
ALTER SYSTEM DUMP REDO scn min 1 scn max 142624571 dba min 11 45954 dba max 11 45954;
Hex dump of (file 11, block 45954) in trace file /home/db/oracle/diag/rdbms/jycaps/jycaps/trace/jycaps_j002_4488.trc
Corrupt block relative dba: 0x02c0b382 (file 11, block 45954)
Bad header found during buffer read (logical check)
Data in bad block:
type: 35 format: 2 rdba: 0x02c0b382
last change scn: 0x0000.0000.078d2119 seq: 0x1 flg: 0x04
spare3: 0x0
consistency value in tail: 0x21192301
check value in block header: 0xb50a
computed block checksum: 0x0
trc日志如下：
[oracle@jyc trace]$ more /home/db/oracle/diag/rdbms/jycaps/jycaps/trace/jycaps_j002_4488.trc
Trace file /home/db/oracle/diag/rdbms/jycaps/jycaps/trace/jycaps_j002_4488.trc
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Build label: RDBMS_12.2.0.1.0_LINUX.X64_170125
ORACLE_HOME: /home/db/oracle/product/12.2.0/dbhome_1
System name: Linux
Node name: jyc
Release: 5.15.0-101.103.2.1.el8uek.x86_64
Version: #2 SMP Mon May 1 20:11:30 PDT 2023
Machine: x86_64
Instance name: jycaps
Redo thread mounted by this instance: 1
Oracle process number: 146
Unix process pid: 4488, image: oracle@jyc (J002)
*** 2024-11-13T11:29:27.821200+08:00
*** SESSION ID:(245.1972) 2024-11-13T11:29:27.821259+08:00
*** CLIENT ID:() 2024-11-13T11:29:27.821274+08:00
*** SERVICE NAME:(SYS$USERS) 2024-11-13T11:29:27.821286+08:00
*** MODULE NAME:() 2024-11-13T11:29:27.821298+08:00
*** ACTION NAME:() 2024-11-13T11:29:27.821306+08:00
*** CLIENT DRIVER:() 2024-11-13T11:29:27.821315+08:00
kgskupdbalance: vt_cpu_cons_time[353465202] greater than threshold[30000000] current_consumed_cpu_time[376625326] exec_start_consumed_tim
e[376625326]exec_start_elapsed_time[908301049]
kgskupdbalance: vt_cpu_cons_time[952932683] greater than threshold[30000000] current_consumed_cpu_time[1329558502] exec_start_consumed_ti
me[1329558502]exec_start_elapsed_time[1263042793]
*** 2024-11-13T11:46:50.312627+08:00
kgskupdbalance: vt_cpu_cons_time[36087431] greater than threshold[30000000] current_consumed_cpu_time[1414643810] exec_start_consumed_tim
e[1414643810]exec_start_elapsed_time[2269316098]
*** 2024-11-13T11:47:20.639522+08:00
kgskupdbalance: vt_cpu_cons_time[30214087] greater than threshold[30000000] current_consumed_cpu_time[1444857897] exec_start_consumed_tim
e[1444857897]exec_start_elapsed_time[2305534168]
*** 2024-11-13T11:48:45.445263+08:00
kgskupdbalance: vt_cpu_cons_time[43079199] greater than threshold[30000000] current_consumed_cpu_time[1529198472] exec_start_consumed_tim
e[1529198472]exec_start_elapsed_time[2377429143]
*** 2024-11-13T11:49:34.426077+08:00
kgskupdbalance: vt_cpu_cons_time[48779990] greater than threshold[30000000] current_consumed_cpu_time[1577982463] exec_start_consumed_tim
e[1577982463]exec_start_elapsed_time[2420681604]
*** 2024-11-13T11:51:38.618074+08:00
kgskupdbalance: vt_cpu_cons_time[79026543] greater than threshold[30000000] current_consumed_cpu_time[1700981808] exec_start_consumed_tim
e[1700981808]exec_start_elapsed_time[2514539633]
*** SESSION ID:(245.1972) 2024-11-13T11:53:49.457642+08:00
OBJD MISMATCH typ=35, seg.obj=0, diskobj=305208, dsflg=0, dsobj=305168, tid=305168, cls=4
kcbz_exec_ckf: check function 0x16fb230 returned error=8103:1
Suspect buffer header:
BH (0x7cfacbef8) file#: 11 rdba: 0x02c0b382 (11/45954) class: 4 ba: 0x7c848c000
set: 72 pool: 3 bsz: 8192 bsi: 0 sflg: 2 pwc: 72,19
dbwrid: 2 obj: 305168 objn: 79395 tsn: [0/8] afn: 11 hint: f
hash: [0x7ffb09828,0x11c674548] lru: [0x7cfacc138,0x11d0e5470]
ckptq: [NULL] fileq: [NULL]
objq: [0x137181be8,0x137181be8] objaq: [0x137181bd8,0x137181bd8]
use: [0x13ad2c248,0x13ad2c248] wait: [NULL]
st: READING md: EXCL tch: 0
flags: only_sequential_access
Printing buffer operation history (latest change first):
cnt: 7
01. sid:05 L122:zgb:set:st 02. sid:05 L830:olq1:clr:WRT+CKT
03. sid:05 L951:zgb:lnk:objq 04. sid:05 L372:zgb:set:MEXCL
05. sid:05 L123:zgb:no:FEN 06. sid:05 L083:zgb:ent:fn
07. sid:00 L203:w_ini_dc:bic:FVB
buffer tsn: 8 rdba: 0x02c0b382 (11/45954)
scn: 0x78d2119 seq: 0x01 flg: 0x04 tail: 0x21192301
frmt: 0x02 chkval: 0xb50a type: 0x23=PAGETABLE SEGMENT HEADER
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x00000007C848C000 to 0x00000007C848E000
7C848C000 0000A223 02C0B382 078D2119 04010000 [#........!......]
7C848C010 0000B50A 00000000 00000000 00000000 [................]
7C848C020 00000000 0000000E 00000070 00000A9C [........p.......]
7C848C030 00000000 00000003 00000008 02C0B383 [................]
7C848C040 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7C848C060 00000003 00000008 02C0B383 00000000 [................]
7C848C070 00000000 00000000 00000000 02C0B380 [................]
7C848C080 02C0B380 00000000 00000000 00000000 [................]
7C848C090 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
7C848C0D0 00000001 00002000 00000000 00001434 [..... ......4...]
7C848C0E0 00000000 02C0B381 00000001 02C0B380 [................]
7C848C0F0 02C0B381 00000000 00000000 00000000 [................]
7C848C100 00000000 00000000 0000000E 00000000 [................]
7C848C110 0004A838 10000000 02C0B380 00000008 [8...............]
7C848C120 0904E340 00000008 02C4B438 00000008 [@.......8.......]
7C848C130 0904E348 00000008 02C4B440 00000008 [H.......@.......]
7C848C140 0906AD98 00000008 02C58330 00000008 [........0.......]
7C848C150 0906ADA8 00000008 02C7A288 00000008 [................]
7C848C160 0906C600 00000008 02C7A290 00000008 [................]
7C848C170 0906C610 00000008 02C7A298 00000008 [................]
7C848C180 0906C648 00000008 00000000 00000000 [H...............]
7C848C190 00000000 00000000 00000000 00000000 [................]
Repeat 145 times
7C848CAB0 02C0B380 02C0B383 02C0B380 0904E340 [............@...]
7C848CAC0 02C4B438 02C4B439 02C4B438 0904E348 [8...9...8...H...]
7C848CAD0 02C4B440 02C4B441 02C4B440 0906AD98 [@...A...@.......]
7C848CAE0 02C58330 02C58331 02C58330 0906ADA8 [0...1...0.......]
7C848CAF0 02C7A288 02C7A289 02C7A288 0906C600 [................]
7C848CB00 02C7A290 02C7A291 02C7A290 0906C610 [................]
7C848CB10 02C7A298 02C7A299 02C7A298 0906C648 [............H...]
7C848CB20 00000000 00000000 00000000 00000000 [................]
Repeat 145 times
7C848D440 00000000 00000000 02C0B381 00000000 [................]
7C848D450 00000000 00000000 00000000 00000000 [................]
Repeat 185 times
7C848DFF0 00000000 00000000 00000000 21192301 [.............#.!]
Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 spare2: 0 #extents: 14 #blocks: 112
last map 0x00000000 #maps: 0 offset: 2716
Highwater:: 0x02c0b383 ext#: 0 blk#: 3 ext size: 8
#blocks in seg. hdr's freelists: 0
#blocks below: 0
mapblk 0x00000000 offset: 0
Unlocked
--------------------------------------------------------
Low HighWater Mark :
Highwater:: 0x02c0b383 ext#: 0 blk#: 3 ext size: 8
#blocks in seg. hdr's freelists: 0
#blocks below: 0
mapblk 0x00000000 offset: 0
Level 1 BMB for High HWM block: 0x02c0b380
Level 1 BMB for Low HWM block: 0x02c0b380
--------------------------------------------------------
Segment Type: 1 nl2: 1 blksz: 8192 fbsz: 0
L2 Array start offset: 0x00001434
First Level 3 BMB: 0x00000000
L2 Hint for inserts: 0x02c0b381
Last Level 1 BMB: 0x02c0b380
Last Level II BMB: 0x02c0b381
Last Level III BMB: 0x00000000
Map Header:: next 0x00000000 #extents: 14 obj#: 305208 flag: 0x10000000
Inc # 0
Extent Map
-----------------------------------------------------------------
0x02c0b380 length: 8
0x0904e340 length: 8
0x02c4b438 length: 8
0x0904e348 length: 8
0x02c4b440 length: 8
0x0906ad98 length: 8
0x02c58330 length: 8
0x0906ada8 length: 8
0x02c7a288 length: 8
0x0906c600 length: 8
0x02c7a290 length: 8
0x0906c610 length: 8
0x02c7a298 length: 8
0x0906c648 length: 8
Auxillary Map
--------------------------------------------------------
Extent 0 : L1 dba: 0x02c0b380 Data dba: 0x02c0b383
Extent 1 : L1 dba: 0x02c0b380 Data dba: 0x0904e340
Extent 2 : L1 dba: 0x02c4b438 Data dba: 0x02c4b439
Extent 3 : L1 dba: 0x02c4b438 Data dba: 0x0904e348
Extent 4 : L1 dba: 0x02c4b440 Data dba: 0x02c4b441
Extent 5 : L1 dba: 0x02c4b440 Data dba: 0x0906ad98
Extent 6 : L1 dba: 0x02c58330 Data dba: 0x02c58331
Extent 7 : L1 dba: 0x02c58330 Data dba: 0x0906ada8
Extent 8 : L1 dba: 0x02c7a288 Data dba: 0x02c7a289
Extent 9 : L1 dba: 0x02c7a288 Data dba: 0x0906c600
Extent 10 : L1 dba: 0x02c7a290 Data dba: 0x02c7a291
Extent 11 : L1 dba: 0x02c7a290 Data dba: 0x0906c610
Extent 12 : L1 dba: 0x02c7a298 Data dba: 0x02c7a299
Extent 13 : L1 dba: 0x02c7a298 Data dba: 0x0906c648
--------------------------------------------------------
Second Level Bitmap block DBAs
--------------------------------------------------------
DBA 1: 0x02c0b381
Dumping Short Stack
ksedsts()+346<-kcbz_exec_ckf_debug()+1422<-kcbz_check_objd_typ()+2471<-kcbzib()+3928<-kcbgtcr()+11080<-ktecgsc()+72<-ktecgetsh()+282<-ktec
gshx()+33<-kteinicnt1()+732<-qertbFetch()+9095<-rwsfcd()+140<-qerhnFetch()+7688<-rwsfcd()+140<-qerltcFetch()+995<-insexe()+731
<-opiexe()+6300<-opipls()+2505<-opiodr()+1229<-rpidrus()+201<-skgmstack()+65<-rpidru()+134<-rpiswu2()+627<-rpidrv()+1540<-psddr0()+473<-ps
dnal()+645<-pevm_EXECC()+287<-pfrinstr_EXECC()+71<-pfrrun_no_tool()+60<-pfrrun()+919<-plsql_run()+756<-peicnt()+288<-kkxexe()+717
<-opiexe()+22531<-opiodr()+1229<-rpidrus()+201<-skgmstack()+65<-rpidru()+134<-rpiswu2()+627<-rpidrv()+1540<-rpiexe()+70<-kkjex1e()+12160<-
kkjex1e_cdb()+439<-kkjsexe()+459<-kkjrdp()+664<-opirip()+1211<-opidrv()+602<-sou2o()+145<-opimai_real()+202<-ssthrdmain()+417
<-main()+262<-__libc_start_main()+229<-5541F689495641D7Cursor valid: 1
Dumping kcb descriptor and buffer header(s):
kcbds 0x7fffaff41590: pdb 0, tsn 8, rdba 0x02c0b382, afn 11, objd 305168, cls 4, tidflg 0x8 0x80 0x0
dsflg 0x0, dsflg2 0x0, lobid 0x0:0, cnt 0, addr 0x0, exf 0x10b24e50, dx 0x0, ctx 0
whr: 'ktewh25: kteinicnt'
env [0x7fffaff414a0]: (scn: 0x000000000880473b xid: 0x0000.000.00000000 uba: 0x00000000.0000.00 statement num=0 parent xid: 0x0000.0
00.00000000 st-scn: 0x0000000000000000 hi-scn: 0x0000000000000000 ma-scn: 0x0000000000000000 flg: 0x00000000)
Dump of buffer cache at level 8 for pdb=0 tsn=8 rdba=46183298
BH (0x7cfacbef8) file#: 11 rdba: 0x02c0b382 (11/45954) class: 4 ba: 0x7c848c000
set: 72 pool: 3 bsz: 8192 bsi: 0 sflg: 2 pwc: 72,19
dbwrid: 2 obj: 305168 objn: 79395 tsn: [0/8] afn: 11 hint: f
hash: [0x7ffb09828,0x11c674548] lru: [0x7cfacc138,0x11d0e5470]
ckptq: [NULL] fileq: [NULL]
objq: [0x137181be8,0x137181be8] objaq: [0x137181bd8,0x137181bd8]
use: [0x13ad2c248,0x13ad2c248] wait: [NULL]
st: READING md: EXCL tch: 0
flags: only_sequential_access
Printing buffer operation history (latest change first):
cnt: 7
01. sid:05 L122:zgb:set:st 02. sid:05 L830:olq1:clr:WRT+CKT
03. sid:05 L951:zgb:lnk:objq 04. sid:05 L372:zgb:set:MEXCL
05. sid:05 L123:zgb:no:FEN 06. sid:05 L083:zgb:ent:fn
07. sid:00 L203:w_ini_dc:bic:FVB
Using State Objects
----------------------------------------
SO: 0x13ad2c1b8, type: 54, owner: 0x109e8c8b8, flag: INIT/-/-/-/0x00 if: 0x1 c: 0x1
proc=0x130e1e1c8, name=buffer handle, file=kcb2.h LINE:3702, pg=0, conuid=0
(buffer) (CR) PR: 0x130e1e1c8 (ospid: 4488, name: oracle@jyc (J002))
FLG: 0x0 SEQ: 0x861927
class bit: 0x0
scan scn: 0x0
cr[0]:
sh[0]:
kcbbfbp: [BH: 0x7cfacbef8, LINK: 0x13ad2c248] pop 0
type: normal pin
where: ktewh25: kteinicnt, why: 0
kcbzib: encounter logical error ORA-8103, try re-reading from other mirror..
cursor valid? 1 makecr 0 line 17955 ds_blk (11, 45954) bh_blk (11, 45954)
kcbds 0x7fffaff41590: pdb 0, tsn 8, rdba 0x02c0b382, afn 11, objd 305168, cls 4, tidflg 0x8 0x80 0x0
dsflg 0x0, dsflg2 0x0, lobid 0x0:0, cnt 0, addr 0x0, exf 0x10b24e50, dx 0x0, ctx 0
whr: 'ktewh25: kteinicnt'
env [0x7fffaff414a0]: (scn: 0x000000000880473b xid: 0x0000.000.00000000 uba: 0x00000000.0000.00 statement num=0 parent xid: 0x0000.0
00.00000000 st-scn: 0x0000000000000000 hi-scn: 0x0000000000000000 ma-scn: 0x0000000000000000 flg: 0x00000000)
BH (0x7cfacbef8) file#: 11 rdba: 0x02c0b382 (11/45954) class: 4 ba: 0x7c848c000
set: 72 pool: 3 bsz: 8192 bsi: 0 sflg: 2 pwc: 72,19
dbwrid: 2 obj: 305168 objn: 79395 tsn: [0/8] afn: 11 hint: f
hash: [0x7ffb09828,0x11c674548] lru: [0x7cfacc138,0x11d0e5470]
ckptq: [NULL] fileq: [NULL]
objq: [0x137181be8,0x137181be8] objaq: [0x137181bd8,0x137181bd8]
use: [0x13ad2c248,0x13ad2c248] wait: [NULL]
st: READING md: EXCL tch: 0
flags: only_sequential_access
Printing buffer operation history (latest change first):
cnt: 7
01. sid:05 L122:zgb:set:st 02. sid:05 L830:olq1:clr:WRT+CKT
03. sid:05 L951:zgb:lnk:objq 04. sid:05 L372:zgb:set:MEXCL
05. sid:05 L123:zgb:no:FEN 06. sid:05 L083:zgb:ent:fn
07. sid:00 L203:w_ini_dc:bic:FVB
Hex dump of (file 11, block 45954)
Dump of memory from 0x00000007C848C000 to 0x00000007C848E000
7C848C000 0000A223 02C0B382 078D2119 04010000 [#........!......]
7C848C010 0000B50A 00000000 00000000 00000000 [................]
7C848C020 00000000 0000000E 00000070 00000A9C [........p.......]
7C848C030 00000000 00000003 00000008 02C0B383 [................]
7C848C040 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7C848C060 00000003 00000008 02C0B383 00000000 [................]
7C848C070 00000000 00000000 00000000 02C0B380 [................]
7C848C080 02C0B380 00000000 00000000 00000000 [................]
7C848C090 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
7C848C0D0 00000001 00002000 00000000 00001434 [..... ......4...]
7C848C0E0 00000000 02C0B381 00000001 02C0B380 [................]
7C848C0F0 02C0B381 00000000 00000000 00000000 [................]
7C848C100 00000000 00000000 0000000E 00000000 [................]
7C848C110 0004A838 10000000 02C0B380 00000008 [8...............]
7C848C120 0904E340 00000008 02C4B438 00000008 [@.......8.......]
7C848C130 0904E348 00000008 02C4B440 00000008 [H.......@.......]
7C848C140 0906AD98 00000008 02C58330 00000008 [........0.......]
7C848C150 0906ADA8 00000008 02C7A288 00000008 [................]
7C848C160 0906C600 00000008 02C7A290 00000008 [................]
7C848C170 0906C610 00000008 02C7A298 00000008 [................]
7C848C180 0906C648 00000008 00000000 00000000 [H...............]
7C848C190 00000000 00000000 00000000 00000000 [................]
Repeat 145 times
7C848CAB0 02C0B380 02C0B383 02C0B380 0904E340 [............@...]
7C848CAC0 02C4B438 02C4B439 02C4B438 0904E348 [8...9...8...H...]
7C848CAD0 02C4B440 02C4B441 02C4B440 0906AD98 [@...A...@.......]
7C848CAE0 02C58330 02C58331 02C58330 0906ADA8 [0...1...0.......]
7C848CAF0 02C7A288 02C7A289 02C7A288 0906C600 [................]
7C848CB00 02C7A290 02C7A291 02C7A290 0906C610 [................]
7C848CB10 02C7A298 02C7A299 02C7A298 0906C648 [............H...]
7C848CB20 00000000 00000000 00000000 00000000 [................]
Repeat 145 times
7C848D440 00000000 00000000 02C0B381 00000000 [................]
7C848D450 00000000 00000000 00000000 00000000 [................]
Repeat 185 times
7C848DFF0 00000000 00000000 00000000 21192301 [.............#.!]
Corrupt block relative dba: 0x02c0b382 (file 11, block 45954)
Bad header found during buffer read (logical check)
Data in bad block:
type: 35 format: 2 rdba: 0x02c0b382
last change scn: 0x0000.0000.078d2119 seq: 0x1 flg: 0x04
spare3: 0x0
consistency value in tail: 0x21192301
check value in block header: 0xb50a
computed block checksum: 0x0
TRCMIR:kcf_reread :start: 45954:0:/home/db/oracle/oradata/jycaps/flexsche_data_01.dbf
TRCMIR:kcf_reread :done : 45954:0:/home/db/oracle/oradata/jycaps/flexsche_data_01.dbf
*** SESSION ID:(245.1972) 2024-11-13T11:53:49.552580+08:00
OBJD MISMATCH typ=35, seg.obj=0, diskobj=305208, dsflg=0, dsobj=305168, tid=305168, cls=4
kcbz_exec_ckf: check function 0x16fb230 returned error=8103:1
Suspect buffer header:
BH (0x7cfacbef8) file#: 11 rdba: 0x02c0b382 (11/45954) class: 4 ba: 0x7c848c000
set: 72 pool: 3 bsz: 8192 bsi: 0 sflg: 2 pwc: 72,19
dbwrid: 2 obj: 305168 objn: 79395 tsn: [0/8] afn: 11 hint: f
hash: [0x7ffb09828,0x11c674548] lru: [0x7cfacc138,0x11d0e5470]
ckptq: [NULL] fileq: [NULL]
objq: [0x137181be8,0x137181be8] objaq: [0x137181bd8,0x137181bd8]
use: [0x13ad2c248,0x13ad2c248] wait: [NULL]
st: READING md: EXCL tch: 0
flags: only_sequential_access
Printing buffer operation history (latest change first):
cnt: 7
01. sid:05 L122:zgb:set:st 02. sid:05 L830:olq1:clr:WRT+CKT
03. sid:05 L951:zgb:lnk:objq 04. sid:05 L372:zgb:set:MEXCL
05. sid:05 L123:zgb:no:FEN 06. sid:05 L083:zgb:ent:fn
07. sid:00 L203:w_ini_dc:bic:FVB
buffer tsn: 8 rdba: 0x02c0b382 (11/45954)
scn: 0x78d2119 seq: 0x01 flg: 0x04 tail: 0x21192301
frmt: 0x02 chkval: 0xb50a type: 0x23=PAGETABLE SEGMENT HEADER
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x00000007C848C000 to 0x00000007C848E000
7C848C000 0000A223 02C0B382 078D2119 04010000 [#........!......]
7C848C010 0000B50A 00000000 00000000 00000000 [................]
7C848C020 00000000 0000000E 00000070 00000A9C [........p.......]
7C848C030 00000000 00000003 00000008 02C0B383 [................]
7C848C040 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7C848C060 00000003 00000008 02C0B383 00000000 [................]
7C848C070 00000000 00000000 00000000 02C0B380 [................]
7C848C080 02C0B380 00000000 00000000 00000000 [................]
7C848C090 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
7C848C0D0 00000001 00002000 00000000 00001434 [..... ......4...]
7C848C0E0 00000000 02C0B381 00000001 02C0B380 [................]
7C848C0F0 02C0B381 00000000 00000000 00000000 [................]
7C848C100 00000000 00000000 0000000E 00000000 [................]
7C848C110 0004A838 10000000 02C0B380 00000008 [8...............]
7C848C120 0904E340 00000008 02C4B438 00000008 [@.......8.......]
7C848C130 0904E348 00000008 02C4B440 00000008 [H.......@.......]
7C848C140 0906AD98 00000008 02C58330 00000008 [........0.......]
7C848C150 0906ADA8 00000008 02C7A288 00000008 [................]
7C848C160 0906C600 00000008 02C7A290 00000008 [................]
7C848C170 0906C610 00000008 02C7A298 00000008 [................]
7C848C180 0906C648 00000008 00000000 00000000 [H...............]
7C848C190 00000000 00000000 00000000 00000000 [................]
Repeat 145 times
7C848CAB0 02C0B380 02C0B383 02C0B380 0904E340 [............@...]
7C848CAC0 02C4B438 02C4B439 02C4B438 0904E348 [8...9...8...H...]
7C848CAD0 02C4B440 02C4B441 02C4B440 0906AD98 [@...A...@.......]
7C848CAE0 02C58330 02C58331 02C58330 0906ADA8 [0...1...0.......]
7C848CAF0 02C7A288 02C7A289 02C7A288 0906C600 [................]
7C848CB00 02C7A290 02C7A291 02C7A290 0906C610 [................]
7C848CB10 02C7A298 02C7A299 02C7A298 0906C648 [............H...]
7C848CB20 00000000 00000000 00000000 00000000 [................]
Repeat 145 times
7C848D440 00000000 00000000 02C0B381 00000000 [................]
7C848D450 00000000 00000000 00000000 00000000 [................]
Repeat 185 times
7C848DFF0 00000000 00000000 00000000 21192301 [.............#.!]
Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 spare2: 0 #extents: 14 #blocks: 112
last map 0x00000000 #maps: 0 offset: 2716
Highwater:: 0x02c0b383 ext#: 0 blk#: 3 ext size: 8
#blocks in seg. hdr's freelists: 0
#blocks below: 0
mapblk 0x00000000 offset: 0
Unlocked
--------------------------------------------------------
Low HighWater Mark :
Highwater:: 0x02c0b383 ext#: 0 blk#: 3 ext size: 8
#blocks in seg. hdr's freelists: 0
#blocks below: 0
mapblk 0x00000000 offset: 0
Level 1 BMB for High HWM block: 0x02c0b380
Level 1 BMB for Low HWM block: 0x02c0b380
--------------------------------------------------------
Segment Type: 1 nl2: 1 blksz: 8192 fbsz: 0
L2 Array start offset: 0x00001434
First Level 3 BMB: 0x00000000
L2 Hint for inserts: 0x02c0b381
Last Level 1 BMB: 0x02c0b380
Last Level II BMB: 0x02c0b381
Last Level III BMB: 0x00000000
Map Header:: next 0x00000000 #extents: 14 obj#: 305208 flag: 0x10000000
Inc # 0
Extent Map
-----------------------------------------------------------------
0x02c0b380 length: 8
0x0904e340 length: 8
0x02c4b438 length: 8
0x0904e348 length: 8
0x02c4b440 length: 8
0x0906ad98 length: 8
0x02c58330 length: 8
0x0906ada8 length: 8
0x02c7a288 length: 8
0x0906c600 length: 8
0x02c7a290 length: 8
0x0906c610 length: 8
0x02c7a298 length: 8
0x0906c648 length: 8
Auxillary Map
--------------------------------------------------------
Extent 0 : L1 dba: 0x02c0b380 Data dba: 0x02c0b383
Extent 1 : L1 dba: 0x02c0b380 Data dba: 0x0904e340
Extent 2 : L1 dba: 0x02c4b438 Data dba: 0x02c4b439
Extent 3 : L1 dba: 0x02c4b438 Data dba: 0x0904e348
Extent 4 : L1 dba: 0x02c4b440 Data dba: 0x02c4b441
Extent 5 : L1 dba: 0x02c4b440 Data dba: 0x0906ad98
Extent 6 : L1 dba: 0x02c58330 Data dba: 0x02c58331
Extent 7 : L1 dba: 0x02c58330 Data dba: 0x0906ada8
Extent 8 : L1 dba: 0x02c7a288 Data dba: 0x02c7a289
Extent 9 : L1 dba: 0x02c7a288 Data dba: 0x0906c600
Extent 10 : L1 dba: 0x02c7a290 Data dba: 0x02c7a291
Extent 11 : L1 dba: 0x02c7a290 Data dba: 0x0906c610
Extent 12 : L1 dba: 0x02c7a298 Data dba: 0x02c7a299
Extent 13 : L1 dba: 0x02c7a298 Data dba: 0x0906c648
--------------------------------------------------------
Second Level Bitmap block DBAs
--------------------------------------------------------
DBA 1: 0x02c0b381
Dumping Short Stack
ksedsts()+346<-kcbz_exec_ckf_debug()+1422<-kcbz_check_objd_typ()+2471<-kcbzib()+3928<-kcbgtcr()+11080<-ktecgsc()+72<-ktecgetsh()+282<-ktec
gshx()+33<-kteinicnt1()+732<-qertbFetch()+9095<-rwsfcd()+140<-qerhnFetch()+7688<-rwsfcd()+140<-qerltcFetch()+995<-insexe()+731
<-opiexe()+6300<-opipls()+2505<-opiodr()+1229<-rpidrus()+201<-skgmstack()+65<-rpidru()+134<-rpiswu2()+627<-rpidrv()+1540<-psddr0()+473<-ps
dnal()+645<-pevm_EXECC()+287<-pfrinstr_EXECC()+71<-pfrrun_no_tool()+60<-pfrrun()+919<-plsql_run()+756<-peicnt()+288<-kkxexe()+717
<-opiexe()+22531<-opiodr()+1229<-rpidrus()+201<-skgmstack()+65<-rpidru()+134<-rpiswu2()+627<-rpidrv()+1540<-rpiexe()+70<-kkjex1e()+12160<-
kkjex1e_cdb()+439<-kkjsexe()+459<-kkjrdp()+664<-opirip()+1211<-opidrv()+602<-sou2o()+145<-opimai_real()+202<-ssthrdmain()+417
<-main()+262<-__libc_start_main()+229<-5541F689495641D7Cursor valid: 1
Dumping kcb descriptor and buffer header(s):
kcbds 0x7fffaff41590: pdb 0, tsn 8, rdba 0x02c0b382, afn 11, objd 305168, cls 4, tidflg 0x8 0x80 0x0
dsflg 0x0, dsflg2 0x0, lobid 0x0:0, cnt 0, addr 0x0, exf 0x10b24e50, dx 0x0, ctx 0
whr: 'ktewh25: kteinicnt'
env [0x7fffaff414a0]: (scn: 0x000000000880473b xid: 0x0000.000.00000000 uba: 0x00000000.0000.00 statement num=0 parent xid: 0x0000.0
00.00000000 st-scn: 0x0000000000000000 hi-scn: 0x0000000000000000 ma-scn: 0x0000000000000000 flg: 0x00000000)
Dump of buffer cache at level 8 for pdb=0 tsn=8 rdba=46183298
BH (0x7cfacbef8) file#: 11 rdba: 0x02c0b382 (11/45954) class: 4 ba: 0x7c848c000
set: 72 pool: 3 bsz: 8192 bsi: 0 sflg: 2 pwc: 72,19
dbwrid: 2 obj: 305168 objn: 79395 tsn: [0/8] afn: 11 hint: f
hash: [0x7ffb09828,0x11c674548] lru: [0x7cfacc138,0x11d0e5470]
ckptq: [NULL] fileq: [NULL]
objq: [0x137181be8,0x137181be8] objaq: [0x137181bd8,0x137181bd8]
use: [0x13ad2c248,0x13ad2c248] wait: [NULL]
st: READING md: EXCL tch: 0
flags: only_sequential_access
Printing buffer operation history (latest change first):
cnt: 7
01. sid:05 L122:zgb:set:st 02. sid:05 L830:olq1:clr:WRT+CKT
03. sid:05 L951:zgb:lnk:objq 04. sid:05 L372:zgb:set:MEXCL
05. sid:05 L123:zgb:no:FEN 06. sid:05 L083:zgb:ent:fn
07. sid:00 L203:w_ini_dc:bic:FVB
Using State Objects
----------------------------------------
SO: 0x13ad2c1b8, type: 54, owner: 0x109e8c8b8, flag: INIT/-/-/-/0x00 if: 0x1 c: 0x1
proc=0x130e1e1c8, name=buffer handle, file=kcb2.h LINE:3702, pg=0, conuid=0
(buffer) (CR) PR: 0x130e1e1c8 (ospid: 4488, name: oracle@jyc (J002))
FLG: 0x0 SEQ: 0x861927
class bit: 0x0
scan scn: 0x0
cr[0]:
sh[0]:
kcbbfbp: [BH: 0x7cfacbef8, LINK: 0x13ad2c248] pop 0
type: normal pin
where: ktewh25: kteinicnt, why: 0
[oracle@jyc trace]$
检查结果如下：
没有对应的对象。找不到，如何处理？
SQL*Plus: Release 12.2.0.1.0 Production on Wed Nov 13 12:50:55 2024
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> set line 180
SQL> set wrap off
SQL> SELECT segment_name,segment_type,extent_id,block_id, blocks
2 from dba_extents t
3 where file_id = 11
4 AND 45954 between block_id and (block_id + blocks - 1) ;
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
no rows selected
SQL> select * from v$database_block_corruption;
no rows selected
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@jyc ~]$ rman target /
Recovery Manager: Release 12.2.0.1.0 - Production on Wed Nov 13 13:00:16 2024
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
connected to target database: RSBAPS (DBID=2374181147)
RMAN> backup validate check logical datafile 11;
Starting backup at 2024-11-13 13:00:33
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1576 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00011 name=/home/db/oracle/oradata/jycaps/flexsche_data_01.dbf
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
11 OK 0 61722 584192 142624575
File Name: /home/db/oracle/oradata/jycaps/flexsche_data_01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 422086
Index 0 93792
Other 0 6592
Finished backup at 2024-11-13 13:01:39
RMAN> select * from v$database_block_corruption;
no rows selected
[oracle@jyc trace]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Wed Nov 13 12:55:26 2024
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> set line 160
SQL> set wrap off
SQL> select object_name,object_type,owner from dba_objects where object_id=305168;
rows will be truncated
rows will be truncated
no rows selected
SQL> select object_name,object_type,owner from dba_objects where object_id=305208;
rows will be truncated
rows will be truncated
no rows selected
SQL> select object_name,object_type,owner from dba_objects where object_id=79395;
rows will be truncated
rows will be truncated
OBJECT_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------
FLE_CHANGETIME_BACK
SQL> col object_name for a20
SQL> r
1* select object_name,object_type,owner from dba_objects where object_id=79395
OBJECT_NAME OBJECT_TYPE OWNER
-------------------- ---------------------------------------------- --------------------------------------------------------------------------------------------
FLE_CHANGETIME_BACK TABLE JYC
SQL> select count(*) from JYC.FLE_CHANGETIME_BACK;
select count(*) from JYC.FLE_CHANGETIME_BACK
*
ERROR at line 1:
ORA-08103: object no longer exists
SQL>
找不到对象，如何解决？
我来答
添加附件
收藏
分享
问题补充
5条回答
默认
最新
评论
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签，敬请期待~~
墨值悬赏