达梦数据库的守护集群类似oracle的DG 搭建相对oracle要复杂不少 且需要的配置也不相同,达梦搭建守护集群时推荐3台服务器,其中2台为数据库服务器，一台为监视器服务器。一下是搭建步骤
1.参数相关
dmmal.ini （主备配置相同）:
MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1]
MAL_INST_NAME = DMSVR01 #实例名，和 dm.ini 中的 INSTANCE_NAME 一致
MAL_HOST = 192.168.210.201 #实例1IP
MAL_PORT = 15236
MAL_INST_HOST = 192.168.210.201 #实例1IP
MAL_INST_PORT = 5236
MAL_DW_PORT =65101
MAL_INST_DW_PORT = 45101
[MAL_INST2]
MAL_INST_NAME = DMSVR02 #实例名，和 dm.ini 中的 INSTANCE_NAME 一致
MAL_HOST = 192.168.210.202 #实例2IP
MAL_PORT = 15236
MAL_INST_HOST = 192.168.210.202 #实例2IP
MAL_INST_PORT = 5236
MAL_DW_PORT =65101
MAL_INST_DW_PORT = 45101

dmarch.ini （主备配置不同）:
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = DMSVR02 #需要指向目标库实例名

[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

dmwatcher.ini （主备配置相同）:
[GRP1]
DW_TYPE = GLOBAL
DW_MODE = AUTO
DW_ERROR_TIME = 10
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 10
INST_OGUID = 8888
INST_INI = /dm8/data/DM01/dm.ini ##需要修改为实际路径
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/dmdbms/bin/dmserver ##需要修改为实际路径
RLOG_SEND_THRESHOLD = 0
RLOG_APPLY_THRESHOLD = 0

dm.ini （需要修改指定参数）
MAL_INI = 1
ARCH_INI = 1
ALTER_MODE_STATUS= 0
ENABLE_OFFLINE_TS= 2

dmmonitor.ini （监视器参数文件）
MON_DW_CONFIRM = 1
MON_LOG_PATH = /dm8/log
MON_LOG_INTERVAL = 60
MON_LOG_FILE_SIZE = 32
MON_LOG_SPACE_LIMIT = 0
[GRP1] ##需要和守护进程的组名相同
MON_INST_OGUID = 8888
MON_DW_IP = 192.168.88.101:65101
MON_DW_IP = 192.168.88.102:65101

配置过程
主库操作:
配置参数文件dm.ini,dmmal.ini,dmwatcher.ini,dmarch.ini
关闭主库，备份数据库，将备份拷贝到备库的机器上
DmServiceDMSVR01 stop
RMAN> backup database ‘/dm8/data/DM01/dm.ini’ backupset ‘/backup’;
将备份和dm.ini,dmmal.ini,dmwatcher.ini,dmarch.ini传至备库
将数据库启动到mount状态
dmserver /dm8/data/DM01/dm.ini mount
修改oguid和数据库模式
sp_set oguid(8888);
alter database primary;
注册守护进程服务器
/dm8/script/root/dm_service_installer.sh -t dmwatcher
-p DMSVR0l -watcher_ini /dm8/data/DM0l/dmwatcher.ini

备库操作:
初始化实例
dminit db name=DM02 instance name=DMSVR02 path= am8 data SYSDBA PWD=DMsysdba0lSYSAUDTTOR PWD=DMsysdba0l
还原备库
restore database ‘/dm8/data/DM02/dm.ini’ from backupset ‘/backup’;
recoverdatabase ‘/dm8/data/DM02/dm.ini’ from backupset ‘/backup’;
recover databaseupdate db magic:
将参数文件dm.ini,dmmal.ini,dmwatcher.ini,dmarch.ini拷贝到/dm8/data/DM02下 并修改dmarch.ini
将数据库启动到mount状态
修改oguid和数据库模式
dmserver /dm8/data/DM02/dm.ini mount
sp set oguid(8888);
alter database standby:
注册服务
/dm8/script/root/dm_service_installer.sh-t dmserver -p DMSVR02 -dm ini /dm8/data/DM02/dm, ini
/dm8/script/root/dm_service_installer.sh -t dmwatcher -p DMSVR02 -watcher ini /dm8/data/DM02/dmwatcher. ini

启动主备守护进程
/dm8/bin/DmWatcherServiceDMSVR0l start
/dm8/bin/DmWatcherServiceDMSVR02 start

监视器操作:
创建监视器参数文件dmmonitor.ini
启动监视器
/dm8/bin/dmmonitor /dm8/dmmonitor.ini

主备切换:
监视器登录
login
sysdba
DMsysdba01
show
主备切换
switchover
Y