RMAN backup encountered a ORA-600 Error

Source: Internet
Author: User
I have been normal backup last night encountered OR-600 error, the specific error is: RMAN-03002: failureofbackupcommandat1230201204: 00: 06

I have been normal backup last night encountered an OR-600 error, the specific error is: RMAN-03002: failure of backup command at 12/30/2012 04:00:06

It was normal that the backup encountered an OR-600 error last night. The specific error is:

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
It is estimated that it should have encountered a Bug, the use of ORA-600 Error Look-up Tool only to find the article [38888.1], but it does not help solve the problem. Use the RMAN ORA-600 525 keyword to find the relevant article [ID 262997.1]. IT is indeed a Bug that caused the error, and the Bug only exists in the IT life of the AIX system where RMAN backup encounters a ORA-600 error-Jet. It is also easy to solve the problem without patching. You only need to add the DISKRATIO parameter 0 to the backup.
The following is a detailed explanation of this Bug in this article [ID 262997.1 ]:
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:
Oracle Server-Enterprise Edition-Version: 9
AIX5L Based Systems (64-bit)
AIX 4.3 Based Systems (64-bit)
Checked for relevance on 09-might-2007
Symptoms
When running RMAN backup script you receive an error stack similar:

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

This article permanently updates the link address:

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.