Today we are going to have a look on the steps which are used by DBA’s to resolve issue “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 2018

alter database activate standby database

ALTER DATABASE ACTIVATE [PHYSICAL] STANDBY DATABASE (testdb3)

Begin: Standby Redo Logfile archival

Tue May 30 13:52:13 2018

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 this 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/testdb4/archive_logs valid_for=(online_logfile, all_roles)

Solution :

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

System altered.

Please check Oracle Support Doc ID 2074686.1 for more information.

Thank you for giving your valuable time.

Thought of the  day !
Get up in the morning and invite good things into your life – Joel Osteen

Thank you for giving your valuable time to read the above information.

For More Detail , You can join us follow:

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.