A-A+

ADG日志不传送到备库一则

2013年08月04日 DG&RAC&OGG 暂无评论 阅读 2,220 次

晚上加班搞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.

随即就已经正常传归档了。

标签:

给我留言

Copyright © YallonKing 保留所有权利.   Theme  Ality

用户登录

分享到: