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