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-600 [3020]解决方法

 http://blog.chinaunix.net/u/7121/showart_415391.html  本文来自网络; http://blog.chinaunix.net/u/7121/show...

ORA-10567,ORA-00313

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

ORA-00600[2662]问题模拟及解决方法

参照eygle的相关技术blog,测试下_disable_logging将对数据库产生的影响,由于是隐含参数,所以我们通过如下方法获取对这个参数的描述: SQL> select ksppinm,ks...

【问题记录】ORA-00600[ktspNextL1:4]_bug5649098_11.1.0.7之后已修复

今天看了一下alert log发现如下报错: 查看alert log: Fri Aug  2 07:13:33 2013 Errors in file /u01/oracle/admin/eptdb/...

ORA-00600: internal error code, arguments: [15764] 引起的宕机及处理过程

事情經過: 1.      2011-09-06下午17:25為了提供三廠packing速度, 徐鳴為askey runcard表添加 Wo key 和carton no的聯合索引 創建方式為onl...

ora-00257问题处理.doc

  • 2012年03月27日 15:33
  • 78KB
  • 下载

关于oracle中ora-00600的报错

今天起,打算把工作中遇到的各种问题和解决方法记录下来,会比较啰嗦,初学所以尽量详细,会写下思考过程,方便自己回忆和分享给需要的人。 一、问题描述:        在处理金投4.0数据线对接测试中发生错...

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

记录一下ora-00600[17182]的bug 环境:SunOS 64bit 10.2.0.4.0 RAC alter记录Fri Aug 24 17:55:21 2012 Errors in f...
  • deanza
  • deanza
  • 2012年08月25日 11:13
  • 1478

ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], []

今天建库的时候忽然报错ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], ...

DBCA+ASM遭遇ORA-00600 [kfioTranslateIO03]

在一台AIX+ASM但实例环境上使用DBCA创建数据库时,遭遇了ORA-00600 [kfioTranslateIO03]的错误。 alert 告警日志内容如下: NOTE: Loaded lib...
  • mrluoe
  • mrluoe
  • 2012年02月15日 21:18
  • 1265
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:ORA-00600 [3020] ORA-10560问题处理
举报原因:
原因补充:

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