ORA-16014: log 4 sequence# 16 not archived, no available destinations

搭建好DG，发现备库上报如下错误：

ORA-16014: log 4 sequence# 16 not archived, no available destinations ORA-00312: online log 4 thread 1: '/export/11g/oradata/orcl/redo04.log' Errors in file /export/11g/diag/rdbms/orcl2/orcl/trace/orcl_arc3_10932.trc: ORA-16014: log 4 sequence# 16 not archived, no available destinations ORA-00312: online log 4 thread 1: '/export/11g/oradata/orcl/redo04.log' Mon Nov 17 21:33:52 2014

找了好久找不到原因，对比生产库的配置，发现：

log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST valid_for=(all_logfiles,all_roles) db_unique_name=***'; ----生产库配置  log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST valid_for=(all_logfiles,primary_role) db_unique_name=orcl2'; ----我的配置

 

找到问题原因了，如果角色为standby_role，那么库就没有权限往log_archive_dest_1写东西了，所以就standby log就没法归档，改成all_roles，问题得到解决。