ORA-00600 [3020] ORA-10560问题处理

原创 2015年07月07日 16:02:21

渠道一用户,断电后数据库无法启动,渠道技术人员做了一些恢复尝试,包括重建控制文件、介质恢复提示如下错误:

Errors in filed:\oracle\diag\rdbms\orcl\orcl1\trace\orcl1_pr0g_5100.trc  (incident=259565):
ORA-00600: internal error code, arguments:[3020], [2], [102936], [8491544], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with datablock (file# 2, block# 102936, file offset is 843251712 bytes)
ORA-10564: tablespace SYSAUX
ORA-01110: data file 2:'G:\ORADATA\ORCL\SYSAUX01.DBF'
ORA-10560: block type 'FIRST LEVEL BITMAPBLOCK'
Incident details in:d:\oracle\diag\rdbms\orcl\orcl1\incident\incdir_259565\orcl1_pr0g_5100_i259565.trc
Slave exiting with ORA-600 exception
Errors in file d:\oracle\diag\rdbms\orcl\orcl1\trace\orcl1_pr0g_5100.trc:
ORA-00600: internal error code, arguments:[3020], [2], [102936], [8491544], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with datablock (file# 2, block# 102936, file offset is 843251712 bytes)
ORA-10564: tablespace SYSAUX
ORA-01110: data file 2:'G:\ORADATA\ORCL\SYSAUX01.DBF'
ORA-10560: block type 'FIRST LEVEL BITMAPBLOCK'

可能介质恢复过程中出现了坏块,还好recover database有个命令可以允许坏块,如下:

If you do not have a backup available, than the options are VERY limited. Please open a Service Request with Oracle Support Services for assistance on this.  Otherwise:

1. Use Trial Recovery to determine the extent of the problem:

SQL> recover database test;

This will tell you how many blocks (n) would be left corrupted after recovery - check the alert
log for details of the blocks affected.  If there are a large number of corruptions reported you may decide to restore from backup and issue point in time recovery.  However, if only a few blocks are reported as corrupt you could proceed with recovery :

2. Skip the corrupted block(s)

SQL> recover database allow 1 corruption;


Do this <n> times,  <n> being the number of blocks reported as corrupt in step 1 above.

This will allow recovery to continue,  'skipping' the blocks that cannot be recovered and leaving them marked as 'corrupt' after which the database can be opened.

3. Take the corrupt blocks reported in the alert log and for each,  identify the object that the block belongs to::

SQL> SELECT tablespace_name, segment_type, owner, segment_name
     FROM dba_extents
     WHERE file_id = <file#>
       and <block> between block_id AND block_id + blocks - 1;


Replacing <file#> and <block> with the file# and block ids reported in the alert log.

For each object identified - take steps to resolve the corruption:

- if it belongs to an index then simply drop and recreate the index

- if it belong to a user object then consider recreating the object or extracting what you can from the object; if necessary raise a Service Request with Oracle and request assistance with extracting data from a corrupt object. 

版权声明:本文为博主原创文章,未经博主允许不得转载。



ORA-10567,ORA-00313

 今天碰到一个奇怪的问题,有一个测试的数据库down了,我们一个同事去重新启动一下DB,但是过了几分钟后又down了,察看alert_*.log发现有下列错误:Errors in file /home...
  • compard
  • compard
  • 2007年09月17日 16:01
  • 3380

DataGuard - ORA-10567错误

数据库已经升级到9205,操作系统是Sun Solaris 8在Data Guard环境中作Primary端的数据导入,大概有2G的dmp文件导入过程中在Primary端添加一个数据文件由于设置了st...
  • Kamus
  • Kamus
  • 2004年08月30日 16:02
  • 3391

ORA-01194

今天碰到了一个ora-01194的错误,信息如下:ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error be...
  • compard
  • compard
  • 2008年01月25日 15:19
  • 5299

ORA-10567: Redo is inconsistent with data block

这两天 在做DG升级,备库应用日志的时候遭遇了以下问题: Media Recovery Log /export/11g/flash_recovery_area/ORCL2/archive...
  • huangliang0703
  • huangliang0703
  • 2015年02月09日 11:04
  • 851

ORA-00600: internal error code, arguments: [4194], [42], [41], [], [], [], [], [] 解决方法

 今天早上过来,发现一台数据库的实例没有起来,于是进行了启动操作,但是奇怪的是启动正常进行,在启动完成后的几秒钟内系统崩溃,进程也没有了,在进入sys下又可以重启,启动过程一切正常,但是现象也同样。查...
  • annicybc
  • annicybc
  • 2007年02月25日 16:56
  • 5443

ORA-00600: internal error code, arguments: [SKGMFAIL]问题解决

ORA-00600: internal error code, arguments: [SKGMFAIL]问题解决。
  • lvtao0519
  • lvtao0519
  • 2016年04月12日 17:15
  • 1292

ORA-00600 [3020] ORA-10560问题处理

渠道一用户,断电后数据库无法启动,渠道技术人员做了一些恢复尝试,包括重建控制文件、介质恢复提示如下错误: Errors in filed:\oracle\diag\rdbms\orcl\orcl1\t...
  • wenzhongyan
  • wenzhongyan
  • 2015年07月07日 16:02
  • 1428

ORA-XXXXX处理笔记

ORA-04062 :timestamp-of-package-has-been-changed http://blog.csdn.net/compard/article/details/26129...
  • compard
  • compard
  • 2012年04月25日 14:34
  • 1769

简单记录一次ORA-00600: internal error code, arguments: [4194]

接上一篇,在搞定SCN问题后,又遇到ORA-600[4194]/[4193]报错。 故障现象: OPEN数据库时报错:ORA-00600: internal error code, argumen...
  • q947817003
  • q947817003
  • 2014年07月04日 11:19
  • 1360

ORA-00600: 内部错误代码问题处理

SQL> shutdown immediate 已经卸载数据库。 ORACLE 例程已经关闭。 SQL> startup mount; ORACLE 例程已经启动。 Total System...
  • wlyahoo
  • wlyahoo
  • 2015年02月05日 09:38
  • 196
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:ORA-00600 [3020] ORA-10560问题处理
举报原因:
原因补充:

(最多只允许输入30个字)