ORA-16009 remote archive log destination must be a STANDBY database

ORA-16009错误处理

问题描述:

主备在做Switchover切换时,在切换后的备库报如下错误:

Wed Jul 22 04:49:02 2015

Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_arc0_8755.trc:

ORA-16009: remote archive log destination must be a STANDBY database

解决办法:

查看主库log_archive_dest_2 参数,结果此参数为空

修改此参数即可

SQL> alter system set log_archive_dest_2='service=orcl db_unique_name=orcl' scope=both;

原文地址:https://www.cnblogs.com/liang545621/p/7529103.html