dataguard更改数据保护模式后无法同步

云裴

2台服务器做好dataguard后，默认是最大性能。
alter system switch logfile;反复多次后用select max(sequence#) from v$archived_log;查看结果是一致的。
我用下面方法把数据保护模式设置为最高可用性后却不同步了

1. SQL> alter system set log_archive_dest_2='SERVICE=standby OPTIONAL LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby';
   
2. SQL> alter database set standby database to maximize availability;
   
3. SQL> shutdown immediate
   
4. SQL> startup
   
5. SQL> select protection_level,protection_mode  from v$database;
   
6. PROTECTION_LEVEL     PROTECTION_MODE
   
7. --------------------              --------------------
   
8. RESYNCHRONIZATION    MAXIMUM AVAILABILITY

复制代码

PROTECTION_LEVEL的值为RESYNCHRONIZATION。
alter system switch logfile后用select max(sequence#) from v$archived_log;查看结果不一致了。

ps：这时在standby主机alter database recover managed standby database cancel;再alter database recover managed standby database disconnect from session;后直接用select max(sequence#) from v$archived_log查看结果和primary主机结果一致。可是alter system switch logfile后又不一致。

云裴

tail alert_szdb.log
ORA-16086: standby database does not contain available standby log files
Tue Oct 11 22:21:26 CST 2011
Destination LOG_ARCHIVE_DEST_2 is UNSYNCHRONIZED
LGWR: Failed to archive log 2 thread 1 sequence 183 (16086)
Tue Oct 11 22:21:30 CST 2011
Thread 1 advanced to log sequence 183 (LGWR switch)
  Current log# 2 seq# 183 mem# 0: /oracle/oradata/szdb/redo02.log
LNSb started with pid=15, OS id=4241
Tue Oct 11 22:27:21 CST 2011
Destination LOG_ARCHIVE_DEST_2 is SYNCHRONIZED

chen31577

同问，遇到同样问题，mark