all_roles) db_unique_name=cheng [oracle@dg2 dbs]$ ，all_roles) db_unique_name=cheng [oracle@dg2 dbs]$ 2.主库节点(primary)没有权限往log_archive_dest_1写入 ARCH: Archival stopped，归档文件没有同步 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 解决方法: [oracle@dg2 dbs]$ vim initcheng.ora --添加归档文件的存放路径(primary和standby节点) IT之家.log_archive_dest_1=LOCATION=/u01/oradata/tong/archivevalid_for=(all_logfiles， 1.没有设置log_archive_dest_1参数。

no available destinations ORA-00312: online log 4 thread 1: /u01/oradata/tong/sredo04.log 解决方法: [oracle@dg2 dbs]$ vim initcheng.ora --primary和standby都修改 IT之家.log_archive_dest_1=LOCATION=/u01/oradata/tong/archive valid_for=(all_logfiles， error occurred. Will continue retrying ORACLE Instance cheng - Archival Error ORA-16014: log 4 sequence# 26 not archived，all_roles) db_unique_name=cheng IT之家.log_archive_dest_2=service=cheng LGWR SYNC AFFIRM valid_for=(online_logfiles， 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# 26 not archived，。