RMAN備份遭遇ORA-600錯(cuò)誤

本來一直都很正常的備份昨晚遭遇了OR-600的錯(cuò)誤，具體錯(cuò)誤為：RMAN-03002: failure of backup command at 12/30/2012 04:00:06

本來一直都很正常的備份昨晚遭遇了OR-600的錯(cuò)誤，具體錯(cuò)誤為：

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
估計(jì)應(yīng)該是碰到Bug了，，使用ORA-600 Error Look-up Tool只找到文章[38888.1]，但對問題解決沒什么大的幫助。使用RMAN ORA-600 525關(guān)鍵字才找到相關(guān)的文章[ID 262997.1]。確實(shí)是Bug導(dǎo)致了該錯(cuò)誤，而且該Bug只存在于AIX系統(tǒng)上RMAN備份遭遇ORA-600錯(cuò)誤 - Jet - Jet的IT人生。還好在不打補(bǔ)丁的情況解決該問題也還算簡單，只要在備份中加上參數(shù)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

本文永久更新鏈接地址：

聲明：本網(wǎng)頁內(nèi)容旨在傳播知識，若有侵權(quán)等問題請及時(shí)與本網(wǎng)聯(lián)系，我們將在第一時(shí)間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com