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 APRIL 06, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterInformation 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 '+<filename>'
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_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 +<filename>
ORA-15041: diskgroup "<diskgroup_name>" 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 '+<filename>'
Tue Aug 07 20:47:20 2012
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_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:
[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'
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |