诊断事件:Event 10015
Event 10015是我们在诊断过程中比较常用的事件,主要用来处理在cache recovery过程中数据库启动挂起或者ora-600错误,特别是涉及到事务恢复阶段的ora-600错误。
语法:
event=”10015 trace name context forever,level 10″
Rec rollback segment _SYSSMU9$
UNDO SEG (BEFORE RECOVERY): usn = 9 Extent Control Header
—————————————————————–
Extent Header:: spare1: 0 spare2: 0 #extents: 4 #blocks: 1167
last map 0×00000000 #maps: 0 offset: 4080
Highwater:: 0×008019a1 ext#: 2 blk#: 24 ext size: 128
#blocks in seg. hdr’s freelists: 0
#blocks below: 0
mapblk 0×00000000 offset: 2
Unlocked
Map Header:: next 0×00000000 #extents: 4 obj#: 0 flag: 0×40000000
Extent Map
—————————————————————–
0×0080008a length: 7
0×00801db1 length: 8
0×00801989 length: 128
0×00814989 length: 1024
Retention Table
———————————————————–
Extent Number:0 Commit Time: 1271133965
Extent Number:1 Commit Time: 1271135332
Extent Number:2 Commit Time: 1268272679
Extent Number:3 Commit Time: 1271133965
TRN CTL:: seq: 0×0b10 chd: 0×0024 ctl: 0×002d inc: 0×00000000 nfb: 0×0001
mgc: 0×8201 xts: 0×0068 flg: 0×0001 opt: 2147483646 (0×7ffffffe)
uba: 0×008019a1.0b10.02 scn: 0×09ce.8fb30131
Version: 0×01
FREE BLOCK POOL::
uba: 0×008019a1.0b10.02 ext: 0×2 spc: 0×1f3a
uba: 0×00000000.0b10.11 ext: 0×2 spc: 0×19e0
uba: 0×00000000.0b10.0b ext: 0×2 spc: 0×1884
uba: 0×00000000.0b09.01 ext: 0×2 spc: 0×1f88
uba: 0×00000000.0b09.01 ext: 0×2 spc: 0×1f88
TRN TBL::
index state cflags wrap# uel scn dba parent-xid nub stmt_num cmt
————————————————————————————————
0×00 9 0×00 0×180b 0×0001 0×09ce.8fb30327 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140808
0×01 9 0×00 0×1807 0×0022 0×09ce.8fb30333 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140808
0×02 9 0×00 0×1807 0×002f 0×09ce.8fb3038c 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140809
0×03 9 0×00 0×1809 0×0002 0×09ce.8fb3037a 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140809
0×04 9 0×00 0×1808 0×000c 0×09ce.8fb30239 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140687
0×05 9 0×00 0×1803 0×000d 0×09ce.8fb303ad 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140809
0×06 9 0×00 0×180a 0×0000 0×09ce.8fb30322 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140808
0×07 9 0×00 0×1800 0×001c 0×09ce.8fb3045d 0×008019a0 0×0000.000.00000000 0×00000001 0×00000000 1271140873
0×08 9 0×00 0×180a 0×0006 0×09ce.8fb30318 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140808
0×09 9 0×00 0×1725 0×0027 0×09ce.8fb302c6 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140747
0×0a 9 0×00 0×1809 0×002c 0×09ce.8fb30355 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140809
0×0b 9 0×00 0×180a 0×0020 0×09ce.8fb303d4 0×008019a0 0×0000.000.00000000 0×00000001 0×00000000 1271140809
0×0c 9 0×00 0×17fa 0×000f 0×09ce.8fb30245 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140687
0×0d 9 0×00 0×1809 0×0029 0×09ce.8fb303b9 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140809
0×0e 10 0×90 0×1809 0×0002 0×09ce.8fb304a9 0×008019a0 0×0000.000.00000000 0×00000001 0×00000000 0
0×0f 9 0×00 0×1802 0×001f 0×09ce.8fb30269 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140744
0×10 9 0×00 0×1804 0×002e 0×09ce.8fb30218 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140687
0×11 9 0×00 0×1807 0×0003 0×09ce.8fb30372 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140809
0×12 9 0×00 0×1800 0×0018 0×09ce.8fb30292 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140747
0×13 9 0×00 0×1806 0×0009 0×09ce.8fb302b2 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140747
0×14 9 0×00 0×1806 0×0028 0×09ce.8fb301ac 0×0080199e 0×0000.000.00000000 0×00000001 0×00000000 1271140627
0×15 9 0×00 0×1808 0×0008 0×09ce.8fb302fe 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140808
0×16 9 0×00 0×17e7 0×0026 0×09ce.8fb3041a 0×008019a0 0×0000.000.00000000 0×00000001 0×00000000 1271140870
0×17 9 0×00 0×1804 0×001d 0×09ce.8fb301bf 0×0080199e 0×0000.000.00000000 0×00000001 0×00000000 1271140627
0×18 9 0×00 0×1807 0×0013 0×09ce.8fb302a2 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140747
0×19 9 0×00 0×1808 0×0014 0×09ce.8fb30189 0×0080199e 0×0000.000.00000000 0×00000001 0×00000000 1271140627
0×1a 9 0×00 0×1806 0×0007 0×09ce.8fb3044b 0×008019a0 0×0000.000.00000000 0×00000001 0×00000000 1271140873
0×1b 9 0×00 0×1621 0×001a 0×09ce.8fb30439 0×008019a0 0×0000.000.00000000 0×00000001 0×00000000 1271140873
0×1c 9 0×00 0×1801 0×002a 0×09ce.8fb3046e 0×008019a0 0×0000.000.00000000 0×00000001 0×00000000 1271140873
0×1d 9 0×00 0×1808 0×0025 0×09ce.8fb301d4 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140627
0×1e 9 0×00 0×1806 0×0023 0×09ce.8fb3049f 0×008019a0 0×0000.000.00000000 0×00000001 0×00000000 1271140933
0×1f 9 0×00 0×1802 0×0012 0×09ce.8fb3027a 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140747
0×20 9 0×00 0×1807 0×0016 0×09ce.8fb303eb 0×008019a0 0×0000.000.00000000 0×00000001 0×00000000 1271140809
0×21 9 0×00 0×17e4 0×0015 0×09ce.8fb302f7 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140807
0×22 9 0×00 0×17f8 0×000a 0×09ce.8fb3033d 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140808
0×23 9 0×00 0×1809 0×002d 0×09ce.8fb35402 0×00000000 0×0000.000.00000000 0×00000000 0×00000000 1271141052
0×24 9 0×00 0×1807 0×0019 0×09ce.8fb30150 0×0080199e 0×0000.000.00000000 0×00000001 0×00000000 1271140567
0×25 9 0×00 0×1800 0×0010 0×09ce.8fb30204 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140687
0×26 9 0×00 0×1809 0×001b 0×09ce.8fb3042f 0×008019a0 0×0000.000.00000000 0×00000001 0×00000000 1271140873
0×27 9 0×00 0×1808 0×0021 0×09ce.8fb302cf 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140747
0×28 9 0×00 0×1806 0×0017 0×09ce.8fb301b3 0×0080199e 0×0000.000.00000000 0×00000001 0×00000000 1271140627
0×29 9 0×00 0×1807 0×000b 0×09ce.8fb303c3 0×008019a0 0×0000.000.00000000 0×00000001 0×00000000 1271140809
0×2a 9 0×00 0×1808 0×001e 0×09ce.8fb3048d 0×008019a0 0×0000.000.00000000 0×00000001 0×00000000 1271140932
0×2b 9 0×00 0×1806 0×0011 0×09ce.8fb3036d 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140809
0×2c 9 0×00 0×1806 0×002b 0×09ce.8fb30365 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140809
0×2d 9 0×00 0×1808 0xffff 0×09ce.8fb3a491 0×00000000 0×0000.000.00000000 0×00000000 0×00000000 1271141244
0×2e 9 0×00 0×1806 0×0004 0×09ce.8fb3022e 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140687
0×2f 9 0×00 0×17fb 0×0005 0×09ce.8fb30396 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140809
Recovering transaction (9, 14)
Marking transaction (9, 14) dead
UNDO SEG (AFTER RECOVERY): usn = 9 Extent Control Header
—————————————————————–
Extent Header:: spare1: 0 spare2: 0 #extents: 4 #blocks: 1167
last map 0×00000000 #maps: 0 offset: 4080
Highwater:: 0×008019a1 ext#: 2 blk#: 24 ext size: 128
#blocks in seg. hdr’s freelists: 0
#blocks below: 0
mapblk 0×00000000 offset: 2
Unlocked
Map Header:: next 0×00000000 #extents: 4 obj#: 0 flag: 0×40000000
Extent Map
—————————————————————–
0×0080008a length: 7
0×00801db1 length: 8
0×00801989 length: 128
0×00814989 length: 1024
Retention Table
———————————————————–
Extent Number:0 Commit Time: 1271133965
Extent Number:1 Commit Time: 1271135332
Extent Number:2 Commit Time: 1268272679
Extent Number:3 Commit Time: 1271133965
TRN CTL:: seq: 0×0b10 chd: 0×0024 ctl: 0×002d inc: 0×00000000 nfb: 0×0001
mgc: 0×8201 xts: 0×0068 flg: 0×0001 opt: 2147483646 (0×7ffffffe)
uba: 0×008019a1.0b10.02 scn: 0×09ce.8fb30131
Version: 0×01
FREE BLOCK POOL::
uba: 0×008019a1.0b10.02 ext: 0×2 spc: 0×1f3a
uba: 0×00000000.0b10.11 ext: 0×2 spc: 0×19e0
uba: 0×00000000.0b10.0b ext: 0×2 spc: 0×1884
uba: 0×00000000.0b09.01 ext: 0×2 spc: 0×1f88
uba: 0×00000000.0b09.01 ext: 0×2 spc: 0×1f88
TRN TBL::
index state cflags wrap# uel scn dba parent-xid nub stmt_num cmt
————————————————————————————————
0×00 9 0×00 0×180b 0×0001 0×09ce.8fb30327 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140808
0×01 9 0×00 0×1807 0×0022 0×09ce.8fb30333 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140808
0×02 9 0×00 0×1807 0×002f 0×09ce.8fb3038c 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140809
0×03 9 0×00 0×1809 0×0002 0×09ce.8fb3037a 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140809
0×04 9 0×00 0×1808 0×000c 0×09ce.8fb30239 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140687
0×05 9 0×00 0×1803 0×000d 0×09ce.8fb303ad 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140809
0×06 9 0×00 0×180a 0×0000 0×09ce.8fb30322 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140808
0×07 9 0×00 0×1800 0×001c 0×09ce.8fb3045d 0×008019a0 0×0000.000.00000000 0×00000001 0×00000000 1271140873
0×08 9 0×00 0×180a 0×0006 0×09ce.8fb30318 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140808
0×09 9 0×00 0×1725 0×0027 0×09ce.8fb302c6 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140747
0×0a 9 0×00 0×1809 0×002c 0×09ce.8fb30355 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140809
0×0b 9 0×00 0×180a 0×0020 0×09ce.8fb303d4 0×008019a0 0×0000.000.00000000 0×00000001 0×00000000 1271140809
0×0c 9 0×00 0×17fa 0×000f 0×09ce.8fb30245 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140687
0×0d 9 0×00 0×1809 0×0029 0×09ce.8fb303b9 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140809
0×0e 10 0×90 0×1809 0×0002 0×09ce.8fb304a9 0×008019a0 0×0000.000.00000000 0×00000001 0×00000000 0
0×0f 9 0×00 0×1802 0×001f 0×09ce.8fb30269 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140744
0×10 9 0×00 0×1804 0×002e 0×09ce.8fb30218 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140687
0×11 9 0×00 0×1807 0×0003 0×09ce.8fb30372 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140809
0×12 9 0×00 0×1800 0×0018 0×09ce.8fb30292 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140747
0×13 9 0×00 0×1806 0×0009 0×09ce.8fb302b2 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140747
0×14 9 0×00 0×1806 0×0028 0×09ce.8fb301ac 0×0080199e 0×0000.000.00000000 0×00000001 0×00000000 1271140627
0×15 9 0×00 0×1808 0×0008 0×09ce.8fb302fe 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140808
0×16 9 0×00 0×17e7 0×0026 0×09ce.8fb3041a 0×008019a0 0×0000.000.00000000 0×00000001 0×00000000 1271140870
0×17 9 0×00 0×1804 0×001d 0×09ce.8fb301bf 0×0080199e 0×0000.000.00000000 0×00000001 0×00000000 1271140627
0×18 9 0×00 0×1807 0×0013 0×09ce.8fb302a2 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140747
0×19 9 0×00 0×1808 0×0014 0×09ce.8fb30189 0×0080199e 0×0000.000.00000000 0×00000001 0×00000000 1271140627
0×1a 9 0×00 0×1806 0×0007 0×09ce.8fb3044b 0×008019a0 0×0000.000.00000000 0×00000001 0×00000000 1271140873
0×1b 9 0×00 0×1621 0×001a 0×09ce.8fb30439 0×008019a0 0×0000.000.00000000 0×00000001 0×00000000 1271140873
0×1c 9 0×00 0×1801 0×002a 0×09ce.8fb3046e 0×008019a0 0×0000.000.00000000 0×00000001 0×00000000 1271140873
0×1d 9 0×00 0×1808 0×0025 0×09ce.8fb301d4 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140627
0×1e 9 0×00 0×1806 0×0023 0×09ce.8fb3049f 0×008019a0 0×0000.000.00000000 0×00000001 0×00000000 1271140933
0×1f 9 0×00 0×1802 0×0012 0×09ce.8fb3027a 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140747
0×20 9 0×00 0×1807 0×0016 0×09ce.8fb303eb 0×008019a0 0×0000.000.00000000 0×00000001 0×00000000 1271140809
0×21 9 0×00 0×17e4 0×0015 0×09ce.8fb302f7 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140807
0×22 9 0×00 0×17f8 0×000a 0×09ce.8fb3033d 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140808
0×23 9 0×00 0×1809 0×002d 0×09ce.8fb35402 0×00000000 0×0000.000.00000000 0×00000000 0×00000000 1271141052
0×24 9 0×00 0×1807 0×0019 0×09ce.8fb30150 0×0080199e 0×0000.000.00000000 0×00000001 0×00000000 1271140567
0×25 9 0×00 0×1800 0×0010 0×09ce.8fb30204 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140687
0×26 9 0×00 0×1809 0×001b 0×09ce.8fb3042f 0×008019a0 0×0000.000.00000000 0×00000001 0×00000000 1271140873
0×27 9 0×00 0×1808 0×0021 0×09ce.8fb302cf 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140747
0×28 9 0×00 0×1806 0×0017 0×09ce.8fb301b3 0×0080199e 0×0000.000.00000000 0×00000001 0×00000000 1271140627
0×29 9 0×00 0×1807 0×000b 0×09ce.8fb303c3 0×008019a0 0×0000.000.00000000 0×00000001 0×00000000 1271140809
0×2a 9 0×00 0×1808 0×001e 0×09ce.8fb3048d 0×008019a0 0×0000.000.00000000 0×00000001 0×00000000 1271140932
0×2b 9 0×00 0×1806 0×0011 0×09ce.8fb3036d 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140809
0×2c 9 0×00 0×1806 0×002b 0×09ce.8fb30365 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140809
0×2d 9 0×00 0×1808 0xffff 0×09ce.8fb3a491 0×00000000 0×0000.000.00000000 0×00000000 0×00000000 1271141244
0×2e 9 0×00 0×1806 0×0004 0×09ce.8fb3022e 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140687
0×2f 9 0×00 0×17fb 0×0005 0×09ce.8fb30396 0×0080199f 0×0000.000.00000000 0×00000001 0×00000000 1271140809