联系：手机/微信(+86 17813235971) QQ(107644445)
标题：RFS[22349]: Database mount ID mismatch
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
今天检查数据库发现一套主库上面报大量RFS[22349]: Database mount ID mismatch之类的错误
[oracle@hisdb2 trace]$ tail -f alert_hisdb2.log LNS: Standby redo logfile selected for thread 2 sequence 133319 for destination LOG_ARCHIVE_DEST_2 Mon Nov 06 20:56:09 2023 RFS[27080]: Assigned to RFS process 15518 RFS[27080]: Database mount ID mismatch [0x7afb8c50:0x70b2cf7b] (2063305808:1890766715) Mon Nov 06 20:57:09 2023 RFS[27081]: Assigned to RFS process 16299 RFS[27081]: Database mount ID mismatch [0x7afb8c50:0x70b2cf7b] (2063305808:1890766715) Mon Nov 06 20:57:09 2023 RFS[27082]: Assigned to RFS process 16319 RFS[27082]: Database mount ID mismatch [0x7afb8c50:0x70b2cf7b] (2063305808:1890766715)
这种错误表示rfs进程在传输的时候检测到database mount id不匹配(也就是认为这个库不是主库该传输或者接受日志的),出现类似这样的错误,大概率是由于这个dg成员(主库和备库)中应该有不匹配的库,回想这个库近期的操作,突然想到对这个主库在虚拟化平台的备库做了一次克隆,然后吧克隆库激活作为测试库的操作.基于此种情况,先判断该库是否和上次克隆的库之间创建有会话连接
--主库 [oracle@hisdb2 trace]$ netstat -natp|grep 192.168.106.63 (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.) tcp 0 0 192.168.115.12:52785 192.168.106.63:1521 ESTABLISHED - tcp 0 0 192.168.115.14:1521 192.168.106.63:21598 TIME_WAIT - --克隆库 [oracle@HIS_DG ~]$ netstat -atpn|grep 192.168.115.12 (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.) tcp 0 0 ::ffff:192.168.106.63:1521 ::ffff:192.168.115.12:52785 ESTABLISHED 6126/oraclehisdb
两个库之间确实存在会话,检查克隆库相关的dg配置
[oracle@HIS_DG ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Nov 6 21:01:05 2023
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter fal;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fal_client string HISDBDG
fal_server string HISDB
SQL> select open_mode,database_role from v$database;
OPEN_MODE DATABASE_ROLE
-------------------- ----------------
READ WRITE PRIMARY
SQL> show parameter archive;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 1800
log_archive_config string
log_archive_dest string
log_archive_dest_1 string LOCATION=USE_DB_RECOVERY_FILE_
DEST valid_for=(all_logfiles,a
ll_roles) db_unique_name=hisdb
dg
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
log_archive_dest_2 string service=hisdb lgwr async valid
_for=(online_logfiles,primary_
role) db_unique_name=hisdb
该库的dg配置没有清除,当该库变为主库时,log_archive_dest_2刚好指向主库,从而使得主库上出现了类似RFS[22349]: Database mount ID mismatch的错误.处理方法是清除掉克隆库上面dg备库相关配置
SQL> alter system set log_archive_dest_2=''; System altered. SQL> alter system set fal_server=''; System altered.
主库日志中未再出现类似错误
Mon Nov 06 20:48:08 2023 RFS[22349]: Assigned to RFS process 7383 RFS[22349]: Database mount ID mismatch [0x7afb8c50:0x70b2cf7b] (2063305808:1890766715) [oracle@hisdb1 trace]$ tail -f alert_hisdb1.log RFS[22352]: Database mount ID mismatch [0x7afb8c50:0x70b2cf7b] (2063305808:1890766715) Mon Nov 06 20:58:09 2023 RFS[22353]: Assigned to RFS process 14958 RFS[22353]: Database mount ID mismatch [0x7afb8c50:0x70b2cf7b] (2063305808:1890766715) Mon Nov 06 21:01:09 2023 RFS[22354]: Assigned to RFS process 18580 RFS[22354]: Database mount ID mismatch [0x7afb8c50:0x70b2cf7b] (2063305808:1890766715) Mon Nov 06 21:01:09 2023 RFS[22355]: Assigned to RFS process 18598 RFS[22355]: Database mount ID mismatch [0x7afb8c50:0x70b2cf7b] (2063305808:1890766715) Mon Nov 06 21:03:28 2023 Thread 1 advanced to log sequence 129769 (LGWR switch) Current log# 9 seq# 129769 mem# 0: +DATA/hisdb/onlinelog/group_9.276.976991877 Current log# 9 seq# 129769 mem# 1: +FRA/hisdb/onlinelog/group_9.2334.976991877 Mon Nov 06 21:03:28 2023 Archived Log entry 524082 added for thread 1 sequence 129768 ID 0x70864b41 dest 1: Mon Nov 06 21:03:28 2023 LNS: Standby redo logfile selected for thread 1 sequence 129769 for destination LOG_ARCHIVE_DEST_2
事后在MOS上有一篇文档供参考:Database mount ID mismatch ORA-16009: invalid redo transport destination (Doc ID 1450132.1)
