eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

« 人人都献出一点爱-生命与健康 | Blog首页 | 在新家体验网上冲浪 »

Oracle DataGuard Standby database ID mismatch错误

故障现象:

Oracle 9208 DataGuard日志应用正常,但是在standby alter log文件里老是提示下面错误:

 

RFS: Possible network disconnect with primary database
standby database ID mismatch [0x99bb1983:0x8d17262b]

 

Metalink的解释:

Symptoms

Standby alert log reports "RFS: Possible network disconnect with primary database"

At the standby DB side I get this error every minute.
RFS: Possible network disconnect with primary database
Standby database ID mismatch [0xAAAA:0xBBBBB]

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.
If found one but not in primary/standby config, disable log_archive_dest_2 to the instance, ie

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.
SQL> select dbid from v$database;

SQL> alter system set log_archive_dest_2_state=defer;

 

 

 

按照上述说明,果然在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 |


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com