#虚拟机 -数据库A
./dminit path=/dm8/data PAGE_SIZE=32 EXTENT_SIZE=32 CASE_SENSITIVE=n CHARSET=1 LENGTH_IN_CHAR=1 DB_NAME=DMDB INSTANCE_NAME=DM01 PORT_NUM=5237
##虚拟机 -数据库B
./dminit path=/dm8/data PAGE_SIZE=32 EXTENT_SIZE=32 CASE_SENSITIVE=n CHARSET=1 LENGTH_IN_CHAR=1 DB_NAME=DMDB INSTANCE_NAME=DM02 PORT_NUM=5237

1 正常关闭数据库
2 数据库A进行脱机备份
./dmrman CTLSTMT="BACKUP DATABASE '/dm8/data/DMDB/dm.ini' FULL BACKUPSET '/dm8/data/BACKUP_FILE_01'"
3 拷贝备份文件到备库所在机器
4 执行脱机数据库还原与恢复
./dmrman CTLSTMT="RESTORE DATABASE '/dm8/data/DMDB/dm.ini' FROM BACKUPSET '/dm8/data/BACKUP_FILE_01'"

./dmrman CTLSTMT="RECOVER DATABASE '/dm8/data/DMDB/dm.ini' FROM BACKUPSET '/dm8/data/BACKUP_FILE_01'"

./dmrman CTLSTMT="RECOVER DATABASE '/dm8/data/DMDB/dm.ini' UPDATE DB_MAGIC"

4.1配置 dm.ini（主库备库都要修改）
INSTANCE_NAME = DM01
PORT_NUM = 5237
DW_INACTIVE_INTERVAL = 60
ALTER_MODE_STATUS = 0
ENABLE_OFFLINE_TS = 2
MAL_INI = 1
ARCH_INI = 1
RLOG_SEND_APPLY_MON = 64
4.2 配置 dmmal.ini（主库备库一致）
MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1]
MAL_INST_NAME = DM01
MAL_HOST = 192.168.152.199
MAL_PORT = 61141
MAL_INST_HOST = 192.168.152.199
MAL_INST_PORT = 5237
MAL_DW_PORT = 52141
MAL_INST_DW_PORT = 33141
[MAL_INST2]
MAL_INST_NAME = DM02
MAL_HOST = 192.168.152.198
MAL_PORT = 61142
MAL_INST_HOST = 192.168.152.198
MAL_INST_PORT = 5237
MAL_DW_PORT = 52142
MAL_INST_DW_PORT = 33142
4.3 配置 dmarch.ini
##备库的配置
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = DM01
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/data/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

##主库的配置
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = DM02
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/data/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0
4.4 配置 dmwatcher.ini（主库备库一致）
[GRP1]
DW_TYPE = GLOBAL
DW_MODE = AUTO
DW_ERROR_TIME = 10
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 10
INST_OGUID = 453331
INST_INI = /dm8/data/DMDB/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/bin/dmserver
RLOG_SEND_THRESHOLD = 0
RLOG_APPLY_THRESHOLD = 0
5 修改模式
5.1 主库

mount启动

./dmserver /dm8/data/DMDB/dm.ini mount

##连接修改oguid与primary
./disql SYSDBA/SYSDBA@LOCALHOST:5237

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);

停库

5.2 备库

mount启动

./dmserver /dm8/data/DMDB/dm.ini mount

##连接修改oguid与primary
./disql SYSDBA/SYSDBA@LOCALHOST:5237

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

停库

6 启动主库备库守护
##启动守护进程，先启动主库，后启动备库；

方式1

./dmwatcher /dm8/data/DMDB/dmwatcher.ini

方式2注册服务后启动（主库示例）

./dm_service_installer.sh -t dmwatcher -watcher_ini /dm8/data/DMDB/dmwatcher.ini -p DM01

systemctl status DmWatcherServiceDM01.service
7 监视器配置与启用
7.1 在主库或备库上添加配置文件dmmonitor.ini（示例在备库）
MON_DW_CONFIRM = 1
MON_LOG_PATH = /dm8/data/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.152.199:52141
MON_DW_IP = 192.168.152.198:52142
7.2 启动监视器
./dmmonitor /dm8/data/dmmonitor.ini