• 欢迎访问搞代码网站,推荐使用最新版火狐浏览器和Chrome浏览器访问本网站!
  • 如果您觉得本站非常有看点,那么赶紧使用Ctrl+D 收藏搞代码吧

RMAN备份遭遇ORA-600错误

mysql 搞代码 4年前 (2022-01-09) 20次浏览 已收录 0个评论

本来一直都很正常的备份昨晚遭遇了OR-600的错误,具体错误为:RMAN-03002: failure of backup command at 12/30/2012 04:00:06

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

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

ORA-00600: in来1源gaodai#ma#com搞*代#码1网ternal 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

本文永久更新链接地址


搞代码网(gaodaima.com)提供的所有资源部分来自互联网,如果有侵犯您的版权或其他权益,请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected],我们会在看到邮件的第一时间内为您处理,或直接联系QQ:872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接:RMAN备份遭遇ORA-600错误

喜欢 (0)
[搞代码]
分享 (0)
发表我的评论
取消评论

表情 贴图 加粗 删除线 居中 斜体 签到

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址