在主库上查询
v$ARCHIVE_DEST视图
set line 200
col DEST_NAME for a50
col BINDING for a10
SQL> select DEST_ID,DEST_NAME,STATUS,BINDING,ERROR from v$ARCHIVE_DEST where status<>'INACTIVE'
2 /
DEST_ID DEST_NAME STATUS BINDING ERROR
---------- -------------------------------------------------- --------- ---------- -----------------------------------------------------------------
1 LOG_ARCHIVE_DEST_1 VALID OPTIONAL
2 LOG_ARCHIVE_DEST_2 DISABLED OPTIONAL ORA-16047: DGID mismatch between destination setting and target
database
set line 200
col DEST_NAME for a50
col BINDING for a10
SQL> select DEST_ID,DEST_NAME,STATUS,BINDING,ERROR from v$ARCHIVE_DEST where status<>'INACTIVE'
2 /
DEST_ID DEST_NAME STATUS BINDING ERROR
---------- -------------------------------------------------- --------- ---------- -----------------------------------------------------------------
1 LOG_ARCHIVE_DEST_1 VALID OPTIONAL
2 LOG_ARCHIVE_DEST_2 DISABLED OPTIONAL ORA-16047: DGID mismatch between destination setting and target
database
主库上alert 上如下
PING[ARC1]: Heartbeat failed to connect to standby 'racdg'. Error is 16047.
Fri Sep 05 17:05:24 2014
PING[ARC1]: Heartbeat failed to connect to standby 'racdg'. Error is 16047.
Fri Sep 05 17:06:29 2014
PING[ARC1]: Heartbeat failed to connect to standby 'racdg'. Error is 16047.
Fri Sep 05 17:07:41 2014
PING[ARC1]: Heartbeat failed to connect to standby 'racdg'. Error is 16047.
Fri Sep 05 17:08:45 2014
经过网上搜索大部分原因都是 主备库 如下参数设置不当
PING[ARC1]: Heartbeat failed to connect to standby 'racdg'. Error is 16047.
Fri Sep 05 17:05:24 2014
PING[ARC1]: Heartbeat failed to connect to standby 'racdg'. Error is 16047.
Fri Sep 05 17:06:29 2014
PING[ARC1]: Heartbeat failed to connect to standby 'racdg'. Error is 16047.
Fri Sep 05 17:07:41 2014
PING[ARC1]: Heartbeat failed to connect to standby 'racdg'. Error is 16047.
Fri Sep 05 17:08:45 2014
经过网上搜索大部分原因都是 主备库 如下参数设置不当
log_archive_config
fal_client
fal_server
log_archive_dest_2
尤其检查log_archive_dest_2 参数是否正确,在这里我的原因应该是这个参数大小写有问题,我自己重新写了一下再次查询视图
SQL> select DEST_ID,DEST_NAME,STATUS,BINDING,ERROR from v$ARCHIVE_DEST where status<>'INACTIVE';
DEST_ID DEST_NAME STATUS BINDING ERROR
---------- -------------------------------------------------- --------- ---------- -----------------------------------------------------------------
1 LOG_ARCHIVE_DEST_1 VALID OPTIONAL
2 LOG_ARCHIVE_DEST_2 DEFERRED OPTIONAL
这个状态的意思是认为手动disbale掉,我重启了一下主库发下可以正常饮用redo到备库了。
再次查询
SQL> set line 200
SQL> col DEST_NAME for a50
SQL> col BINDING for a10
SQL> select DEST_ID,DEST_NAME,STATUS,BINDING,ERROR from v$ARCHIVE_DEST where status<>'INACTIVE';
DEST_ID DEST_NAME STATUS BINDING ERROR
---------- -------------------------------------------------- --------- ---------- -----------------------------------------------------------------
1 LOG_ARCHIVE_DEST_1 VALID OPTIONAL
2 LOG_ARCHIVE_DEST_2 VALID OPTIONAL
正常。
fal_client
fal_server
log_archive_dest_2
尤其检查log_archive_dest_2 参数是否正确,在这里我的原因应该是这个参数大小写有问题,我自己重新写了一下再次查询视图
SQL> select DEST_ID,DEST_NAME,STATUS,BINDING,ERROR from v$ARCHIVE_DEST where status<>'INACTIVE';
DEST_ID DEST_NAME STATUS BINDING ERROR
---------- -------------------------------------------------- --------- ---------- -----------------------------------------------------------------
1 LOG_ARCHIVE_DEST_1 VALID OPTIONAL
2 LOG_ARCHIVE_DEST_2 DEFERRED OPTIONAL
这个状态的意思是认为手动disbale掉,我重启了一下主库发下可以正常饮用redo到备库了。
再次查询
SQL> set line 200
SQL> col DEST_NAME for a50
SQL> col BINDING for a10
SQL> select DEST_ID,DEST_NAME,STATUS,BINDING,ERROR from v$ARCHIVE_DEST where status<>'INACTIVE';
DEST_ID DEST_NAME STATUS BINDING ERROR
---------- -------------------------------------------------- --------- ---------- -----------------------------------------------------------------
1 LOG_ARCHIVE_DEST_1 VALID OPTIONAL
2 LOG_ARCHIVE_DEST_2 VALID OPTIONAL
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26175573/viewspace-1265027/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26175573/viewspace-1265027/