• 12c DG broker DMON自动重启过程分析


    一、知识点
    1.强烈建议大家管理dataguard使用broker。
    2.broker的日志要知道在哪里,会看日志是学习的第一步。
    3.体系结构需要看官方文档。

    二、测试过程

    1.查看DMON进程
    <roidb02:orcldg:/u01/app/oracle/diag/rdbms/orcldg/orcldg/trace>$ps -ef|grep dmon
    oracle   16045     1  0 15:49 ?        00:00:00 ora_dmon_orcldg
    oracle   16873 15880  0 15:52 pts/0    00:00:00 grep --color=auto dmon
    2.kill DMON进程
    <roidb02:orcldg:/u01/app/oracle/diag/rdbms/orcldg/orcldg/trace>$kill 16045
    <roidb02:orcldg:/u01/app/oracle/diag/rdbms/orcldg/orcldg/trace>$
    3.查看broker日志
    <roidb02:orcldg:/u01/app/oracle/diag/rdbms/orcldg/orcldg/trace>$tail -f drc*.log
    2017-12-18 15:49:36.224                      SQL [ALTER SYSTEM REGISTER] Executed successfully
    12/18/2017 15:49:36
    Broker Configuration:       "dg_config"
          Protection Mode:            Maximum Performance
          Fast-Start Failover (FSFO): Disabled, flags=0x0, version=0
          Primary Database:           orcl (0x01010000)
    12/18/2017 15:49:40
    orcldg version check successfully completed
    Broker configuration file is current on orcldg, completing initialization
    Creating process RSM0  --正常状态
    12/18/2017 15:53:13
    RSM0 terminating since Data Guard Broker Monitor Process (DMON) is not running
    12/18/2017 15:53:39
    No DMON process running, NetSlave exiting... --进程被KILL的日志
    12/18/2017 15:53:53
    PMON Deregistering service orcldg_DGB with listener(s)
    2017-12-18 15:53:54.951                      PMON: >> Broker cleanup complete <<
    2017-12-18 15:53:54.951                      Restart Data Guard Broker Process, DMON
    2017-12-18 15:53:54.951                      PMON: Creating Data Guard Broker Monitor Process (DMON)
    2017-12-18 15:53:57.147                      drcx: DMON is not yet available for PROBE.
    2017-12-18 15:53:57.964                      >> Starting Data Guard Broker bootstrap <<  --自动重启dmon
    2017-12-18 15:53:57.964                      Broker Configuration File Locations:
    2017-12-18 15:53:57.964                            dg_broker_config_file1 = "+DATADG/orcldg/dr1.dat"   --配置文件路径
    2017-12-18 15:53:57.964                            dg_broker_config_file2 = "+DATADG/orcldg/dr2.dat"   --配置文件路径
    2017-12-18 15:53:57.964                      DMON: Attach state object
    2017-12-18 15:53:57.964                      DMON: rfafoGetLocks reinitializing dubious PMYSHUT lock value block contents: sts=0, flags=0x0, spare1=0x0, spare2=0x0, cksm=0x0, rndm=0x0
    2017-12-18 15:53:57.965                      DMON: Broker state reconciled, version = 0, state = 00000000
    2017-12-18 15:53:57.965                      DMON: Broker State Initialized  --初始化
    2017-12-18 15:53:57.965                            Version = 1
    2017-12-18 15:53:57.965                            State = 00000000
    2017-12-18 15:53:57.965                      DMON: Entered rfm_get_chief_lock() for CTL_BOOTSTRAP, reason 2
    2017-12-18 15:53:57.965 7fffffff           0 DMON: Entered rfm_get_chief_lock() for CTL_BOOTSTRAP, reason 0
    2017-12-18 15:53:58.980 7fffffff           0 DMON: start task execution: broker initialization
    2017-12-18 15:53:58.980                      DMON: Boot configuration (0.0.0), loading from "+DATADG/orcldg/dr2.dat"
    2017-12-18 15:53:58.996                      DMON Registering service orcldg_DGB with listener(s)
    2017-12-18 15:53:58.996                      DMON: Executing SQL [ALTER SYSTEM REGISTER]
    2017-12-18 15:53:58.996                      SQL [ALTER SYSTEM REGISTER] Executed successfully
    12/18/2017 15:53:59
    Broker Configuration:       "dg_config"
          Protection Mode:            Maximum Performance
          Fast-Start Failover (FSFO): Disabled, flags=0x0, version=0
          Primary Database:           orcl (0x01010000)
    12/18/2017 15:54:02
    orcldg version check successfully completed
    Broker configuration file is current on orcldg, completing initialization
    Creating process RSM0

    整个进程自动重启的时间不超过1分钟,自动完成。










    本文转自 roidba 51CTO博客,原文链接:http://blog.51cto.com/roidba/2052248,如需转载请自行联系原作者

  • 相关阅读:
    Docker搭建NSQ实时分布式消息集群
    雪花算法
    代码抽象三原则
    PostgreSQL12-主从复制
    logrus日志框架
    Golang中的布隆过滤器
    golang-Json编码解码
    List分组迭代器
    redis-cli命令行远程连接redis服务
    pycharm常用快捷键与设置
  • 原文地址:https://www.cnblogs.com/twodog/p/12138618.html
Copyright © 2020-2023  润新知