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 |