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

Problem:

In the alert log file

Tue May 30 13:48:49 2017

alter database activate standby database

ALTER DATABASE ACTIVATE [PHYSICAL] STANDBY DATABASE (testdb3)

Begin: Standby Redo Logfile archival

Tue May 30 13:52:13 2017

ARCH: Archival stopped, error occurred. Will continue retrying

ORACLE Instance testdb3 - Archival Error

ORA-16014: log 4 sequence# 558 not archived, no available destinations

ORA-00312: online log 4 thread 1: '+DATA/testdb3/onlinelog/group_4.266.944679837'

Archiver process freed from errors. No longer stopped

Cause :

In my case the problem was log_archive_dest_2 was set incorrectly.

SQL> show parameter log_archive_dest_1;

NAME TYPE VALUE

------------------------------------ --------------------------------- ------------------------------

log_archive_dest_1 string LOCATION=/holding/testdb3/archive_logs

valid_for=(online_logfile, all_roles)

Solution :

SQL> ALTER SYSTEM SET log_archive_dest_1='LOCATION=/holding/testdb3/archive_logs valid_for=(all_logfiles,all_roles)' scope=both;

System altered.

For more information please check Oracle Support Doc ID 2074686.1