当前位置:  数据库>oracle

RMAN备份遭遇ORA-600错误

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

    本文导语: 本来一直都很正常的备份昨晚遭遇了OR-600的错误,具体错误为: RMAN-03002: failure of backup command at 12/30/2012 04:00:06 ORA-00600: internal error code, arguments: [525], [0x70000020661E7D8], [5], [library cache], [30], [0x700000000025BF0], [device information], [] ORA-27041...

本来一直都很正常的备份昨晚遭遇了OR-600的错误,具体错误为:

RMAN-03002: failure of backup command at 12/30/2012 04:00:06

ORA-00600: internal error code, arguments: [525], [0x70000020661E7D8], [5], [library cache], [30], [0x700000000025BF0], [device information], []

ORA-27041: unable to open file

IBM AIX RISC System/6000 Error: 25: Not a typewriter

Additional information: 16
估计应该是碰到Bug了,使用ORA-600 Error Look-up Tool只找到文章[38888.1],但对问题解决没什么大的帮助。使用RMAN ORA-600 525关键字才找到相关的文章[ID 262997.1]。确实是Bug导致了该错误,而且该Bug只存在于AIX系统上RMAN备份遭遇ORA-600错误 - Jet - Jet的IT人生。还好在不打补丁的情况解决该问题也还算简单,只要在备份中加上参数DISKRATIO=0即可解决。
以下是该文章[ID 262997.1]对该Bug的具体解释
ORA-600 [525] / [510] and ORA-27041 When Running RMAN Backup On IBM AIX Platform [ID 262997.1]
 
In this Document
  Symptoms
  Cause
  Solution
  References


Applies to:
 Oracle Server - Enterprise Edition - Version: 9
 AIX5L Based Systems (64-bit)
 AIX 4.3 Based Systems (64-bit)
 Checked for relevance on 09-May-2007
Symptoms
 When running RMAN backup script you receive an error stack similar to:

 RMAN> backup tablespace users;
 RMAN-00571: ===========================================================
 RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 RMAN-00571: ===========================================================
 RMAN-03002: failure of backup command at 02/10/2004 14:26:27
 ORA-00600: internal error code, arguments: [525], [0x70000008093B068], [5],
 [library cache], [1], [0x700000000025B30], [device information], []
 ORA-27041: unable to open file
 IBM AIX RISC System/6000 Error: 25: Not a typewriter
 Additional information: 16

 In the trace file generated by the ORA-600, the current SQL statement is:

 select device ,node from x$krbaff where fno=:b1
Cause
 This problem is specific to the AIX platform and is suspected to be related to the node affinity interface. No solution in terms of a code fix exists.
Solution
 Workaround: Use the DISKRATIO=0 option on the backup command, eg.:

 RMAN> backup tablespace users diskratio=0;
References
BUG:2181764 - ORA-00600 [KSFDDLI3] EXECUTING BACKUP COMMAND ON RMAN


    
 
 
 
本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术,将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。












  • 相关文章推荐
  • rman配置及rman常用命令操作
  • Oracle相关:Rman Crosscheck删除失效归档
  • rman恢复方案和oracle异机恢复
  • Oracle RMAN快速入门指南


  • 站内导航:


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

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

    浙ICP备11055608号-3