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

Comments