IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    RFS[22349]: Database mount ID mismatch

    惜分飞发表于 2023-11-06 13:13:23
    love 0

    联系:手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

    标题: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)

    • mount数据库也可能有LOCAL=NO的进程
    • login trigger导致ORA-16191问题
    • ORA-10485: Real-Time Query cannot be enabled while applying migration redo.
    • 记录一次ARC1: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned解决
    • ORA-07217: sltln: environment variable cannot be evaluated.
    • sys用户密码含$ sqlplus登录数据库诡异事件分析
    • DATAGUARD中MAXIMUM AVAILABILITY+LGWR SYNC导致主库不能启动
    • ORACLE 12C Windows-Linux 部署DATAGURAD
    • Control file mount id mismatch!故障处理
    • 11G RAC TO 11G RAC ADG SWITCHOVER
    • ORA-01034 ORA-27101故障分析
    • Oracle 10.2.0.x升级到11.2.0.3


沪ICP备19023445号-2号
友情链接