ORA-16014: log # sequence# ### not archived, no available destinations (Standby Database)

Problem:

Following error in standby alert log:

ARCH: Archival stopped, error occurred. Will continue retrying

ORACLE Instance STDB4_DG - Archival Error

ORA-16014: log 7 sequence# 234 not archived, no available destinations

Solution:

For such error first we will check the following things:

1. Archival mount point/Disk group is inaccessible or

2. Mount point/Disk group space is full

In my case neither of above was the cause. In my standby database following destination was set:

Parameter

log_archive_dest_1

log_archive_dest_3

Value

LOCATION=/holding/stdb4_dg/archive_logs valid_for=(online_logfile, all_roles)

service="stdb3_dg", LGWR ASYNCNOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 net_timeout=30 db_unique_name="stdb3_dg", valid_for=(all_logfiles,primary_role)

So the problem was there was not archive log destination set for Physical standby server. After setup the archive destination for standby role the problem fixed.

alter system set log_archive_dest_2='LOCATION=/holding/stdb4_dg/standby_logs valid_for=(standby_logfile, standby_role)' scope=both;