Archiving Fails Reporting ORA-19504 and ORA-16014 (Doc ID 228367.1)

Last updated on SEPTEMBER 20, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 7.0.16.0 to 10.2.0.2 [Release 7.0 to 10.2]
HP OpenVMS Alpha

Symptoms


Checked for relevance on 22-Feb-2013.

Archiving stops working.  The alert log shows the following:

4-FEB-2003 23:43:02.34:
ARC0: Error 19504 creating archivelog file '$1$DGA4:[TEST.ARCH]ARCH0001_91595.ARC'
ARC0: Archiving not possible: error count exceeded
ARC0: Failed to archive log# 1 seq# 91595
ARCH: Archival stopped, error occurred. Will continue retrying

4-FEB-2003 23:43:02.49:
ORACLE Instance TEST - Archival Error

4-FEB-2003 23:43:02.54:
ORA-16014: log 1 sequence# 91595 not archived, no available destinations
ORA-00312: online log 1 thread 1: 'ORA_TEST:[TEST.DB_FILES]ORA_LOG1.RDO'
ARCH:
ORA-16014: log 1 sequence# 91595 not archived, no available destinations
ORA-00312: online log 1 thread 1: 'ORA_TEST:[TEST.DB_FILES]ORA_LOG1.RDO'


You may also encounter the error:  ORA-16020 less destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST


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