晚上加班搞3个库的同城灾备的ADG，一个库的参数全部配好了，就是不传日志，各种检查，就是没有找到问题。后来把归档的DEST换了下就OK了，很是奇怪，记录于此。
库的版本是x64 linux 11g的基础版本，也可能和BUG有关吧...
首先在主库查看问题：
| SQL> select status,error from v$archive_dest;
STATUS ERROR
--------- -----------------------------------------------------------------
VALID
VALID
DISABLED ORA-16057: server not in Data Guard configuration
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
STATUS ERROR
--------- -----------------------------------------------------------------
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
STATUS ERROR
--------- -----------------------------------------------------------------
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
31 rows selected. |
从上边可以看出，问题很明显，说我的配置有问题，我反复检查了主备库的参数，均无异。
于是便尝试了各种办法，遂试到了下边的方法：
在主库替换归档目的地
| SQL> alter system set LOG_ARCHIVE_DEST_3='';
System altered.
SQL> alter system set log_archive_dest_4='SERVICE=bocras2 ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=bocras2';
System altered.
SQL> alter system switch logfile;
System altered.
SQL> select status,error from v$archive_dest;
STATUS ERROR
--------- -----------------------------------------------------------------
VALID
VALID
INACTIVE
VALID
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
STATUS ERROR
--------- -----------------------------------------------------------------
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
STATUS ERROR
--------- -----------------------------------------------------------------
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
INACTIVE
31 rows selected. |
随即就已经正常传归档了。
