一、知識(shí)點(diǎn)
1.強(qiáng)烈建議大家管理dataguard使用broker。
2.broker的日志要知道在哪里,會(huì)看日志是學(xué)習(xí)的第一步。
3.體系結(jié)構(gòu)需要看官方文檔。
二、測(cè)試過(guò)程
1.查看DMON進(jìn)程
$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進(jìn)程
$kill 16045
$
3.查看broker日志
$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 --正常狀態(tài)
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... --進(jìn)程被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 << --自動(dòng)重啟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
整個(gè)進(jìn)程自動(dòng)重啟的時(shí)間不超過(guò)1分鐘,自動(dòng)完成。
另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn,海內(nèi)外云服務(wù)器15元起步,三天無(wú)理由+7*72小時(shí)售后在線,公司持有idc許可證,提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國(guó)服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案,具有“安全穩(wěn)定、簡(jiǎn)單易用、服務(wù)可用性高、性價(jià)比高”等特點(diǎn)與優(yōu)勢(shì),專為企業(yè)上云打造定制,能夠滿足用戶豐富、多元化的應(yīng)用場(chǎng)景需求。