目录
1、模拟主库(node1) DOWN机(环境 node1 为主库,node2 为备库)
2、模拟备库(node1) DOWN机(环境 node2 为主库,node1 为备库)
3、模拟主库node2数据库被kill(环境 node2 为主库,node1 为备库)
4、模拟备库node2数据库被kill(环境 node1 为主库,node2 为备库)
1、模拟主库(node1) DOWN机(环境 node1 为主库,node2 为备库)
对主库所在机器shutdown
从监视器处可以查看到RW1的状态由OPEN->ERROR ,RW2由open状态->STARTUP->MON CONFIRM->FAILOVER->OPEN
监视器log:
[monitor] 2022-03-25 05:46:22: Received message from(DMRW1)
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2022-03-25 05:46:22 OPEN OK DMRW1 OPEN STANDBY NULL 7 32545 32545
[monitor] 2022-03-25 05:46:23: Received message from(DMRW2)
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2022-03-25 05:46:23 OPEN OK DMRW2 OPEN PRIMARY VALID 7 32545 32545
[monitor] 2022-03-25 05:50:03: Received message timeout from(DMRW1)
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2022-03-25 05:49:52 ERROR OK DMRW1 OPEN STANDBY VALID 7 32545 32545
[monitor] 2022-03-25 05:52:32: Dmwatcher process DMRW2 status switching [OPEN-->STARTUP]
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2022-03-25 05:52:32 STARTUP OK DMRW2 SUSPEND PRIMARY VALID 7 32545 32548
[monitor] 2022-03-25 05:52:33: Dmwatcher process DMRW2 status switching [STARTUP-->MON CONFIRM]
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2022-03-25 05:52:33 MON CONFIRM OK DMRW2 SUSPEND PRIMARY VALID 7 32545 32548
[monitor] 2022-03-25 05:52:34: Dmwatcher process DMRW2 status switching [MON CONFIRM-->FAILOVER]
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2022-03-25 05:52:34 FAILOVER OK DMRW2 SUSPEND PRIMARY VALID 7 32545 32548
[monitor] 2022-03-25 05:52:37: Dmwatcher process DMRW2 status switching [FAILOVER-->OPEN]
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2022-03-25 05:52:37 OPEN OK DMRW2 OPEN PRIMARY VALID 7 32548 32548
node2上可正常提供服务
[dmdba@node2 ~]$ disql SYSDBA/SYSDBA
SQL> select * from sysdba.tab ;
no rows
used time: 18.963(ms). Execute id is 400.
SQL> insert into sysdba.tab values(10) ;
affect rows 1
used time: 0.303(ms). Execute id is 401.
SQL> commit ;
executed successfully
used time: 3.115(ms). Execute id is 402.
启动node1 所在的机器
node1 状态由NONE-->STARTUP-->OPEN
node2 状态OPEN-->RECOVERY-->OPEN
监视器log
[monitor] 2022-03-25 06:08:23: Dmwatcher process DMRW1 status switching [NONE-->STARTUP]
[monitor] 2022-03-25 06:08:24: Dmwatcher process DMRW1 status switching [STARTUP-->OPEN]
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2022-03-25 06:08:23 OPEN OK DMRW1 OPEN STANDBY INVALID 7 32545 32545
[monitor] 2022-03-25 06:08:24: Dmwatcher process DMRW2 status switching [OPEN-->RECOVERY]
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2022-03-25 06:08:24 RECOVERY OK DMRW2 OPEN PRIMARY VALID 7 32555 32555
[monitor] 2022-03-25 06:08:26: Dmwatcher process DMRW2 status switching [RECOVERY-->OPEN]
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN
2022-03-25 06:08:25 OPEN OK DMRW2 OPEN PRIMARY VALID 7 32555 32555
show
2022-03-25 06:14:45
#========================================================&#