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

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

999

积分

1

好友

942

主题
1#
发表于 2017-4-15 23:26:45 | 查看: 1439| 回复: 0


异常断电,出现ORA-00600: internal error code, arguments: [4194], [20], [26],

只有用sys用户登录,其他用户不能登录
alert log如下:

Completed: ALTER DATABASE OPEN
Fri May  4 10:02:20 2012
Hex dump of (file 3, block 30723) in trace file /home/oracle/admin/group/bdump/group_j000_21822.trc
Corrupt block relative dba: 0x00c07803 (file 3, block 30723)
Fractured block found during buffer read
Data in bad block:
type: 6 format: 2 rdba: 0x00c07803
last change scn: 0x0000.012dd14e seq: 0x2 flg: 0x06
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0xd5310601
check value in block header: 0xb1ce
computed block checksum: 0x47c
Reread of rdba: 0x00c07803 (file 3, block 30723) found same corrupted data
Fri May  4 10:02:20 2012
Errors in file /home/oracle/admin/group/bdump/group_j000_21822.trc:
ORA-00600: internal error code, arguments: [4194], [20], [26], [], [], [], [], []
ORA-01578: ORACLE data block corrupted (file # 3, block # 30723)
ORA-01110: data file 3: '/home/oracle/oradata/group/sysaux01.dbf'
DEBUG: Replaying xcb 0x42dfc304, pmd 0x42faa56c for failed op 8
Doing block recovery for file 2 block 2574
Block recovery from logseq 512, block 64 to scn 19967201
Fri May  4 10:02:20 2012
Recovery of Online Redo Log: Thread 1 Group 1 Seq 512 Reading mem 0
  Mem# 0 errs 0: /home/oracle/oradata/group/redo01.log
Block recovery completed at rba 512.73.16, scn 0.19967203
Fri May  4 10:03:11 2012
Errors in file /home/oracle/admin/group/bdump/group_j000_21822.trc:
ORA-00600: internal error code, arguments: [4194], [20], [26], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [20], [26], [], [], [], [], []
ORA-01578: ORACLE data block corrupted (file # 3, block # 30723)
ORA-01110: data file 3: '/home/oracle/oradata/group/sysaux01.dbf'
Fri May  4 10:03:11 2012
Errors in file /home/oracle/admin/group/bdump/group_j000_21822.trc:
ORA-00600: internal error code, arguments: [4194], [20], [26], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [20], [26], [], [], [], [], []
ORA-01578: ORACLE data block corrupted (file # 3, block # 30723)
ORA-01110: data file 3: '/home/oracle/oradata/group/sysaux01.dbf'


接下来,怎么办???



谢谢!
是这样的, 我不是dba  所以在解决问题时,都是google完成的, 还好,我在处理前做了备份,现在我恢复回到了最初的那种情况下(以上的情况现在不存在了,咱不用再去解决600错误问题了,案例研究就另当别论)
最初的情况是这样的:
ORACLE 例程已经启动。

Total System Global Area  608174080 bytes
Fixed Size                    1220820 bytes
Variable Size                   92278572 bytes
Database Buffers          507510784 bytes
Redo Buffers                    7163904 bytes
数据库装载完毕。
ORA-01113: 文件 1 需要介质恢复
ORA-01110: 数据文件 1: '/home/oracle/oradata/group/system01.dbf'

没有归档,没有备份,这种情况下,怎样处理?
使用道具 举报
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

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

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

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

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

GMT+8, 2024-5-17 19:26 , Processed in 0.048431 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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