oracle libcpt ora,ORA-01555 – 提供7*24专业数据库(Oracle,SQL Server,MySQL等)恢复和Oracle技术服务@Tel:+86 13429648788...

最新推荐文章于 2021-04-16 02:33:27 发布
最新推荐文章于 2021-04-16 02:33:27 发布
阅读量286 收藏
点赞数
文章标签： oracle libcpt ora

这个库的恢复有一些历史故事(【力荐】Exadata火线救援：10TB级数据修复经典案例详解！)：xx运营商x2的1/4配置的oracle exadata机器，跑了近6年，最近有一个cell节点主机异常,在rebalance过程中,只有两个节点的cell其中一个节点坏了一个硬盘导致.导致asm diskgroup无法正常mount,最后该运营商运维三方通过amdu把该一体机中的数据文件全部抽出来,然后在恢复过程中出现大量错误无法解决,请求我们支持

数据库open过程报ORA-01555错误

Thu Jul 14 00:01:04 2016

alter database open

Thu Jul 14 00:01:04 2016

Thread 1 advanced to log sequence 2 (thread open)

Thread 1 opened at log sequence 2

Current log# 2 seq# 2 mem# 0: /data/amdu/redo/DATA_EC_260.f

Successful open of redo thread 1

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Thu Jul 14 00:01:05 2016

SMON: enabling cache recovery

ORA-01555 caused by SQL statement below (SQL ID: 4krwuz0ctqxdt, SCN: 0x0b26.9f080238):

select ctime, mtime, stime from obj$ where obj# = :1

Errors in file /oracle/app/oracle/diag/rdbms/xifenfei/xifenfei/trace/xifenfei_ora_59546.trc:

ORA-00704: bootstrap process failure

ORA-00704: bootstrap process failure

ORA-00604: error occurred at recursive SQL level 1

ORA-01555: snapshot too old: rollback segment number 83 with name "_SYSSMU83_1078760807$" too small

Errors in file /oracle/app/oracle/diag/rdbms/xifenfei/xifenfei/trace/xifenfei_ora_59546.trc:

ORA-00704: bootstrap process failure

ORA-00704: bootstrap process failure

ORA-00604: error occurred at recursive SQL level 1

ORA-01555: snapshot too old: rollback segment number 83 with name "_SYSSMU83_1078760807$" too small

Error 704 happened during db open, shutting down database

USER (ospid: 59546): terminating the instance due to error 704

Instance terminated by USER, pid = 59546

ORA-1092 signalled during: alter database open...

opiodr aborting process unknown ospid (59546) as a result of ORA-1092

这个错误比较常见，可以通过推scn就可以解决,由于已经安装了scn patch,通过oradebug推scn解决该问题.

ORA-600 4194

这个ora 600 4194相对比较特殊,在SMON: enabling cache recovery之后立马报出来,然后实例直接open失败.

Thu Jul 14 00:06:15 2016

alter database open

Thu Jul 14 00:06:15 2016

Thread 1 advanced to log sequence 3 (thread open)

Thread 1 opened at log sequence 3

Current log# 3 seq# 3 mem# 0: /data/amdu/redo/DATA_EC_263.f

Successful open of redo thread 1

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Thu Jul 14 00:06:15 2016

SMON: enabling cache recovery

Errors in file /oracle/app/oracle/diag/rdbms/xifenfei/xifenfei/trace/xifenfei_ora_60038.trc (incident=1080450):

ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Block recovery from logseq 3, block 3 to scn 12269096776739

Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0

Mem# 0: /data/amdu/redo/DATA_EC_263.f

Block recovery stopped at EOT rba 3.5.16

Block recovery completed at rba 3.5.16, scn 2856.2670179361

Block recovery from logseq 3, block 3 to scn 12269096776736

Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0

Mem# 0: /data/amdu/redo/DATA_EC_263.f

Block recovery completed at rba 3.5.16, scn 2856.2670179361

Errors in file /oracle/app/oracle/diag/rdbms/xifenfei/xifenfei/trace/xifenfei_ora_60038.trc:

ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []

Errors in file /oracle/app/oracle/diag/rdbms/xifenfei/xifenfei/trace/xifenfei_ora_60038.trc:

ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []

Error 600 happened during db open, shutting down database

USER (ospid: 60038): terminating the instance due to error 600

Instance terminated by USER, pid = 60038

ORA-1092 signalled during: alter database open...

opiodr aborting process unknown ospid (60038) as a result of ORA-1092

trace文件分析

打开数据库报ORA-600[4194]错误,对启动过程进行10046跟踪并且分析trace文件发现

PARSING IN CURSOR #140375370511672 len=148 dep=1 uid=0 oct=6 lid=0 tim=3501342849457766 hv=3540833987

ad='a47df47a8' sqlid='5ansr7r9htpq3'

update undo$ set name=:2,file#=:3,block#=:4,status$=:5,user#=:6,undosqn=:7,xactsqn=:8,scnbas=:9,

scnwrp=:10,inst#=:11,ts#=:12,spare1=:13 where us#=:1

END OF STMT

PARSE #140375370511672:c=27996,e=28041,p=66,cr=224,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=3501342849457765

BINDS #140375370511672:

Bind#0

oacdty=01 mxl=32(20) mxlc=00 mal=00 scl=00 pre=00

oacflg=18 fl2=0001 frm=01 csi=178 siz=32 off=0

kxsbbbfp=a47e093ca bln=32 avl=20 flg=09

value="_SYSSMU1_2856534670$"

Bind#1

oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0

kxsbbbfp=7fabae3b92b0 bln=24 avl=03 flg=05

value=1024

Bind#2

oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0

kxsbbbfp=7fabae3b9280 bln=24 avl=03 flg=05

value=128

Bind#3

oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0

kxsbbbfp=7fabae3b9248 bln=24 avl=02 flg=05

value=5

Bind#4

oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0

kxsbbbfp=7fabae3b9218 bln=24 avl=02 flg=05

value=1

Bind#5

oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0

kxsbbbfp=7fabae3b91e8 bln=24 avl=03 flg=05

value=3398

Bind#6

oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0

kxsbbbfp=7fabae3b91b8 bln=24 avl=05 flg=05

value=1485261

Bind#7

oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0

kxsbbbfp=7fabae3b9180 bln=24 avl=06 flg=05

value=1946693999

Bind#8

oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0

kxsbbbfp=7fabae3b8ec8 bln=24 avl=03 flg=05

value=2847

Bind#9

oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0

kxsbbbfp=7fabae3b8e98 bln=24 avl=02 flg=05

value=1

Bind#10

oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0

kxsbbbfp=7fabae3b8e68 bln=24 avl=02 flg=05

value=2

Bind#11

oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0

kxsbbbfp=7fabae3b8e38 bln=24 avl=02 flg=05

value=2

Bind#12

oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

oacflg=08 fl2=0001 frm=00 csi=00 siz=24 off=0

kxsbbbfp=7fabae3b92e0 bln=22 avl=02 flg=05

value=1

WAIT #140375370511672: nam='db file sequential read' ela= 21 file#=1 block#=179020 blocks=1 obj#=0 tim=3501342849459353

*** 2016-07-14 03:14:09.548

ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []

很明显数据库是在update undo$的时候,读取到file 1 block 179020的时候报错,继续分析trace文件

Error 600 in redo application callback

Dump of change vector:

TYP:0 CLS:16 AFN:1 DBA:0x0042bb4c OBJ:4294967295 SCN:0x0b26.a88e815e SEQ:1 OP:5.1 ENC:0 RBL:0

ktudb redo: siz: 272 spc: 4906 flg: 0x0012 seq: 0x0f4c rec: 0x0d

xid: 0x0000.01b.00000b63

ktubl redo: slt: 27 rci: 0 opc: 11.1 [objn: 15 objd: 15 tsn: 0]

Undo type: Regular undo Begin trans Last buffer split: No

Temp Object: No

Tablespace Undo: No

0x00000000 prev ctl uba: 0x0042bb4c.0f4c.0c

prev ctl max cmt scn: 0x0b23.ccb9eb89 prev tx cmt scn: 0x0b23.ccb9ebac

txn start scn: 0xffff.ffffffff logon user: 0 prev brb: 4373321 prev bcl: 0 BuExt idx: 0 flg2: 0

KDO undo record:

KTB Redo

op: 0x04 ver: 0x01

compat bit: 4 (post-11) padding: 1

op: L itl: xid: 0x0000.01c.00000b65 uba: 0x0042bb4a.0f4c.1d

flg: C--- lkc: 0 scn: 0x0b25.7391ee5c

KDO Op code: URP row dependencies Disabled

xtype: XA flags: 0x00000000 bdba: 0x004000e1 hdba: 0x004000e0

itli: 2 ispac: 0 maxfr: 4863

tabn: 0 slot: 1(0x1) flag: 0x2c lock: 0 ckix: 0

ncol: 17 nnew: 12 size: 0

col 1: [20] 5f 53 59 53 53 4d 55 31 5f 32 38 35 36 35 33 34 36 37 30 24

col 2: [ 2] c1 02

col 3: [ 3] c2 0b 19

col 4: [ 3] c2 02 1d

col 5: [ 6] c5 14 2f 46 28 64

col 6: [ 3] c2 1d 30

col 7: [ 5] c4 02 31 35 3e

col 8: [ 3] c2 22 63

col 9: [ 2] c1 02

col 10: [ 2] c1 04

col 11: [ 2] c1 03

col 16: [ 2] c1 03

Block after image is corrupt:

buffer tsn: 0 rdba: 0x0042bb4c (1/179020)

scn: 0x0b26.a88e815e seq: 0x01 flg: 0x04 tail: 0x815e0201

frmt: 0x02 chkval: 0xf022 type: 0x02=KTU UNDO BLOCK

Hex dump of block: st=0, typ_found=1

Dump of memory from 0x000000094E07A000 to 0x000000094E07C000

94E07A000 0000A202 0042BB4C A88E815E 04010B26 [....L.B.^...&...]

94E07A010 0000F022 004E0000 00000B5B 1D1D0F4C [".....N.[...L...]

我们知道在file 1 block 179020的时候redo和undo信息不匹配,出现了上述的ORA 600 4194的错误.进一步分析

Block image after block recovery:

buffer tsn: 0 rdba: 0x00400080 (1/128)

scn: 0x0b26.6389e19d seq: 0x01 flg: 0x04 tail: 0xe19d0e01

frmt: 0x02 chkval: 0x7c95 type: 0x0e=KTU UNDO HEADER W/UNLIMITED EXTENTS

Hex dump of block: st=0, typ_found=1

Dump of memory from 0x000000094DAB2000 to 0x000000094DAB4000

94DAB2000 0000A20E 00400080 6389E19D 04010B26 [......@....c&...]

94DAB2010 00007C95 00000000 00000000 00000000 [.|..............]

94DAB2020 00000000 00000015 000002FF 00001020 [............ ...]

94DAB2030 0000000D 0000004C 00000080 0042BB4C [....L.......L.B.]

Extent Control Header

-----------------------------------------------------------------

Extent Header:: spare1: 0 spare2: 0 #extents: 21 #blocks: 767

last map 0x00000000 #maps: 0 offset: 4128

Highwater:: 0x0042bb4c ext#: 13 blk#: 76 ext size: 128

#blocks in seg. hdr's freelists: 0

#blocks below: 0

mapblk 0x00000000 offset: 13

Unlocked

Map Header:: next 0x00000000 #extents: 21 obj#: 0 flag: 0x40000000

Extent Map

-----------------------------------------------------------------

0x00400081 length: 7

0x00413a38 length: 8

0x00400088 length: 8

0x00413a30 length: 8

0x0042b888 length: 8

0x0042b890 length: 8

0x0042b898 length: 8

0x0042b8a0 length: 8

0x0042b8a8 length: 8

0x0042b8b0 length: 8

0x0042b8b8 length: 8

0x0042b8c0 length: 8

0x0042ba80 length: 128

0x0042bb00 length: 128

0x0042bc00 length: 128

0x0042bc80 length: 128

0x0042bb80 length: 128

0x00400210 length: 8

0x00400218 length: 8

0x00400220 length: 8

0x00400228 length: 8

TRN CTL:: seq: 0x0f4c chd: 0x001b ctl: 0x0043 inc: 0x00000000 nfb: 0x0001

mgc: 0x8002 xts: 0x0068 flg: 0x0001 opt: 2147483646 (0x7ffffffe)

uba: 0x0042bb4c.0f4c.0c scn: 0x0b23.ccb9eb89

Version: 0x01

FREE BLOCK POOL::

uba: 0x0042bb4c.0f4c.0c ext: 0xd spc: 0x132a

uba: 0x00000000.0f4c.0c ext: 0xd spc: 0x12f6

uba: 0x00000000.0f4c.01 ext: 0xd spc: 0x1ec8

uba: 0x00000000.0f4c.04 ext: 0xd spc: 0x1b86

uba: 0x00000000.0f4c.09 ext: 0xd spc: 0x162c

TRN TBL::

index state cflags wrap# uel scn dba parent-xid nub stmt_num

------------------------------------------------------------------------------------------------

0x00 9 0x00 0x0b62 0x0011 0x0b25.2dacaf61 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x01 9 0x00 0x0b64 0x0024 0x0b24.a6a2cf7b 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x02 9 0x00 0x0b65 0x0036 0x0b25.7391eda0 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x03 9 0x00 0x0b4f 0x0007 0x0b24.337bf49b 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x04 9 0x00 0x0b64 0x0051 0x0b23.ff22c637 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x05 9 0x00 0x0b64 0x0022 0x0b26.4393eb1e 0x0042bb4c 0x0000.000.00000000 0x00000001 0x00000000

0x06 9 0x00 0x0b66 0x0058 0x0b24.335c794d 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x07 9 0x00 0x0b4f 0x001d 0x0b24.4e05f2af 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x08 9 0x00 0x0b65 0x005e 0x0b23.ff22c618 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x09 9 0x00 0x0b5f 0x0035 0x0b24.337bf3d9 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x0a 9 0x00 0x0b64 0x004f 0x0b25.7391ee5f 0x0042bb4c 0x0000.000.00000000 0x00000001 0x00000000

0x0b 9 0x00 0x0b64 0x0040 0x0b24.335c7bd7 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x0c 9 0x00 0x0b65 0x0002 0x0b25.7391e929 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x0d 9 0x00 0x0b4f 0x0033 0x0b24.a6a2caa5 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x0e 9 0x00 0x0b65 0x0008 0x0b23.ff22c616 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x0f 9 0x00 0x0b61 0x0038 0x0b26.6389e195 0x0042bb4c 0x0000.000.00000000 0x00000001 0x00000000

0x10 9 0x00 0x0b4f 0x002a 0x0b24.bcff18b3 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x11 9 0x00 0x0b5c 0x0059 0x0b25.2dacaf69 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x12 9 0x00 0x0b65 0x0026 0x0b25.2dacb0a8 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x13 9 0x00 0x0b66 0x0021 0x0b24.a6a2caaa 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x14 9 0x00 0x0b62 0x0009 0x0b24.337bf3d7 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x15 9 0x00 0x0b63 0x0031 0x0b25.1b4e13ba 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x16 9 0x00 0x0b66 0x003b 0x0b25.2dacee5d 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x17 9 0x00 0x0b63 0x0034 0x0b26.6389e199 0x0042bb4c 0x0000.000.00000000 0x00000001 0x00000000

0x18 9 0x00 0x0b5d 0x002f 0x0b24.bcff18af 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x19 9 0x00 0x0b5b 0x004d 0x0b24.d60f78e3 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x1a 9 0x00 0x0b60 0x005b 0x0b25.1b4e13be 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x1b 9 0x00 0x0b62 0x003e 0x0b23.ccb9ebac 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x1c 9 0x00 0x0b65 0x000a 0x0b25.7391ee5c 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x1d 9 0x00 0x0b64 0x002c 0x0b24.4e05f2b1 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x1e 9 0x00 0x0b64 0x0045 0x0b24.33255ae9 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x1f 9 0x00 0x0b64 0x0015 0x0b25.1b4e13b5 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x20 9 0x00 0x0b63 0x0050 0x0b24.335c79a4 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x21 9 0x00 0x0b5d 0x0001 0x0b24.a6a2caf0 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x22 9 0x00 0x0b65 0x000f 0x0b26.4393eb20 0x0042bb4c 0x0000.000.00000000 0x00000001 0x00000000

0x23 9 0x00 0x0b62 0x0042 0x0b24.337bf3d2 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x24 9 0x00 0x0b65 0x003c 0x0b24.a6a2d137 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x25 9 0x00 0x0b62 0x0020 0x0b24.335c795d 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x26 9 0x00 0x0b63 0x0052 0x0b25.2dacee48 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x27 9 0x00 0x0b4e 0x003a 0x0b25.7391ee58 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x28 9 0x00 0x0b65 0x0049 0x0b25.2dacb089 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x29 9 0x00 0x0b61 0x0030 0x0b24.bcff18bb 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x2a 9 0x00 0x0b65 0x0057 0x0b24.bcff18b5 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x2b 9 0x00 0x0b64 0x0054 0x0b25.2dacee55 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x2c 9 0x00 0x0b61 0x000d 0x0b24.4e05f2b3 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x2d 9 0x00 0x0b64 0x000e 0x0b23.ff22c611 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x2e 9 0x00 0x0b65 0x0053 0x0b25.7391e78a 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x2f 9 0x00 0x0b66 0x0010 0x0b24.bcff18b1 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x30 9 0x00 0x0b63 0x0019 0x0b24.d60f78e1 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x31 9 0x00 0x0b65 0x001a 0x0b25.1b4e13bc 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x32 9 0x00 0x0b65 0x0037 0x0b24.a6a2d369 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x33 9 0x00 0x0b4f 0x0013 0x0b24.a6a2caa7 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x34 9 0x00 0x0b63 0x0043 0x0b26.6389e19b 0x0042bb4c 0x0000.000.00000000 0x00000001 0x00000000

0x35 9 0x00 0x0b65 0x0046 0x0b24.337bf409 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x36 9 0x00 0x0b52 0x0061 0x0b25.7391eda2 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x37 9 0x00 0x0b64 0x0018 0x0b24.bcff18ad 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x38 9 0x00 0x0b65 0x0017 0x0b26.6389e197 0x0042bb4c 0x0000.000.00000000 0x00000001 0x00000000

0x39 9 0x00 0x0b62 0x0006 0x0b24.335c7947 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x3a 9 0x00 0x0b64 0x001c 0x0b25.7391ee5a 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x3b 9 0x00 0x0b4d 0x002e 0x0b25.7391e730 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x3c 9 0x00 0x0b65 0x0032 0x0b24.a6a2d144 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x3d 9 0x00 0x0b65 0x0016 0x0b25.2dacee59 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x3e 9 0x00 0x0b63 0x002d 0x0b23.ff22c60b 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x3f 9 0x00 0x0b63 0x005f 0x0b24.335c7b57 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x40 9 0x00 0x0b65 0x0044 0x0b24.335c7bd9 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x41 9 0x00 0x0b65 0x0029 0x0b24.bcff18b9 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x42 9 0x00 0x0b61 0x0014 0x0b24.337bf3d4 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x43 9 0x00 0x0b5b 0xffff 0x0b26.6389e19d 0x0042bb4c 0x0000.000.00000000 0x00000001 0x00000000

0x44 9 0x00 0x0b4c 0x004b 0x0b24.335c7bdb 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x45 9 0x00 0x0b61 0x0039 0x0b24.335c7945 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x46 9 0x00 0x0b65 0x005a 0x0b24.337bf421 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x47 9 0x00 0x0b65 0x0027 0x0b25.7391eda8 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x48 9 0x00 0x0b62 0x004e 0x0b24.335c7953 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x49 9 0x00 0x0b63 0x0012 0x0b25.2dacb09f 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x4a 9 0x00 0x0b63 0x0023 0x0b24.335c7bf8 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x4b 9 0x00 0x0b5b 0x004a 0x0b24.335c7bf3 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x4c 9 0x00 0x0b63 0x003f 0x0b24.335c7b55 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x4d 9 0x00 0x0b61 0x001f 0x0b25.1b4e13b3 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x4e 9 0x00 0x0b5a 0x0025 0x0b24.335c795b 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x4f 9 0x00 0x0b5f 0x005c 0x0b25.8ff588bb 0x0042bb4c 0x0000.000.00000000 0x00000001 0x00000000

0x50 9 0x00 0x0b63 0x004c 0x0b24.335c79a7 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x51 9 0x00 0x0b64 0x005d 0x0b24.0c84cbf4 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x52 9 0x00 0x0b65 0x002b 0x0b25.2dacee49 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x53 9 0x00 0x0b64 0x000c 0x0b25.7391e927 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x54 9 0x00 0x0b63 0x003d 0x0b25.2dacee56 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x55 9 0x00 0x0b64 0x0005 0x0b26.4393eada 0x0042bb4c 0x0000.000.00000000 0x00000001 0x00000000

0x56 9 0x00 0x0b64 0x0055 0x0b26.4393ead3 0x0042bb4c 0x0000.000.00000000 0x00000001 0x00000000

0x57 9 0x00 0x0b60 0x0041 0x0b24.bcff18b7 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x58 9 0x00 0x0b65 0x0060 0x0b24.335c794f 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x59 9 0x00 0x0b60 0x0028 0x0b25.2dacaf74 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x5a 9 0x00 0x0b61 0x0003 0x0b24.337bf499 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

0x5b 9 0x00 0x0b62 0x0000 0x0b25.1b4e13c0 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x5c 9 0x00 0x0b62 0x0056 0x0b25.950a6e4b 0x0042bb4c 0x0000.000.00000000 0x00000001 0x00000000

0x5d 9 0x00 0x0b63 0x001e 0x0b24.33255ae7 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x5e 9 0x00 0x0b5f 0x0004 0x0b23.ff22c635 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x5f 9 0x00 0x0b64 0x000b 0x0b24.335c7bd5 0x0042bb49 0x0000.000.00000000 0x00000001 0x00000000

0x60 9 0x00 0x0b61 0x0048 0x0b24.335c7950 0x0042bb4b 0x0000.000.00000000 0x00000001 0x00000000

0x61 9 0x00 0x0b65 0x0047 0x0b25.7391eda6 0x0042bb4a 0x0000.000.00000000 0x00000001 0x00000000

KQRCMT: Write failed with error=600 po=0xa47e092c0 cid=3

diagnostics : cid=3 hash=35e74caf flag=2a

ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []

ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [], [], [], [], []

到这里我们基本上明白了报错的file 1 block 179020是由FREE BLOCK POOL分配出来的,现在解决给问题的思路就是直接使用bbed分配一个新块即可.

ORA-600 6711

数据库无法正常open报ORA 600 6711错误

Thu Jul 14 04:04:28 2016

alter database open

Beginning crash recovery of 1 threads

parallel recovery started with 32 processes

Started redo scan

Completed redo scan

read 1 KB redo, 0 data blocks need recovery

Started redo application at

Thread 1: logseq 2, block 3

Recovery of Online Redo Log: Thread 1 Group 2 Seq 2 Reading mem 0

Mem# 0: /data/amdu/redo/DATA_EC_260.f

Completed redo application of 0.00MB

Completed crash recovery at

Thread 1: logseq 2, block 5, scn 12269633687653

0 data blocks read, 0 data blocks written, 1 redo k-bytes read

Thu Jul 14 04:04:29 2016

Thread 1 advanced to log sequence 3 (thread open)

Thread 1 opened at log sequence 3

Current log# 3 seq# 3 mem# 0: /data/amdu/redo/DATA_EC_263.f

Successful open of redo thread 1

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

After successful startup of the database, please remove

the parameters _allow_error_simulation and _smu_debug_mode

and restart the database

Thu Jul 14 04:04:29 2016

SMON: enabling cache recovery

Undo initialization finished serial:0 start:270626334 end:270626544 diff:210 (2 seconds)

Dictionary check beginning

Tablespace 'TEMP' #3 found in data dictionary,

but not in the controlfile. Adding to controlfile.

Corrected file 19 plugged in read-only status in control file

Corrected file 81 plugged in read-only status in control file

Corrected file 88 plugged in read-only status in control file

Corrected file 93 plugged in read-only status in control file

Corrected file 128 plugged in read-only status in control file

Corrected file 130 plugged in read-only status in control file

Corrected file 131 plugged in read-only status in control file

Corrected file 163 plugged in read-only status in control file

Corrected file 181 plugged in read-only status in control file

Corrected file 184 plugged in read-only status in control file

Corrected file 186 plugged in read-only status in control file

Corrected file 191 plugged in read-only status in control file

Corrected file 214 plugged in read-only status in control file

Corrected file 220 plugged in read-only status in control file

Dictionary check complete

Verifying file header compatibility for 11g tablespace encryption..

Verifying 11g file header compatibility for tablespace encryption completed

SMON: enabling tx recovery

*********************************************************************

WARNING: The following temporary tablespaces contain no files.

This condition can occur when a backup controlfile has

been restored. It may be necessary to add files to these

tablespaces. That can be done using the SQL statement:

ALTER TABLESPACE <tablespace_name> ADD TEMPFILE

Alternatively, if these temporary tablespaces are no longer

needed, then they can be dropped.

Empty temporary tablespace: TEMP

*********************************************************************

Updating character set in controlfile to ZHS16GBK

WARNING: event 8105 is set. This event disables failed

online index [re]build cleanup

No Resource Manager plan active

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process QMNC

Thu Jul 14 04:04:30 2016

QMNC started with pid=57, OS id=3549

LOGSTDBY: Validating controlfile with logical metadata

LOGSTDBY: Validation complete

Errors in file /oracle/app/oracle/diag/rdbms/xifenfei/xifenfei/trace/xifenfei_ora_3401.trc (incident=1440450):

ORA-00600: internal error code, arguments: [6711], [4293062], [1], [4318348], [0], [], [], [], [], [], [], []

Incident details in: /oracle/app/oracle/diag/rdbms/xifenfei/xifenfei/incident/incdir_1440450/xifenfei_ora_3401_i1440450.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Error 600 in kwqmnpartition(), aborting txn

Thu Jul 14 04:04:32 2016

Dumping diagnostic data in directory=[cdmp_20801214040432], requested by (instance=1, osid=3401), summary=[incident=1440450].

Thu Jul 14 04:04:32 2016

Errors in file /oracle/app/oracle/diag/rdbms/xifenfei/xifenfei/trace/xifenfei_mmon_3329.trc (incident=1440178):

ORA-00600: internal error code, arguments: [6711], [4293062], [1], [4318348], [0], [], [], [], [], [], [], []

Incident details in: /oracle/app/oracle/diag/rdbms/xifenfei/xifenfei/incident/incdir_1440178/xifenfei_mmon_3329_i1440178.trc

Errors in file /oracle/app/oracle/diag/rdbms/xifenfei/xifenfei/trace/xifenfei_ora_3401.trc (incident=1440451):

ORA-00600: internal error code, arguments: [6711], [4293062], [1], [4318348], [0], [], [], [], [], [], [], []

Incident details in: /oracle/app/oracle/diag/rdbms/xifenfei/xifenfei/incident/incdir_1440451/xifenfei_ora_3401_i1440451.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Errors in file /oracle/app/oracle/diag/rdbms/xifenfei/xifenfei/trace/xifenfei_mmon_3329.trc (incident=1440179):

ORA-00600: internal error code, arguments: [6711], [4293062], [1], [4318348], [0], [], [], [], [], [], [], []

Incident details in: /oracle/app/oracle/diag/rdbms/xifenfei/xifenfei/incident/incdir_1440179/xifenfei_mmon_3329_i1440179.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

ORA-600 signalled during: alter database open...

数据库正常open失败,但是可以upgrade启动.根据对trace文件的分析,定位到问题在HISTGRM$表上面,进一步分析该表结构为

CREATE TABLE SYS.HISTGRM$

(

OBJ# NUMBER,

COL# NUMBER,

ROW# NUMBER,

BUCKET NUMBER,

ENDPOINT NUMBER,

INTCOL# NUMBER,

EPVALUE VARCHAR2(1000 BYTE),

SPARE1 NUMBER,

SPARE2 NUMBER

)

CLUSTER SYS.C_OBJ#_INTCOL#(OBJ#, INTCOL#);

这个和ORA-600 6711错误相匹配了

ERROR:

ORA-600 [6711] [a] [b] 1 [d]

VERSIONS:

versions 6.0 to 12.1

DESCRIPTION:

This error is generated when we find more blocks on a cluster key

chain than are supposed to be there.

Usually this indicates that the chain contains a loop within itself. We

cannot have more than 65535 blocks in a chain.

ARGUMENTS:

Arg [a] beginning DBA

Arg [b] table slot number (in table index)

Arg {c} dba of key next in chain

Arg [d] row slot of key next in chain

需要处理该错误,也就是需要处理CLUSTER SYS.C_OBJ#_INTCOL#,这个可以通过重建来实现,但是当重建之时发生

ORA-00600: internal error code, arguments: [kkoipt:invalid aptyp], [0], [0], [], [], [], [], [], [], [], [], []

ORA-08102: index key not found, obj# 39, file 1, block 1374829 (2)

这里错误比较明显obj#=39为obj$的i_obj4的index的记录和表不匹配,导致任何ddl无法执行,因此如果要处理C_OBJ#_INTCOL#就必须要先处理i_obj4的问题.通过一些技巧重建i_obj4,然后重建C_OBJ#_INTCOL#,数据库终于可以正常打开.由于大量数据字典不一致,exp/expdp导出依旧有问题,通过dblink直接拉数据到新库,完成本次恢复

补充说明：1. 在这个库的恢复过程中,我们还使用了大量的event和隐含参数,因为比较常规而且不涉及核心环节,因为未列举出来;2. 由于当时操作记录未能够保留日志因此相关操作步骤无法贴出来,本文只能提供恢复处理思路

再次提醒各位数据库做好备份,做好巡检工作,哪怕是强大的Oracle exadata也禁不起无备份折腾,数据重于一切

weixin_39814925
关注
oracle 回滚段快照过旧,案例:Oracle数据库无法启动报错ORA-01555 解决快照过旧办法汇总...
weixin_42613505的博客
04-03 1798
天萃荷净在数据库open过程中常遇到ORA-01555汇总在数据库open的过程中，select ctime, mtime, stime from obj$ where obj# = :1语句报ORA-01555错误,数据库无法正常open一般情况下会报某个回滚段,但是这里ORA-01555: snapshot too old: rollback segment number 0 with nam...
oracle 11g ora 00202,ORA-00202 – 提供7*24专业数据库(Oracle,SQL Server,MySQL等)恢复和Oracle技术服务@Tel:+86 13429648...
weixin_32040059的博客
04-08 1131
老朋友找我帮忙，说他们从笔记本中拷贝数据库到客户服务器上，无法启动，让我帮忙看下启动报ORA-00211 ORA-00202错误C:\Users\Administrator>sqlplus / as sysdbaSQL*Plus: Release 12.1.0.1.0 Production on 星期二 10月 13 21:35:45 2015Copyright (c) 1982, 201...
数据库open遭遇ora-01555错误
Roger的数据库专栏
03-15 1083
原文链接：http://www.killdb.com/2017/07/09/%e6%95%b0%e6%8d%ae%e5%ba%93open%e9%81%ad%e9%81%87ora-01555%e9%94%99%e8%af%af/ 前几天我们的一位准客户的其中一套较为重要的数据库出现了故障。我们这里先姑且不去分析原因，来将数据库打开提供业务恢复再说。首先我们来看下一线工程师现场发回的报道： ...
ORA-00600_内部错误代码_参数 [4193]Error 600 in redo application callback
wolihaito的博客
02-07 1345
做冷备恢复时 报ORA-00600错误： ORA-00600: 内部错误代码, 参数: [4193][ Error 600 in redo application callback （trace 部分信息如下） *** 2020-02-07 20:02:35.755 Incident 6165 created, dump file: E:\APP\WOLIHAITO\diag\rdbms\orc...
ORA-00600: 内部错误代码, 参数: [4194]或[4193]
ckth47350的博客
06-11 2510
ORA-00600: 内部错误代码, 参数: [4194]或[4193] 数据库版本：Oracle 11.2.0.1.0 数据库服务器操作系统：Windows serve...
记录一次隐含参数也不好解决的备份恢复.pdf
11-07
‐‐ 报错： 5 ORA‐01194: file 1 needs more recovery to be consistent 6 ORA‐01110: data file 1: '/u01/oradata/db/system01.dbf' -- 加隐含参数后报错： ORA‐01092: ORACLE instance terminated. Disconnection forced 11 ORA‐00704: bootstrap process failure 12 ORA‐00604: error occurred at recursive SQL level 2 13 ORA‐01555: snapshot too old: rollback segment number 7 with name 14 "_SYSSMU7_4222772309$" too small 15 Process ID: 1730 16 Session ID: 1996 Serial number: 3
Oracle19C RAC通过gateways连接SQL server数据库
最新发布
04-11
在本场景中，我们探讨的是如何在Oracle 19C RAC环境中通过Oracle数据库网关（Gateway）连接到SQL Server 2012数据库。Oracle Gateway使得不同数据库系统间的数据交互成为可能，实现异构数据库间的透明访问。 首先，...
content+os+mysql_O/S-Error: (OS 2) – 提供7*24专业数据库(Oracle,SQL Server,MySQL等)恢复和Oracle技术服务@Tel:+86 1342...
weixin_29505469的博客
01-26 343
有朋友反馈win环境下rac异常,asm无法正常mount,检查日志发现Fri Jul 03 03:55:46 2020Errors in file C:\APP\ADMINISTRATOR\diag\asm\+asm\+asm2\trace\+asm2_ora_7004.trc:ORA-15025: could not open disk "\\.\ORCLDISKDATA1"ORA-27041...
Oracle出现ora-12154无法解析指定连接标识符的解决方法
01-19
在程序中连接Oracle数据库的方式与其他常用数据库，如：MySql,Sql Server不同，这些数据库可以通过直接指定IP的方式连接，但是Oracle则需要通过Oracle客户端配置网络服务名的方式来连接。否则就会出现“ORA-12154: ...
使用PHP连接多种数据库的实现代码(mysql,access,sqlserver,Oracle)
10-20
本文将重点介绍如何使用PHP语言连接四种常见的数据库系统：MySQL、Microsoft Access、Microsoft SQL Server和Oracle。尽管这些数据库系统具有不同的特性和访问方式，但PHP提供了相应的数据库抽象层来简化连接和操作...
Oracle 启动故障案例之--ORA-600 [4193]错误
天涯客*Blog
12-14 7316
Oracle 启动故障案例之--ORA-600 [4193]错误 操作系统：Oracle Linux 5 数据库：    Oracle 11gR2（11.2.0.3.0） 一、故障现象： 1、在做了redo log当前日志组被破坏恢复的测试后 2、启动数据库后出现ORA-600 【4193】的错误 3、数据库被强制关闭 查看告警日志： [oracle@ocm1 ~]$ ta
由ORA-600错引发的宕机故障
congjicai3942的博客
02-02 190
最近ODS数据库似乎就没怎么太平过，好不容易把一个问题解决，新的问题又会再冒出来。这不，今天早上一起来，就收到短信，凌晨数据库节点1重启过了。 郁闷的来到公司，打开电脑查看日志，呵呵，熟悉的ORA-600错误在向我招手...
redo 日志损坏引发的ora 600错误
weixin_33742618的博客
10-08 115
由于测试环境早期的数据库参数文件命名不规范，导致维护人员在碰到redo log损坏时将redo log clear掉，结果发现启动了错误的DB，而该redo log 不该被clear的。 而后启动正确的DB後，出现无法的open的状况。处理过程如下 1、增加下列参数至Oracle启动文件: _allow_resetlogs_corruption=TRUE 2、recover datab...
断电与ORA-600错误处理集合
csdn20142的博客
04-12 243
断电与ORA-600错误处理集合 目 录 断电与ORA-600错误处理集合..............................................................................
oracle数据恢复后比对,记录一次比较棘手数据库恢复要点 – 提供7*24专业数据库(Oracle,SQL Server,MySQL等)恢复和Oracle技术服务@Tel:+86 134296487...
weixin_31509753的博客
04-16 268
在最近的一次数据库异常恢复过程中遇到不少问题,把重点记录下ORA-00704/ORA-01555错误Fri May 4 21:04:21 2012select ctime, mtime, stime from obj$ where obj# = :1Fri May 4 21:04:21 2012Errors in file /oracle/admin/standdb/udump/perfdb_...
oracle内部错误4194,ORA-00600: 内部错误代码, 参数: [4194]或[4193]
weixin_34086714的博客
04-05 322
Bug 21977392ORA-600[4193] ORA-600 [ktbair1] ORA-600 [1234] ORA-600 [6856] block type 'ktu undoblock' on recovery of encrypt datafileThisnote gives a brief overview of bug 21977392.The content was la...
在线重定义引起的数据库挂起
ckawt40802的专栏
07-23 199
一个客户的数据库突然出现了HANG死的情况，连SQLPLUS都无法正常连接到数据库。 数据库版本为11.2.0.2 for Linux x86-64。客户由于要迅速解决问题...
[小e笔记]之翻译的翻&译文的译——Ora-600 [4193] WhenOpening Or Shutting Down A Database [ID 452662.1]
小e笔记
10-17 2248
Ora-600 [4193] WhenOpening Or Shutting Down A Database [ID 452662.1] Symptoms --症状 Errors in alert.log: --警告日志文件报错内容 Tue Jul 17 13:38:13 2007 Errors in file /home/oracle/oracle/product/10.2.0/ym
Oracle ORA-600[4193] 解决方法 说明
热门推荐
David Dai -- Focus on Oracle
02-07 1万+
ORA-600[41XX] 这种错误基本都于UNDO 有关系。关于ORA-600参数的更多说明，参考我的Blog：ORA-600 各个参数含义说明http://blog.csdn.net/tianlesoftware/article/details/6645809 ORA-600[4193] 这个错误也是与UNDO 有关系，MOS 上有几篇相关的说明文章. 一.MOS说明 1.1 ORA-600
一键修复ORACLE Bootstrap故障：ORA-702 Recovery软件详解
用户可以通过7*24小时的专业服务获得帮助，包括Oracle、SQL Server和MySQL的恢复服务，可通过电话+8617813235971或作者提供的联系方式进行咨询。 在遇到数据库无法正常启动的问题，如ORA-01092或ORA-00704时，用户...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值