1. log_archive_dest_1 parameter not set, archive file is not synchronized
Mon Nov 07 17:39:12 2016
Using standby_archive_dest parameter default value as Use_db_recovery_file_dest
Mon Nov 07 17:40:12 2016
Using standby_archive_dest parameter default value as Use_db_recovery_file_dest
Mon Nov 07 17:41:12 2016
Using standby_archive_dest parameter default value as Use_db_recovery_file_dest
Mon Nov 07 17:42:12 2016
Using standby_archive_dest parameter default value as Use_db_recovery_file_dest
Mon Nov 07 17:43:12 2016
Using standby_archive_dest parameter default value as Use_db_recovery_file_dest
Mon Nov 07 17:44:12 2016
Using standby_archive_dest parameter default value as Use_db_recovery_file_dest
Mon Nov 07 17:45:12 2016
Using standby_archive_dest parameter default value as Use_db_recovery_file_dest
Mon Nov 07 17:46:12 2016
Using standby_archive_dest parameter default value as Use_db_recovery_file_dest
Workaround:
[[email protected] dbs]$ Vim Initcheng.ora--Add archive path (primary and Standby nodes)
*.log_archive_dest_1= ' location=/u01/oradata/tong/archive valid_for= (all_logfiles,all_roles) db_unique_ Name=cheng '
[Email protected] dbs]$
2. The main library node (primary) does not have permission to write to Log_archive_dest_1
Arch:archival stopped, error occurred. would continue retrying
ORACLE Instance Cheng-archival Error
Ora-16014:log 4 sequence# not archived, no available destinations
Ora-00312:online Log 4 Thread 1: '/u01/oradata/tong/sredo04.log '
Errors in FILE/U01/DIAG/RDBMS/CHENG/CHENG/TRACE/CHENG_ARC1_6272.TRC:
Ora-16014:log 4 sequence# not archived, no available destinations
Ora-00312:online Log 4 Thread 1: '/u01/oradata/tong/sredo04.log '
Workaround:
[[email protected] dbs]$ vim Initcheng.ora--primary and Standby all modified
*.log_archive_dest_1= ' location=/u01/oradata/tong/archive valid_for= (all_logfiles,all_roles) db_unique_ Name=cheng '
*.log_archive_dest_2= ' Service=cheng lgwr SYNC affirm valid_for= (online_logfiles,all_roles) db_unique_name= Cheng
[Email protected] dbs]$
This article is from the "Days Together" blog, please be sure to keep this source http://tongcheng.blog.51cto.com/6214144/1870619
Error in Oracle 11g Dataguard installation