« 人人都献出一点爱-生命与健康 | Blog首页 | 在新家体验网上冲浪 »
Oracle DataGuard Standby database ID mismatch错误
链接:https://www.eygle.com/archives/2008/03/oracle_dataguard_mismatch.html
故障现象:
Oracle 9208 DataGuard日志应用正常,但是在standby alter log文件里老是提示下面错误:
RFS: Possible network disconnect with primary database |
Metalink的解释:
Symptoms Standby alert log reports "RFS: Possible network disconnect with primary database" At the standby DB side I get this error every minute. Archive log transfer/apply works O.K. Cause The (error) message may be triggered by another database that has log_archive_dest_2 pointing to standby instance of (error) message . RFS process tries to communicate with the instance. Solution Check if you have DB with mismatched ID and its log_archive_dest_X parameter value. From the error message of "Standby database ID mismatch [0xAAAA:0xBBBBB]" Convert the hex number of first argument, 0xAAAA to decimal value using calculator Then search db with the dbid.
|
按照上述说明,果然在primary database所在主机上,找到了另外一个实例,其参数log_archive_dest_2的设置也是:
log_archive_dest_2 string SERVICE=standby
将log_archive_dest_2参数defer后,即可解决问题。
关于log_archive_dest_n参数的设置说明:
(
说明: 指定相应的归档日志目标参数 (仅 LOG_ARCHIVE_DEST_3) 的可用性状态。如果启用,
日志目标将被归档。如果延迟, 该目标将被排除在归档操作之外直至重新启用。
值范围: ENABLE | DEFER
)
历史上的今天...
>> 2012-03-07文章:
>> 2011-03-07文章:
>> 2010-03-07文章:
>> 2009-03-07文章:
>> 2007-03-07文章:
>> 2005-03-07文章:
By eygle on 2008-03-07 22:58 | Comments (0) | Case | 2703 |