注册
达梦异步灾备搭建实战
培训园地/ 文章详情 /

达梦异步灾备搭建实战

💧 2024/04/24 797 0 0

备份:
./dmrman CTLSTMT="BACKUP DATABASE '/dm8_data/DAMENG/dm.ini' FULL TO BACKUP_FILE BACKUPSET '/dm8_data/DAMENG/bak/BACKUP_FILE'"

备份还原:

RESTORE DATABASE ‘/home/dmdba/dmdata/its/dm.ini’ FROM BACKUPSET ‘/home/dmdba/dmbak/full_database’;

RECOVER DATABASE ‘/home/dmdba/dmdata/its/dm.ini’ FROM BACKUPSET ‘/home/dmdba/dmbak/full_database’;

RECOVER DATABASE ‘/home/dmdba/dmdata/its/dm.ini’ UPDATE DB_MAGIC;

主备dm.ini
TIMER_INI = 1

异步备库dm.ini
INSTANCE_NAME =its3
MAL_INI = 1
ARCH_INI = 1
ALTER_MODE_STATUS = 0
ENABLE_OFFLINE_TS = 2

主备归档dmarch
[ARCHIVE_ASYNC]
ARCH_TYPE = ASYNC #异步归档类型
ARCH_DEST = its3 #异步归档目标实例名(主库侧填写异步备库实例名)
ARCH_TIMER_NAME = RT_TIMER #定时器名称,和 dmtimer.ini 中的名称一致

异步备库归档
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /home/dmdba/dmarch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0
ARCH_FLUSH_BUF_SIZE = 0

主备异步备相同dmmal.ini
[MAL_INST3]
MAL_INST_NAME = its3
MAL_HOST = 192.168.10.114
MAL_PORT = 61141
MAL_INST_HOST = 192.168.10.114
MAL_INST_PORT = 5236
MAL_DW_PORT = 52141
MAL_INST_DW_PORT = 33141

主备dmwatcher.ini不动

异步watcher.ini
[GRP_RW]
DW_TYPE = LOCAL #本地守护类型
DW_MODE = MANUAL #手动切换模式
DW_ERROR_TIME = 10
INST_ERROR_TIME = 10
INST_OGUID = 453331
INST_INI = /home/dmdba/dmdata/its/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /home/dmdba/dmdbms/bin/dmserver

主备配置dmtimer.ini

[RT_TIMER] #和 dmarch.ini 中的 ARCH_TIMER_NAME 一致
TYPE = 2
FREQ_MONTH_WEEK_INTERVAL = 1
FREQ_SUB_INTERVAL = 0
FREQ_MINUTE_INTERVAL = 120
START_TIME = 00:00:00
END_TIME = 00:00:00
DURING_START_DATE = 2022-11-11 15:00:00
DURING_END_DATE = 9999-12-31 23:59:59
NO_END_DATE_FLAG = 1
DESCRIBE = RT_TIMER
IS_VALID = 1

异步备库
SQL> SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
SQL> sp_set_oguid(26180); #修改 oguid
SQL> alter database standby; #修改为 standby 模式
SQL> SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);

注册:
./dm_service_installer.sh -t dmserver -m mount -dm_ini /dm8_data/DAMENG/dm.ini -p DW3
./dm_service_installer.sh -t dmwatcher -watcher_ini /dm8_data/DAMENG/dmwatcher.ini -p DW1_02

监视器:
dmmonitor.ini
添加备库IP端口信息

评论
后发表回复

作者

文章

阅读量

获赞

扫一扫
联系客服