ORA-16038, ORA-19504, ORA-16014 And ORA-00312 Errors

This last night has appeared the following error in a alert.log file.

Thu Oct 15 03:18:38 2015
ARC0: Error 19504 Creating archive log file to '+SAPPRD_ARCSAPPRD2_DG'
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance SAP02 - Archival Error
ORA-16038: log 5 sequence# 20105 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 5 thread 2: '+SAPPRD_DG/SAPprd/onlinelog/group_5.266.811070321'
Thu Oct 15 03:18:38 2015
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance SAP02 - Archival Error
ORA-16014: log 5 sequence# 20105 not archived, no available destinations
ORA-00312: online log 5 thread 2: '+SAPPRD_DG/SAPprd/onlinelog/group_5.266.811070321'
Thu Oct 15 03:18:53 2015
Thread 2 advanced to log sequence 20107 (LGWR switch)
  Current log# 4 seq# 20107 mem# 0: +SAPPRD_DG/SAPprd/onlinelog/group_4.265.811070317
Thu Oct 15 03:18:53 2015

The problem seems to be that failed to access to the ASM, as has regained access to it has solved the problem.

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s