文章详情

短信预约-IT技能 免费直播动态提醒

请输入下面的图形验证码

提交验证

短信预约提醒成功

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

2024-04-02 19:55

关注

一、知识点
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分钟,自动完成。

阅读原文内容投诉

免责声明:

① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的,并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据,供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。

② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341

软考中级精品资料免费领

  • 历年真题答案解析
  • 备考技巧名师总结
  • 高频考点精准押题
  • 2024年上半年信息系统项目管理师第二批次真题及答案解析(完整版)

    难度     813人已做
    查看
  • 【考后总结】2024年5月26日信息系统项目管理师第2批次考情分析

    难度     354人已做
    查看
  • 【考后总结】2024年5月25日信息系统项目管理师第1批次考情分析

    难度     318人已做
    查看
  • 2024年上半年软考高项第一、二批次真题考点汇总(完整版)

    难度     435人已做
    查看
  • 2024年上半年系统架构设计师考试综合知识真题

    难度     224人已做
    查看

相关文章

发现更多好内容

猜你喜欢

AI推送时光机
位置:首页-资讯-数据库
咦!没有更多了?去看看其它编程学习网 内容吧
首页课程
资料下载
问答资讯