Error in Oracle 11g Dataguard installation

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