未配置standby_log
SQL> select count(*) from v$standby_log;
COUNT(*)
----------
0
初始配置
alter system set log_archive_dest_2='SERVICE=ora10g lgwr sync VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ora10g' scope=both;
alter system set log_archive_dest_2='SERVICE=orcllgwr sync VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl' scope=both;
检查是否正确配置
select dest_name,status,error from v$archive_dest where dest_id in (1,2);
提示dest_name=2 no valid type
修改配置
alter system set log_archive_dest_2='SERVICE=ora10g lgwr sync affirm DB_UNIQUE_NAME=ora10g' scope=both;
alter system set log_archive_dest_2='SERVICE=orcllgwr sync affirm DB_UNIQUE_NAME=orcl' scope=both;
再检查select dest_name,status,error from v$archive_dest where dest_id in (1,2);都ok