ORA-19816, ORA-17502, ORA-15041, Error 19504 Leading to ORA-600 [1433], [60] Errors And Instance Termination By DBWR (Doc ID 1482047.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

You are seeing the following errors in your alertlog:

*************************************************************
ARC1: Error 19504 Creating archive log file to '+PFYD03_ARCHDG'
Errors in file /fydgl/u00/oracle/admin/pfyd03/diag/rdbms/pfyd03/pfyd03/trace/pfyd03_arc0_19977.trc:
ORA-19816: WARNING: Files may exist in db_recovery_file_dest that are not known to database.
ORA-17502: ksfdcre:4 Failed to create file +PFYD03_ARCHDG
ORA-15041: diskgroup "PFYD03_ARCHDG" space exhausted
*************************************************************
WARNING: A file of type ARCHIVED LOG may exist in
db_recovery_file_dest that is not known to the database.
Use the RMAN command CATALOG RECOVERY AREA to re-catalog
any such files. If files cannot be cataloged, then manually
delete them using OS command. This is most likely the
result of a crash during file creation.
*************************************************************

 

This eventually leads to:

ARC0: Error 19504 Creating archive log file to '+PFYD03_ARCHDG'
Tue Aug 07 20:47:20 2012
Errors in file /fydgl/u00/oracle/admin/pfyd03/diag/rdbms/pfyd03/pfyd03/trace/pfyd03_mmon_19595.trc  (incident=737868):
ORA-00600: internal error code, arguments: [1433], [60], [], [], [], [], [], [], [], [], [], []

(message repeats until instance termination)

ORA-00600: internal error code, arguments: [1433], [60], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
DBW2 (ospid: 19579): terminating the instance due to error 471

 

 

Review of the trace files reveals the following:

 

Forward Links:
[9ca6c4f98,9de2e56a8]msg 149, length 40
...
...
[9ca6e7ed0,9ca6b04a8]msg 149, length 40
...
...
[9ca6e8560,9ca6c4f98]msg 149, length 40
...
...
[9ca6c7860,9ca6e7ed0]msg 149, length 40
...
...
[9ca6d7b20,9ca6e8560]msg 149, length 40

[9ca6c4f98,9de2e56a8]msg 149, length 40
Dump of memory from 0x00000009CA6B04C0 to 0x00000009CA6B04E8
9CA6B04C0 00000009 D22E3B40 00000001 00001610  [......;@........]
9CA6B04D0 FFFFFFFF 00000000 00020000 00000000  [................]
9CA6B04E0 00000001 C8400000                    [.....@..]        
total seen = 2048

 
Where the message: 149 MMON 'recovery area alert action'

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms