Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

999

积分

1

好友

942

主题
1#
发表于 2017-4-16 14:26:07 | 查看: 1753| 回复: 0
os:redhat linux
oracle:9207

alert.log如下:
Tue Mar 11 19:21:44 2008
Errors in file /oracle/admin/q1wip01/udump/q1wip01_ora_13176.trc:
ORA-00600: internal error code, arguments: [6002], [0], [112], [9], [0], [], [], []
Tue Mar 11 19:21:46 2008
Errors in file /oracle/admin/q1wip01/udump/q1wip01_ora_13176.trc:
ORA-00600: internal error code, arguments: [2662], [0], [3322146038], [6773], [2522038368], [16], [], []
ORA-00600: internal error code, arguments: [6002], [0], [112], [9], [0], [], [], []
Tue Mar 11 19:21:52 2008
Errors in file /oracle/admin/q1wip01/udump/q1wip01_ora_13176.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [0], [3322146038], [6773], [2522038368], [16], [], []
ORA-00600: internal error code, arguments: [6002], [0], [112], [9], [0], [], [], []
Tue Mar 11 19:41:17 2008
Errors in file /oracle/admin/q1wip01/udump/q1wip01_ora_18614.trc:
ORA-00600: internal error code, arguments: [4519], [6], [184592835], [1], [], [], [], []
Tue Mar 11 19:41:26 2008
Errors in file /oracle/admin/q1wip01/udump/q1wip01_ora_18653.trc:
ORA-00600: internal error code, arguments: [4519], [6], [184592835], [1], [], [], [], []
Tue Mar 11 19:41:55 2008
Errors in file /oracle/admin/q1wip01/udump/q1wip01_ora_18653.trc:
ORA-00600: internal error code, arguments: [4519], [6], [184592835], [1], [], [], [], []
Tue Mar 11 19:44:46 2008
Errors in file /oracle/admin/q1wip01/udump/q1wip01_ora_18667.trc:
ORA-00600: internal error code, arguments: [4519], [6], [184592835], [1], [], [], [], []
Tue Mar 11 19:45:44 2008
Errors in file /oracle/admin/q1wip01/udump/q1wip01_ora_18667.trc:
ORA-00600: internal error code, arguments: [4519], [6], [184592835], [1], [], [], [], []



多谢.相关内容如下:

/oracle/admin/q1wip01/udump/q1wip01_ora_18653.trc
Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
ORACLE_HOME = /oracle/product/9.2
System name:        Linux
Node name:        Q1WIP001
Release:        2.6.9-42.ELsmp
Version:        #1 SMP Wed Jul 12 23:32:02 EDT 2006
Machine:        x86_64
Instance name: q1wip01
Redo thread mounted by this instance: 1
Oracle process number: 161
Unix process pid: 18653, image: oracle@Q1WIP001 (TNS V1-V3)

*** SESSION ID232.20510) 2008-03-11 19:41:26.005
Dump of buffer cache at level 10
BH (0x0x96fab800) file#: 44 rdba: 0x0b00a9c3 (44/43459) class 1 ba: 0x0x96530000
  set: 11 dbwrid: 0 obj: 35493 objn: 32669
  hash: [ad9f2518,ad9f2518] lru: [8afda068,87ff7d68]
  LRU flags: hot_buffer
  ckptq: [NULL] fileq: [NULL]
  st: XCURRENT md: NULL rsop: 0x(nil) tch: 0
  LRBA: [0x0.0.0] HSCN: [0xffff.ffffffff] HSUB: [255] RRBA: [0x0.0.0]
  buffer tsn: 6 rdba: 0x00333152 (0/3354962)
  scn: 0x0000.c5e1b72e seq: 0x01 flg: 0x06 tail: 0xb72e0601
  frmt: 0x00 chkval: 0x7402 type: 0x01=KTU UNDO HEADER
Hex dump of corrupt header 4 = CORRUPT
Dump of memory from 0x0000000096530000 to 0x0000000096530014
096530000 00000001 00333152 C5E1B72E 06010000  [....R13.........]
096530010 00007402                             [.t..]            
Hex dump of corrupt block
Dump of memory from 0x0000000096530014 to 0x0000000096531FFC
096530010          00000002 BFFFA090 0000007F      [............]
096530020 00000000 00320002 00000001 00343152  [......2.....R14.]
096530030 00000000 00000000 00000002 00000000  [................]
096530040 00000006 00000000 00000000 00807A66  [............fz..]
096530050 00000001 00353152 C5E1B72E 00000000  [....R15.........]
096530060 00000002 02800000 96534C10 00000000  [.........LS.....]
096530070 00000000 00000000 00000001 00505352  [............RSP.]
096530080 00000006 4EC01F60 1F361F02 1F0C1F21  [....`..N..6.!...]
096530090 960743F8 0000002A 00000000 1E641E79  [.C..*.......y.d.]




35493应该是个index
32272应该是个table

如果现在alert.log一直报ORA-00600: internal error code, arguments: [4519]的话,可以考虑先重启数据库,看是否还频繁报ORA-600,如果有,再根据trace来确定是哪个object可能有问题,到时候可以考虑重建等。
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-5-19 10:13 , Processed in 0.046044 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569