主备集群
1、主库联机备份，发送给异步备库
backup database backupset ‘/data/dmbak/FULL_BACKUP’ compressed level 3 parallel 5;
scp -r /data/dmbak/FULL_BACKUP dmdba@192.168.229.158:/data/dmbak
2、动态修改dmmail.ini，添加异步备库信息 – 主备执行
SF_MAL_CONFIG(1,0);
SF_MAL_INST_ADD(‘MAL_INST3’,‘DMSERVER_ASYN’,‘192.168.229.158’,61141,‘192.168.229.158’,5236,52141,33141,’’);
SF_MAL_CONFIG_APPLY();
SF_MAL_CONFIG(0,0);

3、动态修改启动定时器参数 – 主备执行
SP_SET_PARA_VALUE(1,‘TIMER_INI’,1);

4、动态添加定时器 – 主备执行
SP_ADD_TIMER(
‘RT_TIMER’, – timer_name：定时器名称
2, – type：按日执行
1, – freq_month_week_interval：间隔1天
0, – freq_sub_interval
1, – freq_minute_interval：每分钟执行一次
‘00:00:00’, – start_time：开始时间
‘23:59:00’, – end_time：结束时间
‘2022-07-26 16:00:00’, – during_start_date
‘9999-12-31 23:59:59’, – during_end_date
1, – no_end_date_flag
‘RT_TIMER’, – describe
1 – is_valid：创建后立即生效
);

5、添加归档 – 主备执行
ALTER DATABASE ADD ARCHIVELOG ‘DEST= DMSERVER_ASYN, TYPE= ASYNC, ARCH_TIMER_NAME= RT_TIMER’;

异步备库
1、备库还原
dmrman CTLSTMT=“RESTORE DATABASE ‘/data/dmdata/DAMENG/dm.ini’ FROM BACKUPSET ‘/data/dmbak/FULL_BACKUP’”
dmrman CTLSTMT=“RECOVER DATABASE ‘/data/dmdata/DAMENG/dm.ini’ FROM BACKUPSET ‘/data/dmbak/FULL_BACKUP’”
dmrman CTLSTMT=“RECOVER DATABASE ‘/data/dmdata/DAMENG/dm.ini’ UPDATE DB_MAGIC”

2、dm.ini

MAL_INI = 1
ARCH_INI = 1
ALTER_MODE_STATUS= 0
ENABLE_OFFLINE_TS= 2
RLOG_SEND_APPLY_MON = 64
INSTANCE_NAME = GRP1_RT_01
PORT_NUM = 5236
DW_INACTIVE_INTERVAL = 60
DW_SUSPEND_TIME = 60
SUSPEND_WORKER_TIMEOUT = 60
DW_ARCH_SPACE_CHECK = 1
DW_ARCH_HANG_CHECK = 1
REDOS_BUF_SIZE = 10240
REDOS_BUF_NUM= 0
REDOS_MAX_DELAY = 600
REDOS_PARALLEL_NUM = 32
TIMER_INI = 1 #打开定时器

3、dmmal.ini

参考示例：
MAL_CHECK_INTERVAL =60
MAL_CONN_FAIL_INTERVAL =15
[MAL_INST1]
MAL_INST_NAME =DMSERVER01
MAL_HOST =192.168.229.136
MAL_PORT =61141
MAL_INST_HOST =192.168.229.136
MAL_INST_PORT =5236
MAL_DW_PORT =52141
MAL_INST_DW_PORT =33141
[MAL_INST2]
MAL_INST_NAME =DMSERVER02
MAL_HOST = 192.168.229.137
MAL_PORT =61141
MAL_INST_HOST =192.168.229.137
MAL_INST_PORT =5236
MAL_DW_PORT =52141
MAL_INST_DW_PORT =33141

4、dmarch.ini

[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /data/dmarch
ARCH_FILE_SIZE = 2048
ARCH_SPACE_LIMIT = 4096

5、dmwatch.ini

[GRP1]
DW_TYPE =LOCAL
DW_MODE =MANUAL
DW_ERROR_TIME =60
INST_ERROR_TIME =60
INST_RECOVER_TIME =60
INST_OGUID =45331
INST_INI =/data/dmdata/DAMENG/dm.ini
INST_AUTO_RESTART =1
INST_STARTUP_CMD =/home/dmdba/dmdbms/bin/DmServiceDAMENG restart
INST_SERVICE_IP_CHECK=1
DW_RECONNECT=2
DW_SUSPEND_CHECK=1

6、mount方式启动同步备库，设置 OGUID和备库

su - dmdba
dmserver /data/dmdata/DAMENG/dm.ini mount
#设置 OGUID
su - dmdba
disql
SP_SET_PARA_VALUE(1, ‘ALTER_MODE_STATUS’, 1);
sp_set_oguid(45331);
alter database STANDBY;
SP_SET_PARA_VALUE(1, ‘ALTER_MODE_STATUS’, 0);

7、注册并启动dmwatch服务

DmWatcherServiceWatcher start