请教一个问题
dataguard 做switchover的时候报错
Mon Feb 09 17:03:37 2015
Errors in file /oracle/app/oracle/diag/rdbms/pdunq_dg/powerdes/trace/powerdes_arc2_23808.trc:
ORA-16047: DGID mismatch between destination setting and target database
PING[ARC2]: Heartbeat failed to connect to standby 'pdunq_dg'. Error is 16047.
但是我可以tnsping通pdunq_dg
[oracle@powerlong5 admin]$ tnsping pdunq_dg
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 09-FEB-2015 17:03:51
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.121.217)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = pdunq)))
OK (10 msec)
[oracle@powerlong5 admin]$
------解决思路----------------------
这个触发的可能性有点多，不好一一说明...
单就你说的连接这一点上，单是tnsping不够，用sqlplus xxx/xxx@pdunq_dg 看看能不能连上
------解决思路----------------------
Error:?? ORA-16047? (ORA-16047)
Text:??? DGID mismatch between destination setting and target database
---------------------------------------------------------------------------
Cause: The DB_UNIQUE_NAME specified for the destination did not match the DB_UNIQUE_NAME at the target database.
Action: Make sure the DB_UNIQUE_NAME specified in the LOG_ARCHIVE_DEST_n parameter matches the DB_UNIQUE_NAME parameter defined at the destination.
检查主库到备库配置的db_unique_name是否是正确的
------解决思路----------------------
主库上
show parameter LOG_ARCHIVE_DEST
查看到目标端的那个参数的配置的值
备库上
show parameter DB_UNIQUE_NAME
看看两边是否一致