备份:
./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端口信息
文章
阅读量
获赞