alert.log部分内容
=================
Thu Aug 28 17:14:54 2008
SMON: enabling tx recovery
Thu Aug 28 17:14:54 2008
Database Characterset is US7ASCII
Thu Aug 28 17:14:55 2008
Errors in file /oracle9i/admin/tbank/bdump/tbank_smon_22941.trc:
ORA-00600: internal error code, arguments: [4194], [34], [50], [], [], [], [], []
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Thu Aug 28 17:14:57 2008
Doing block recovery for fno: 9 blk: 15839
Recovery of Online Redo Log: Thread 1 Group 2 Seq 42368 Reading mem 0
Mem# 0 errs 0: /dev/vg01/rora9i_redo21
Mem# 1 errs 0: /dev/vg01/rora9i_redo22
Doing block recovery for fno: 2 blk: 45
Recovery of Online Redo Log: Thread 1 Group 2 Seq 42368 Reading mem 0
Mem# 0 errs 0: /dev/vg01/rora9i_redo21
Mem# 1 errs 0: /dev/vg01/rora9i_redo22
Thu Aug 28 17:14:58 2008
Errors in file /oracle9i/admin/tbank/bdump/tbank_smon_22941.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [34], [50], [], [], [], [], []
Thu Aug 28 17:20:07 2008
Errors in file /oracle9i/admin/tbank/bdump/tbank_smon_22941.trc:
ORA-00600: internal error code, arguments: [4194], [34], [50], [], [], [], [], []
Doing block recovery for fno: 9 blk: 15839
Recovery of Online Redo Log: Thread 1 Group 2 Seq 42368 Reading mem 0
Mem# 0 errs 0: /dev/vg01/rora9i_redo21
Mem# 1 errs 0: /dev/vg01/rora9i_redo22
Doing block recovery for fno: 2 blk: 45
Recovery of Online Redo Log: Thread 1 Group 2 Seq 42368 Reading mem 0
Mem# 0 errs 0: /dev/vg01/rora9i_redo21
Mem# 1 errs 0: /dev/vg01/rora9i_redo22
Thu Aug 28 17:20:10 2008
Errors in file /oracle9i/admin/tbank/bdump/tbank_smon_22941.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [34], [50], [], [], [], [], []
Thu Aug 28 17:30:25 2008
Errors in file /oracle9i/admin/tbank/bdump/tbank_smon_22941.trc:
ORA-00600: internal error code, arguments: [4194], [34], [50], [], [], [], [], []
/oracle9i/admin/tbank/bdump/tbank_smon_22941.trc
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.5.0 - Production
ORACLE_HOME = /oracle9i/product/9.2.0
System name: HP-UX
Node name: newcqcb1
Release: B.11.11
Version: U
Machine: 9000/800
Instance name: tbank
Redo thread mounted by this instance: 1
Oracle process number: 7
Unix process pid: 22941, image: oracle@newcqcb1 (SMON)
*** SESSION ID:(6.1) 2008-08-28 17:14:55.633
*** 2008-08-28 17:14:55.633
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [4194], [34], [50], [], [], [], [], []
Current SQL statement for this session:
UPDATE SMON_SCN_TIME SET SCN_WRP=:1, SCN_BAS=:2, TIME_MP=:3, TIME_DP=:4 WHERE TIME_MP = :5 AND THREAD = :6 AND ROWNUM <= 1
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp()+184 ? ksedst() 000000000 ? 30000000000 ?
800003FFC0007530 ?
40000000012F15DF ?
ksfdmp()+32 ? ksedmp() 80000001000D8F00 ?
C0000001711AB658 ?
000000000 ?
400000000136071F ?
kgeriv()+152 ? ksfdmp() 000000000 ?
400000000136071F ?
C00000019BA57800 ?
40000000013E5693 ?
kseipre()+92 ? kgeriv() 40000000013E5693 ?
000000000 ? 800000000000000 ?
000000000 ?
ksesic2()+80 ? kseipre() 000000218 ? 000000000 ?
000000000 ?
40000000012DDC53 ?
kturdb()+724 ? ksesic2() 80000001000CDE18 ?
0000CDE18 ?
4000000000D130D8 ?
17FFFFFFF ?
kcoapl()+608 ? kturdb() 000000001 ?
C000000040FEA300 ?
80000001000D9220 ?
800003FFC0006B18 ?
kcbapl()+124 ? kcoapl() 80000001000CDE18 ?
3E4060E400000D58 ?
C0000000002BCD8B ?
800003FFC00069F8 ?
kcrfwr()+1700 ? kcbapl() 80000001000C1E18 ?
000000001 ? 000000000 ?
80000001000C0018 ?
kcbchg1()+2916 ? kcrfwr() 800003FB40005DD4 ?
80000001000C1618 ?
10000FFFF ? 000000000 ?
ktuchg()+3476 ? kcbchg1() 4000000000478678 ?
513000000000000 ?
C00000017039E060 ?
800003FFC0006350 ?
ktbchg2()+168 ? ktuchg() 000000000 ?
80000001000D9220 ?
3E4060E100004368 ?
00000FFFF ?
kddchg()+296 ? ktbchg2() 80000001000CDE18 ?
000000000 ?
800003FFC0004890 ?
800003FB80051AB8 ?
kduovw()+1932 ? kddchg() C000000040AA805C ?
800003FB800534D0 ?
40075526320501 ?
40075800400755 ?
kduurp()+736 ? kduovw() 40000000013179F7 ?
4000000001482A2B ?
800000010000B938 ?
5A00000000 ?
kdusru()+668 ? kduurp() 4000000001482A2B ?
400000000136F49F ?
C00000017267DA60 ?
800003FFBFFF9D98 ?
kauupd()+408 ? kdusru() 80000001000CDE18 ?
000000000 ? 800000000000000 ?
B38F0000000001 ?
updrow()+2480 ? kauupd() 000000000 ? 000000001 ?
80000001000CDE18 ?
800000010000BA78 ?
qerupFetch()+340 ? updrow() C000000173DCB058 ?
4180000000000000 ?
000000000 ? 000000000 ?
updaul()+520 ? qerupFetch() C000000173DCAF98 ?
40000000004CA828 ?
000000000 ? 000000000 ?
updThreePhaseExe()+ ? updaul() C000000171D4ABE8 ?
244 000003000 ?
800003FB8007DBE0 ?
000008001 ?
updexe()+348 ? updThreePhaseExe() 8000000100133F50 ?
40000000013C5850 ?
C00000007FFFFFFF ?
4020000000000000 ?
opiexe()+8120 ? updexe() 000000000 ?
800003FB8007FD38 ?
80000001000D0030 ?
000000000 ?
opiall0()+2424 ? opiexe() 000000000 ? 6000D7F70 ?
000073000 ? 100000000 ?
opikpr()+404 ? opiall0() 800003FFBFFF6530 ?
200000B938 ?
C000000000000000 ?
7F80000000000000 ?
opiodr()+2396 ? opikpr() 000000000 ? 40000000800 ?
40000000013B588F ?
80000001000D92A8 ?
rpidrus()+160 ? opiodr() 000000000 ? 00001ACED ?
00000000F ?
800003FFBFFF3DD0 ?
skgmstack()+156 ? rpidrus() 40000000013B7ABF ?
40000000011DD23F ?
10000000200 ?
C0000001703A2D08 ?
rpidru()+152 ? skgmstack() 40000000012338FB ?
00001ACEF ?
C0000001703A2D08 ?
10000000200 ?
rpiswu2()+420 ? rpidru() 4020000000000000 ?
000000002 ? 00000000F ?
800003FFBFFF3DD0 ?
kprball()+1268 ? rpiswu2() 800000010000BA78 ?
C000000100000000 ?
000000044 ? 00001AD38 ?
ktf_scn_time()+5048 ? kprball() 1000000010 ?
800000010000BA78 ?
10000000200 ? 000000000 ?
ktmmon()+3140 ? ktf_scn_time() 800003FFBFFF4870 ?
80000001000CDE18 ?
40000000013F0E63 ?
800003FB8006F594 ?
ksbrdp()+1048 ? ktmmon() FFFFFFFFFFFFFFEC ?
C00000000005FA07 ?
300012E6BAF ? 000000000 ?
opirip()+772 ? ksbrdp() 000000000 ?
C00000000020FA48 ?
800003FFBFFF19F0 ?
000000000 ?
opidrv()+952 ? opirip() 800003FFBFFF0EC0 ?
C00000000030502B ?
800003FFBFFF0EC0 ?
80000001000C1618 ?
sou2o()+40 ? opidrv() 800003FFBFFF60A8 ?
C00000000000A61B ?
000000000 ?
C00000000030520B ?
main()+364 ? sou2o() 000000000 ?
C00000000030520B ?
000000001 ? 000000008 ?
$START$()+160 ? main() 000000001 ?
800003FFBFFF06DB ?
800003FFBFFF062F ?
800003FFBFFF0352 ?
--------------------- Binary Stack Dump ---------------------
......
*-----------------------------
* Rec #0x1f slt: 0x12 objn: 489293(0x0007774d) objd: 489293 tblspc: 3(0x00000003)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
uba: 0x02403ddf.5fe3.1e ctl max scn: 0x0000.3e3fc15b prv tx scn: 0x0000.3e3fc179
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.012.0005fcfd uba: 0x00800027.7fbc.0b
flg: C--- lkc: 0 scn: 0x0000.3e403173
KDO Op code: URP row dependencies Disabled
xtype: XA bdba: 0x0287c3d3 hdba: 0x0287c3c7
itli: 1 ispac: 0 maxfr: 9774
tabn: 0 slot: 2(0x2) flag: 0x2c lock: 0 ckix: 0
ncol: 2 nnew: 1 size: 0
col 1: [ 3] c2 02 14
*-----------------------------
* Rec #0x20 slt: 0x12 objn: 489293(0x0007774d) objd: 489293 tblspc: 3(0x00000003)
* Layer: 11 (Row) opc: 1 rci 0x1f
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
KDO undo record:
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x02403ddf.5fe3.1f
KDO Op code: URP row dependencies Disabled
xtype: XA bdba: 0x0287c3d3 hdba: 0x0287c3c7
itli: 1 ispac: 0 maxfr: 9774
tabn: 0 slot: 1(0x1) flag: 0x2c lock: 0 ckix: 0
ncol: 2 nnew: 1 size: -1
col 1: [ 1] 80
*-----------------------------
* Rec #0x21 slt: 0x19 objn: 489293(0x0007774d) objd: 489293 tblspc: 3(0x00000003)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
uba: 0x02403ddf.5fe3.1f ctl max scn: 0x0000.3e3fc179 prv tx scn: 0x0000.3e3fc17d
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x000a.037.000604ba uba: 0x0080004f.8577.10
flg: C--- lkc: 0 scn: 0x0000.3e403194
KDO Op code: URP row dependencies Disabled
xtype: XA bdba: 0x0287c3d3 hdba: 0x0287c3c7
itli: 2 ispac: 0 maxfr: 9774
tabn: 0 slot: 1(0x1) flag: 0x2c lock: 0 ckix: 0
ncol: 2 nnew: 1 size: 1
col 1: [ 2] c1 02
*-----------------------------
* Rec #0x22 slt: 0x19 objn: 488637(0x000774bd) objd: 488637 tblspc: 3(0x00000003)
* Layer: 11 (Row) opc: 1 rci 0x21
Undo type: Regular undo Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0005.012.0005fcfd uba: 0x00800027.7fbc.0c
flg: C--- lkc: 0 scn: 0x0000.3e403173
KDO Op code: URP row dependencies Disabled
xtype: XA bdba: 0x02802ad3 hdba: 0x02802ac7
itli: 1 ispac: 0 maxfr: 9774
tabn: 0 slot: 9(0x9) flag: 0x2c lock: 0 ckix: 0
ncol: 6 nnew: 1 size: 1
col 4: [ 2] c1 02
Doing block recovery for fno: 2 blk: 45
Block header before block recovery:
buffer tsn: 1 rdba: 0x0080002d (2/45)
scn: 0x0000.3e409c6c seq: 0x01 flg: 0x04 tail: 0x9c6c2601
frmt: 0x02 chkval: 0x4b90 type: 0x26=KTU SMU HEADER BLOCK
Block image after block recovery:
buffer tsn: 1 rdba: 0x0080002d (2/45)
scn: 0x0000.3e409c6c seq: 0x01 flg: 0x04 tail: 0x9c6c2601
frmt: 0x02 chkval: 0x4b90 type: 0x26=KTU SMU HEADER BLOCK
Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 spare2: 0 #extents: 3 #blocks: 71
last map 0x00000000 #maps: 0 offset: 8176
Highwater:: 0x02403de1 ext#: 2 blk#: 28 ext size: 64
#blocks in seg. hdr's freelists: 0
#blocks below: 0
mapblk 0x00000000 offset: 2
Unlocked
Map Header:: next 0x00000000 #extents: 3 obj#: 0 flag: 0x40000000
Extent Map
-----------------------------------------------------------------
0x0080002e length: 3
0x02400091 length: 4
0x02403dc5 length: 64
Retention Table
-----------------------------------------------------------
Extent Number:0 Commit Time: 1219819097
Extent Number:1 Commit Time: 1219819100
Extent Number:2 Commit Time: 1219819100
TRN CTL:: seq: 0x5fe3 chd: 0x003e ctl: 0x0040 inc: 0x00000000 nfb: 0x0003
mgc: 0x8201 xts: 0x0068 flg: 0x0001 opt: 2147483646 (0x7ffffffe)
uba: 0x02403de1.5fe3.01 scn: 0x0000.3e3fc638
Version: 0x01
FREE BLOCK POOL::
uba: 0x02403ddf.5fe3.31 ext: 0x2 spc: 0x26b0
uba: 0x02403de0.5fe3.01 ext: 0x2 spc: 0x3f98
uba: 0x02403de1.5fe3.01 ext: 0x2 spc: 0x3f98
uba: 0x00000000.5e11.01 ext: 0x2 spc: 0x3f98
uba: 0x00000000.5c19.01 ext: 0x2 spc: 0x3f98
TRN TBL::
index state cflags wrap# uel scn dba parent-xid nub stmt_num
------------------------------------------------------------------------------------------------
0x00 9 0x00 0x58731 0x0059 0x0000.3e3fc7d9 0x02403dda 0x0000.000.00000000 0x00000001 0x00000000
0x01 9 0x00 0x58816 0x0042 0x0000.3e401804 0x02403dde 0x0000.000.00000000 0x00000001 0x00000000
0x02 9 0x00 0x58792 0x0049 0x0000.3e40371d 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x03 9 0x00 0x5878c 0x0029 0x0000.3e40304b 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x04 9 0x00 0x58824 0x002d 0x0000.3e40389e 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x05 9 0x00 0x58762 0x0036 0x0000.3e4028ad 0x02403dde 0x0000.000.00000000 0x00000001 0x00000000
0x06 9 0x00 0x58805 0x0033 0x0000.3e3fc6e0 0x02403dd7 0x0000.000.00000000 0x00000001 0x00000000
0x07 9 0x00 0x58809 0x003f 0x0000.3e402b39 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x08 9 0x00 0x587e5 0x001a 0x0000.3e3ff35f 0x00000000 0x0000.000.00000000 0x00000000 0x00000000
0x09 9 0x00 0x587f3 0x0000 0x0000.3e3fc7d0 0x02403dda 0x0000.000.00000000 0x00000001 0x00000000
0x0a 9 0x00 0x587ce 0x003a 0x0000.3e3fd0b3 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x0b 9 0x00 0x58811 0x0012 0x0000.3e40315e 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x0c 9 0x00 0x587cb 0x000e 0x0000.3e4036c9 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x0d 9 0x00 0x587a8 0x0020 0x0000.3e401475 0x02403ddd 0x0000.000.00000000 0x00000001 0x00000000
0x0e 9 0x00 0x5882c 0x0002 0x0000.3e403719 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x0f 9 0x00 0x587df 0x0008 0x0000.3e3ff2f2 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x10 9 0x23 0x58822 0x0045 0x0000.3e401318 0x02403ddc 0x0000.000.00000000 0x00000001 0x02403ddc
0x11 9 0x00 0x5879b 0x005e 0x0000.3e3fea49 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x12 9 0x00 0x587e5 0x0019 0x0000.3e403196 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x13 9 0x00 0x58798 0x0032 0x0000.3e402cd4 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x14 9 0x00 0x587b6 0x0007 0x0000.3e402afa 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x15 9 0x00 0x58798 0x002c 0x0000.3e403123 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x16 9 0x00 0x58816 0x0026 0x0000.3e3fc801 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x17 9 0x00 0x5883c 0x0052 0x0000.3e3fd69b 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x18 9 0x00 0x5880f 0x0015 0x0000.3e40311f 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x19 9 0x00 0x5882e 0x0028 0x0000.3e40319a 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x1a 9 0x00 0x587c0 0x004d 0x0000.3e3ff8f1 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x1b 9 0x00 0x5873d 0x0053 0x0000.3e400653 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x1c 9 0x00 0x58821 0x0061 0x0000.3e40199f 0x02403dde 0x0000.000.00000000 0x00000001 0x00000000
0x1d 9 0x00 0x5881a 0x0050 0x0000.3e4017ce 0x02403dde 0x0000.000.00000000 0x00000001 0x00000000
0x1e 9 0x00 0x587ae 0x004c 0x0000.3e403949 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x1f 9 0x00 0x587f8 0x002b 0x0000.3e4030c4 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x20 9 0x23 0x58845 0x0024 0x0000.3e40147f 0x02403ddd 0x0000.000.00000000 0x00000001 0x02403ddd
0x21 9 0x00 0x587c5 0x0038 0x0000.3e40182d 0x02403dde 0x0000.000.00000000 0x00000001 0x00000000
0x22 9 0x00 0x5880b 0x0051 0x0000.3e3fca67 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x23 9 0x00 0x5880b 0x0046 0x0000.3e400dcf 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x24 9 0x00 0x587a4 0x001d 0x0000.3e40175b 0x02403dde 0x0000.000.00000000 0x00000001 0x00000000
0x25 9 0x00 0x5882c 0x0048 0x0000.3e403153 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x26 9 0x00 0x587b4 0x0057 0x0000.3e3fc821 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x27 9 0x00 0x58830 0x003c 0x0000.3e3fc7e1 0x02403dda 0x0000.000.00000000 0x00000001 0x00000000
0x28 9 0x00 0x587e5 0x0056 0x0000.3e4036c1 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x29 9 0x00 0x587a0 0x0047 0x0000.3e40304f 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x2a 9 0x00 0x586da 0x0014 0x0000.3e402af6 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x2b 9 0x00 0x5882b 0x005a 0x0000.3e4030c8 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x2c 9 0x00 0x587cc 0x0025 0x0000.3e40313f 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x2d 9 0x00 0x58838 0x001e 0x0000.3e4038a4 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x2e 9 0x23 0x58821 0x0041 0x0000.3e401113 0x02403ddb 0x0000.000.00000000 0x00000001 0x02403ddb
0x2f 9 0x00 0x58805 0x002e 0x0000.3e400f8c 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x30 9 0x00 0x587d2 0x0031 0x0000.3e402386 0x02403dde 0x0000.000.00000000 0x00000001 0x00000000
0x31 9 0x00 0x58799 0x0005 0x0000.3e402720 0x02403dde 0x0000.000.00000000 0x00000001 0x00000000
0x32 9 0x00 0x587fc 0x0003 0x0000.3e402ea0 0x00000000 0x0000.000.00000000 0x00000000 0x00000000
0x33 9 0x23 0x587f2 0x0054 0x0000.3e3fc711 0x02403dd7 0x0000.000.00000000 0x00000001 0x02403dd7
0x34 9 0x00 0x5883d 0x004f 0x0000.3e400bd5 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x35 9 0x00 0x587cf 0x0040 0x0000.3e4060f8 0x00000000 0x0000.000.00000000 0x00000000 0x00000000
0x36 9 0x00 0x587e1 0x0062 0x0000.3e4028b5 0x02403dde 0x0000.000.00000000 0x00000001 0x00000000
0x37 9 0x00 0x58843 0x0030 0x0000.3e40210a 0x02403dde 0x0000.000.00000000 0x00000001 0x00000000
0x38 9 0x00 0x58839 0x001c 0x0000.3e4018f4 0x02403dde 0x0000.000.00000000 0x00000001 0x00000000
0x39 9 0x00 0x587a0 0x001b 0x0000.3e40032c 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x3a 9 0x00 0x587b8 0x0017 0x0000.3e3fd1e1 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x3b 9 0x00 0x58838 0x0016 0x0000.3e3fc7fd 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x3c 9 0x23 0x58766 0x003b 0x0000.3e3fc7f7 0x02403dda 0x0000.000.00000000 0x00000001 0x02403dda
0x3d 9 0x00 0x587ea 0x0039 0x0000.3e40006b 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x3e 9 0x00 0x586e5 0x0055 0x0000.3e3fc6c0 0x02403dd7 0x0000.000.00000000 0x00000001 0x00000000
0x3f 9 0x00 0x5876a 0x0013 0x0000.3e402cd0 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x40 9 0x00 0x587ef 0xffff 0x0000.3e409b3b 0x00000000 0x0000.000.00000000 0x00000000 0x00000000
0x41 9 0x00 0x5879f 0x004b 0x0000.3e4012fc 0x02403ddc 0x0000.000.00000000 0x00000001 0x00000000
0x42 9 0x00 0x5876d 0x0021 0x0000.3e401829 0x02403dde 0x0000.000.00000000 0x00000001 0x00000000
0x43 9 0x00 0x586d3 0x0044 0x0000.3e3fc7c8 0x02403dda 0x0000.000.00000000 0x00000001 0x00000000
0x44 9 0x00 0x58744 0x0009 0x0000.3e3fc7cc 0x02403dda 0x0000.000.00000000 0x00000001 0x00000000
0x45 9 0x00 0x58840 0x000d 0x0000.3e4013bf 0x02403ddd 0x0000.000.00000000 0x00000001 0x00000000
0x46 9 0x00 0x5878d 0x002f 0x0000.3e400dd3 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x47 9 0x00 0x5880e 0x001f 0x0000.3e403057 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x48 9 0x00 0x58838 0x000b 0x0000.3e403157 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x49 9 0x00 0x5884a 0x0004 0x0000.3e40389a 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x4a 9 0x00 0x5883a 0x0037 0x0000.3e401d1b 0x02403dde 0x0000.000.00000000 0x00000001 0x00000000
0x4b 9 0x00 0x58845 0x0010 0x0000.3e401300 0x02403ddc 0x0000.000.00000000 0x00000001 0x00000000
0x4c 9 0x00 0x5876b 0x0035 0x0000.3e4039e5 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x4d 9 0x00 0x587a4 0x003d 0x0000.3e3ffce0 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x4e 9 0x00 0x58830 0x005f 0x0000.3e3fe072 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x4f 9 0x00 0x58847 0x0023 0x0000.3e400dcb 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x50 9 0x00 0x5884e 0x0001 0x0000.3e4017fc 0x02403dde 0x0000.000.00000000 0x00000001 0x00000000
0x51 9 0x00 0x5880b 0x000a 0x0000.3e3fcdf2 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x52 9 0x00 0x587a4 0x004e 0x0000.3e3fda8a 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x53 9 0x00 0x58773 0x0034 0x0000.3e400914 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x54 9 0x23 0x58813 0x0060 0x0000.3e3fc736 0x02403dd8 0x0000.000.00000000 0x00000001 0x02403dd8
0x55 9 0x00 0x587b1 0x0006 0x0000.3e3fc6dc 0x02403dd7 0x0000.000.00000000 0x00000001 0x00000000
0x56 9 0x00 0x58837 0x000c 0x0000.3e4036c5 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x57 9 0x00 0x587f3 0x005b 0x0000.3e3fc825 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x58 9 0x00 0x587fe 0x005c 0x0000.3e4019cc 0x02403dde 0x0000.000.00000000 0x00000001 0x00000000
0x59 9 0x00 0x5884a 0x0027 0x0000.3e3fc7dd 0x02403dda 0x0000.000.00000000 0x00000001 0x00000000
0x5a 9 0x00 0x58843 0x005d 0x0000.3e4030e6 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x5b 9 0x00 0x5882d 0x0022 0x0000.3e3fc829 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x5c 9 0x00 0x5883b 0x004a 0x0000.3e401a8a 0x02403dde 0x0000.000.00000000 0x00000001 0x00000000
0x5d 9 0x00 0x5876c 0x0018 0x0000.3e403118 0x02403ddf 0x0000.000.00000000 0x00000001 0x00000000
0x5e 9 0x00 0x587c8 0x000f 0x0000.3e3fed0a 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x5f 9 0x00 0x5881f 0x0011 0x0000.3e3fe461 0x02403ddb 0x0000.000.00000000 0x00000001 0x00000000
0x60 9 0x23 0x587e3 0x0043 0x0000.3e3fc7be 0x02403dd9 0x0000.000.00000000 0x00000001 0x02403dd9
0x61 9 0x00 0x58839 0x0058 0x0000.3e4019c8 0x02403dde 0x0000.000.00000000 0x00000001 0x00000000
0x62 9 0x23 0x586e1 0x002a 0x0000.3e402aef 0x02403dde 0x0000.000.00000000 0x00000001 0x02403dde
*** 2008-08-29 08:25:06.685
SMON: following errors trapped and ignored:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [34], [50], [], [], [], [], []
参考文档:
Subject: ORA-600 [4194] "Undo Record Number Mismatch While Adding Undo Record"
Doc ID: Note:39283.1 Type: REFERENCE
Last Revision Date: 14-AUG-2007 Status: PUBLISHED
PURPOSE:
This article discusses the internal error "ORA-600 [4194]", what
it means and possible actions. The information here is only applicable
to the versions listed and is provided only for guidance.
ERROR:
ORA-600 [4194] [a] [b]
VERSIONS:
versions 6.0 to 10.1
DESCRIPTION:
A mismatch has been detected between Redo records and rollback (Undo)
records.
We are validating the Undo record number relating to the change being
applied against the maximum undo record number recorded in the undo block.
This error is reported when the validation fails.
ARGUMENTS:
Arg [a] Maximum Undo record number in Undo block
Arg [b] Undo record number from Redo block
FUNCTIONALITY:
Kernel Transaction Undo called from Cache layer
IMPACT:
PROCESS FAILURE
POSSIBLE ROLLBACK SEGMENT CORRUPTION
SUGGESTIONS:
This error may indicate a rollback segment corruption.
This may require a recovery from a database backup depending on
the situation.
问题原因:
磁盘阵列问题导致UNDO SEGMENT损坏,根据trc文件可以看出该UNDO SEGMENT 0x22的TRN TABLE中事务全部是提交状态(state=9),可以尝试删除该UNDO SEGMENT来修复数据库:
sqlplus '/ as sysdba'
create pfile='/tmp/pfile_temp.ora' from spfile;
shutdown immediate
/tmp/pfile_temp.ora增加以下两行:
undo_management= MANUAL
_offline_rollback_segments=(_SYSSMU34$)
sqlplus '/ as sysdba'
startup pfile=/tmp/pfile_temp.ora
启动成功,删除UNDO SEGMENT:
drop rollback segment "_SYSSMU34";
shutdown immediate
startup
数据库修复成功。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/14993/viewspace-1010298/ ,如需转载,请注明出处,否则将追究法律责任。