当前位置:  数据库>oracle

ORA-00600 [3020] ORA-10560问题解决办法

    来源: 互联网  发布时间:2017-06-25

    本文导语: 渠道一用户,断电后Oracle数据库无法启动,渠道技术人员做了一些恢复尝试,包括重建控制文件、介质恢复提示如下错误: Errors in filed:oraclediagrdbmsorclorcl1traceorcl1_pr0g_5100.trc (incident=259565): ORA-00600: internal error code, arguments:[3020], [...

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

Errors in filed:oraclediagrdbmsorclorcl1traceorcl1_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:ORADATAORCLSYSAUX01.DBF'
ORA-10560: block type 'FIRST LEVEL BITMAPBLOCK'
Incident details in:d:oraclediagrdbmsorclorcl1incidentincdir_259565orcl1_pr0g_5100_i259565.trc
Slave exiting with ORA-600 exception
Errors in file d:oraclediagrdbmsorclorcl1traceorcl1_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:ORADATAORCLSYSAUX01.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 times,  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 =
      and between block_id AND block_id + blocks - 1;


Replacing and 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. 


    
 
 

您可能感兴趣的文章:

  • oracle远程连接服务器出现 ORA-12170 TNS:连接超时 解决办法
  • 基于ORA-12170 TNS 连接超时解决办法详解
  • Linux 下数据库oracle出现ORA-27102错误的解决办法
  • oracle ORA-01114、ORA-27067错误解决方法
  • Orcle的package中访问其它Schema的表报错ORA-00942解决方法
  • NOSQL iis7站长之家
  • ORA-12514及ORA-28547错误解决方案
  • 安装oracle出现error:ora-01031:insufficient privilleges的解决
  • plsql连接oracle数据库报ora 12154错误解决方法
  • zilong28提问:Tomcat3.2报错内容是Error occurs when connecting DB: ORA-00020: maximum number of processes(59) exceeded 我应该如何解决,先谢了
  • ORA-28002 Oracle 11g存在密码过期问题解决方案
  • Oracle ORA-22908(NULL表值的参考)异常分析与解决方法
  • PHP连接Oracle错误ORA-24324服务句柄未初始化的解决方法
  • ORACLE出现错误1033和错误ORA-00600的解决方法
  • 如何解决ORA-01843与NLS_DATE_FORMAT问题
  •  
    本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术,将尽最大努力为读者提供更好的信息聚合和浏览方式。
    本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。












  • 相关文章推荐
  • 出现ORA-01401和ORA-01008错误?
  • Eclipse连接Oracle数据库的ORA-00604 ORA-12705错误
  • Oracle不能删除表 ORA-00604 ORA-01422 错误
  • 如何得到带有ora的行的下一行
  • 如何配置 linux 下 oracle 的 listener .ora 和
  • 浅析如何在tnsnames.ora中配置监听
  • [Oracle] 浅析令人抓狂的ORA-01555问题
  • aq.executeQuery: ORA-00020: maximum number of processes (59) exceeded
  • Oracle 数据库闪回功能设置出现ORA-19809和ORA-19804错误
  • ORA-00947:Not enough values (没有足够的值)的深入分析
  • solaris10 安装 ora9.2.0.1 时报错
  • 在UNIX下,我的ORA817该怎么样才可以自己启动呀?
  • 谁能帮忙解释一下: ORA-01000 : maximun open cursors exceeded
  • 关于Oracle游标的问题(ORA-01000: maximum open cursors exceeded)
  • 我在Linux7。3下面装了一个Oracle8i,但是现在启动不起来了,总是报错ORA-01031: insufficient privileges
  • oracle 11g导出数据时报ORA 1455错误的处理方法
  • oracle报错(ORA-00600)问题处理
  • 为什么我读取数据库时出现:ORA-00600: 内部错误代码,参数: [ttcgcshnd-1], [0], [],错误?
  • Oracle 10g之ORA-32004问题
  • 在客户端配置TNS测试报错ORA-12170:TNS:连接超时


  • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除!

    ©2012-2021,,E-mail:www_#163.com(请将#改为@)

    浙ICP备11055608号-3