实验环境

dwp 192.168.205.131
dws 192.168.205.132
dwm 192.168.205.133

数据库名实例名 PORT_NUM MAL_INST_DW_PORT MAL_HOST MAL_PORT MAL_DW_PORT
DMDW GRP1_RT_01 5246 45101 192.168.205.131 55101 65101
DMDW GRP1_RT_03 5246 45121 192.168.205.132 55121 65121

创建数据库并注册服务

主节点：
#创建数据库
su - dmdba
cd /dm8/bin
./dminit path=/dm8/data db_name=DMDW instance_name=GRP1_RT_01 port_num=5246 sysdba_pwd=Dameng123 sysauditor_pwd=Dameng123
exit
cd /dm8/script/root
./dm_service_installer.sh -t dmserver -dm_ini /dm8/data/DMDW/dm.ini -p DMDWSVR
#启用服务
systemctl enable DmServiceDMDWSVR
#启停服务
systemctl start DmServiceDMDWSVR

#主库需要开启归档
alter database mount;
alter database ARCHIVELOG;
alter database ADD ARCHIVELOG 'type=local, dest=/dm8/arch, file_size=64,space_limit=10240';
alter database open;

从节点
#创建数据库
su - dmdba
cd /dm8/bin
./dminit path=/dm8/data db_name=DMDW instance_name=GRP1_RT_03 port_num=5246 sysdba_pwd=Dameng123 sysauditor_pwd=Dameng123
exit
cd /dm8/script/root
./dm_service_installer.sh -t dmserver -dm_ini /dm8/data/DMDW/dm.ini -p DMDWSVR
#启用服务
systemctl enable DmServiceDMDWSVR
#启停服务
systemctl start DmServiceDMDWSVR
systemctl stop DmServiceDMDWSVR

备份恢复

主节点：

systemctl stop DmServiceDMDWSVR
ll /dm8/backup
mkdir -p /dm8/backup
chown -R dmdba.dinstall /dm8/backup
cd /dm8/bin
./dmrman CTLSTMT="BACKUP DATABASE '/dm8/data/DMDW/dm.ini' FULL TO BACKUP_FILE1 BACKUPSET '/dm8/backup/BACKUP_FILE_01'"

从节点：
passwd dmdba
ll /dm8/backup
mkdir -p /dm8/backup
chown -R dmdba.dinstall /dm8/backup

主节点：
scp -r /dm8/backup/* 192.168.205.132:/dm8/backup/

从库：
cd /dm8/bin
./dmrman CTLSTMT="RESTORE DATABASE '/dm8/data/DMDW/dm.ini' FROM BACKUPSET '/dm8/backup/BACKUP_FILE_01'"
./dmrman CTLSTMT="RECOVER DATABASE '/dm8/data/DMDW/dm.ini' FROM BACKUPSET '/dm8/backup/BACKUP_FILE_01'"
./dmrman CTLSTMT="RECOVER DATABASE '/dm8/data/DMDW/dm.ini' UPDATE DB_MAGIC"

主库修改添加配置文件并启动

主节点：

vi dm.ini

INSTANCE_NAME = GRP1_RT_01
PORT_NUM = 5246
DW_INACTIVE_INTERVAL = 60
ALTER_MODE_STATUS = 0
ENABLE_OFFLINE_TS = 2
MAL_INI = 1
ARCH_INI = 1
RLOG_SEND_APPLY_MON = 64

vi dmmal.ini
MAL_CHECK_INTERVAL = 60
MAL_CONN_FAIL_INTERVAL = 60
[MAL_INST1]
MAL_INST_NAME = GRP1_RT_01
MAL_HOST = 192.168.205.131
MAL_PORT = 55101
MAL_INST_HOST = 192.168.205.131
MAL_INST_PORT = 5246
MAL_DW_PORT = 65101
MAL_INST_DW_PORT = 45101
[MAL_INST2]
MAL_INST_NAME = GRP1_RT_03
MAL_HOST = 192.168.205.132
MAL_PORT = 55121
MAL_INST_HOST = 192.168.205.132
MAL_INST_PORT = 5246
MAL_DW_PORT = 65121
MAL_INST_DW_PORT = 45121

vi dmarch.ini
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = GRP1_RT_03
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

vi dmwatcher.ini
[GRP1]
DW_TYPE = GLOBAL
DW_MODE = MANUAL
DW_ERROR_TIME = 60
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 60
INST_OGUID = 453331
INST_INI = /dm8/data/DMDW/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/bin/dmserver
RLOG_SEND_THRESHOLD = 0
RLOG_APPLY_THRESHOLD = 0

启动主库
cd /dm8/bin
./dmserver /dm8/data/DMDW/dm.ini mount

换窗口
cd /dm8/bin
./disql sysdba/Dameng123@localhost:5246

SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
sp_set_oguid(453331);
alter database primary;
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);

从库修改添加配置文件并启动

cd /dm8/data/DMDW/
vi dm.ini
INSTANCE_NAME = GRP1_RT_03
PORT_NUM = 5246
DW_INACTIVE_INTERVAL = 60
ALTER_MODE_STATUS = 0
ENABLE_OFFLINE_TS = 2
MAL_INI = 1
ARCH_INI = 1
RLOG_SEND_APPLY_MON = 64

vi dmarch.ini
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = GRP1_RT_01
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

以 Mount 方式启动备库
cd /dm8/bin
./dmserver /dm8/data/DMDW/dm.ini mount
换窗口
cd /dm8/bin
./disql sysdba/Dameng123@localhost:5246
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
SQL>sp_set_oguid(453331);
SQL>alter database standby;
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);

启动守护进程并注册服务

主库：

./dmwatcher /dm8/data/DMDW/dmwatcher.ini
cd /dm8/script/root
./dm_service_installer.sh -t dmwatcher -watcher_ini /dm8/data/DMDW/dmwatcher.ini -p DMWCHSVR
#启用服务
systemctl enable DmWatcherServiceDMWCHSVR
#启停服务
systemctl start DmWatcherServiceDMWCHSVR

备库：
./dmwatcher /dm8/data/DMDW/dmwatcher.ini
cd /dm8/script/root
./dm_service_installer.sh -t dmwatcher -watcher_ini /dm8/data/DMDW/dmwatcher.ini -p DMWCHSVR
#启用服务
systemctl enable DmWatcherServiceDMWCHSVR
#启停服务
systemctl start DmWatcherServiceDMWCHSVR
systemctl status DmWatcherServiceDMWCHSVR

验证主备状态

主库：
[dmdba@localhost ~]$ cd /dm8/bin
[dmdba@localhost bin]$ ./disql sysdba/Dameng123@localhost:5246

服务器[localhost:5246]:处于主库打开状态
登录使用时间 : 3.186(ms)
disql V8
SQL>

备库：
[root@localhost ~]# su - dmdba
上一次登录：二 5月 9 01:37:06 CST 2023 pts/1 上
[dmdba@localhost ~]$ cd /dm8/bin
[dmdba@localhost bin]$ ./disql sysdba/Dameng123@localhost:5246

服务器[localhost:5246]:处于备库打开状态
登录使用时间 : 3.014(ms)
disql V8
SQL>

配置并启动监视器

dmmonitor.ini
MON_DW_CONFIRM = 0
MON_LOG_PATH = /dm8/log
MON_LOG_INTERVAL = 60
MON_LOG_FILE_SIZE = 32
MON_LOG_SPACE_LIMIT = 0
[GRP1]
MON_INST_OGUID = 453331
MON_DW_IP = 192.168.205.131:65101
MON_DW_IP = 192.168.205.132:65121

cd /dm8/bin
./dmmonitor /dm8/dmmonitor.ini

#注册服务
cd /dm8/script/root
./dm_service_installer.sh -t dmmonitor -monitor_ini /dm8/dmmonitor.ini -p DMMNTSVR
#启用服务
systemctl enable DmMonitorServiceDMMNTSVR
#启停服务
systemctl start DmMonitorServiceDMMNTSVR
systemctl status DmMonitorServiceDMMNTSVR

主备切换后退出

show

switchover
switchover

退出并关闭dmmonitor
logout
exit

DM8实时主备搭建实验