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

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

999

积分

1

好友

942

主题
1#
发表于 2017-4-12 18:36:59 | 查看: 1262| 回复: 0
急,求帮忙!
oracle 11.1.0.7.0

数据库反复报600错误后死机。
Errors in file /app/oracle/product/diag/rdbms/dbpub/dbpub/trace/dbpub_smon_22158.trc  (incident=225657):
ORA-00600: internal error code, arguments: [kcbgcur_1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /app/oracle/product/diag/rdbms/dbpub/dbpub/incident/incdir_225657/dbpub_smon_22158_i225657.trc
Fri Dec 31 17:26:22 2010
Errors in file /app/oracle/product/diag/rdbms/dbpub/dbpub/trace/dbpub_pmon_22136.trc:
ORA-00474: SMON process terminated with error
PMON (ospid: 22136): terminating the instance due to error 474
Instance terminated by PMON, pid = 22136



跟踪文件信息:
oracle@dbpub-144:/app/arc> more /app/oracle/product/diag/rdbms/dbpub/dbpub/trace/dbpub_smon_22158.trc
Trace file /app/oracle/product/diag/rdbms/dbpub/dbpub/trace/dbpub_smon_22158.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /app/oracle/product/11.1.0/db_1
System name:    Linux
Node name:      dbpub-144
Release:        2.6.27.7-9-default
Version:        #1 SMP 2008-12-04 18:10:04 +0100
Machine:        x86_64
Instance name: dbpub
Redo thread mounted by this instance: 1
Oracle process number: 12
Unix process pid: 22158, image: oracle@dbpub-144 (SMON)

*** 2010-12-31 17:05:41.071
*** SESSION ID544.1) 2010-12-31 17:05:41.071
*** CLIENT ID) 2010-12-31 17:05:41.071
*** SERVICE NAME) 2010-12-31 17:05:41.071
*** MODULE NAME) 2010-12-31 17:05:41.071
*** ACTION NAME) 2010-12-31 17:05:41.071

Incident 225653 created, dump file: /app/oracle/product/diag/rdbms/dbpub/dbpub/incident/incdir_225653/dbpub_smon_22158_i225653.trc
ORA-00600: internal error code, arguments: [kcbgcur_1], [], [], [], [], [], [], [], [], [], [], []

************ dump undo block **********
Dump of buffer cache at level 3 for tsn=2, rdba=12737394
BH (0x303f4f6e8) file#: 3 rdba: 0x00c25b72 (3/154482) class: 30 ba: 0x302cfe000
  set: 11 bsz: 8192 bsi: 0 sflg: 2 pwc: 0, 0 lid: 0x00000000,0x00000000
  dbwrid: 0 obj: -1 objn: 0 tsn: 2 afn: 3
  hash: [0x4452b84c8,0x4452b84c8] lru: [0x303f4f8a8,0x303f4f648]
  ckptq: [NULL] fileq: [NULL] objq: [0x303f4f928,0x42cb91528]
  st: XCURRENT md: NULL tch: 1
  flags: gotten_in_current_mode
  LRBA: [0x0.0.0] LSCN: [0x0.0] HSCN: [0xffff.ffffffff] HSUB: [65535]
  cr pin refcnt: 0 sh pin refcnt: 0
  buffer tsn: 2 rdba: 0x00c25b72 (3/154482)
  scn: 0x0009.38264c9e seq: 0x08 flg: 0x04 tail: 0x4c9e0208
  frmt: 0x02 chkval: 0x0cac type: 0x02=KTU UNDO BLOCK
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x0000000302CFE000 to 0x0000000302D00000
302CFE000 0000A202 00C25B72 38264C9E 04080009  [....r[...L&8....]
302CFE010 00000CAC 00110007 000CCC5C 09096AAD  [........\....j..]
302CFE020 1FE80000 1AA41C2C 14841810 106013EC  [....,.........`.]
302CFE030 0C740FC8 00000BDC 00000000 00000000  [..t.............]
302CFE040 00000000 00000000 00000000 00000000  [................]
        Repeat 186 times
302CFEBF0 00180010 001C0020 000C0020 00010001  [.... ... .......]
302CFEC00 00000000 00000000 00000000 00000000  [................]
302CFEC10 0811160A CC5C0000 00C00D04 001567E2  [......\......g..]
302CFEC20 000E0004 000B9E19 00C3B5CD 00386747  [............Gg8.]
302CFEC30 00098000 34AA412A 34250205 00000000  [....*A.4..%4....]
302CFEC40 0288D21B 00000002 32D30000 00000002  [...........2....]
302CFEC50 00100010 0F05C203 33314303 0A15C203  [.........C13....]
302CFEC60 6304C203 0F05C203 33314303 0A15C203  [...c.....C13....]
302CFEC70 0605C203 3FC34802 48021D00 1E003FC3  [.....H.?...H.?..]
302CFEC80 00000000 000000FF 00180010 00580020  [............ .X.]
302CFEC90 00BA01F0 00040004 000143D4 00018EB9  [.........C......]
302CFECA0 00000007 00000000 0711160A CC5C0010  [..............\.]
--More--(0%)


下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

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

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

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

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

GMT+8, 2024-12-20 16:52 , Processed in 0.046494 second(s), 22 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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