1.主备同步测试

192.168.40.129主库

disql SYSDBA/dameng123@192.168.40.129:25236
create tablespace test01 datafile '/dm/dmdata/xpcdb/test01.dbf' size 100 autoextend off;
create tablespace test01_idx datafile '/dm/dmdata/xpcdb/test01_idx01.dbf' size 100 autoextend off;
create user "test01" identified by "test123456" default tablespace test01 default index tablespace test01_idx;
grant dba to test01;
select PATH from v$datafile;

conn test01/test123456@192.168.40.129:25236;
create table test01 (id int,name varchar(50),create_date date);
insert into test01 values(1,'达梦','2022-10-15');
insert into test01 values(2,'达梦数据库','2022-10-16');
insert into test01 values(3,'DM','2022-10-17');
insert into test01 values(4,'DMDB','2022-10-18');
insert into test01 values(5,'DM8','2022-10-19');
commit;
select count(*) from test01;

192.168.40.128备库

登录到备库检查一下数据

disql SYSDBA/dameng123@192.168.40.128:15236

select PATH from v$datafile;
conn test01/test123456@192.168.40.128:15236;
select count(*) from test01.test01;

2.主备切换测试

检查主备服务状态，数据守护状态

主：

disql SYSDBA/dameng123@192.168.40.129:25236
select name, status$,ROLE$ from v$database;
ps -ef | grep dms
ps -ef | grep dmw

备：

disql SYSDBA/dameng123@192.168.40.128:15236
select name, status$,ROLE$ from v$database;
ps -ef | grep dms
ps -ef | grep dmw

前台启动监视器

手动切换

输入login
用户和密码

输入：
switchover XPCDB1 查看主备库切换成功

自动切换

主库

ps -ef | grep dmw
ps -ef | grep dms
kill -9 69154 68922

监视器

https://eco.dameng.com