异步备库部署
异步备库的搭建背景
异步备库一般用于历史数据统计、周期报表等对数据实时性要求不高的业务场合。异步归档时机可以选择在源库空闲的时候,可避免源库的业务高峰期同步数据对性能的影响
异步备库环境配置
primary: 10.206.5.55 10.206.5.60
HA做主:vip: 10.206.5.31
standby 10.206.5.56 10.206.5.57
一、数据准备
1.安装主库(160安装软件和实例,155安装软件)
1)安装数据库
2)初始化数据库
3)启动DM8服务器
cd /tmp
sh install.sh
cd /dm8/dmdbms/bin
./disql SYSDBA/xxxxx:5236
2.安装备库
1).主库备份
./dmrman CTLSTMT=“BACKUP DATABASE ‘/dmdata/5236/test2/dm.ini’ FULL TO BACKUP_FILE1 BACKUPSET ‘/dmdata/5236/test2/BACKUP_FILE_01’”
2)安装数据库 不初始化数据库 不启动数据库
3)拷贝备份文件到备库,对备库进行脱机还原
./dmrman CTLSTMT=“CHECK BACKUPSET ‘/dmdata/5236/test2/BACKUP_FILE_01’”
./dmrman CTLSTMT=“RESTORE DATABASE ‘/dmdata/5236/DM02/dm.ini’ FROM BACKUPSET ‘/dmdata/BACKUP_FILE_01’”
./dmrman CTLSTMT=“RECOVER DATABASE ‘/dmdata/5236/DM02/dm.ini’ FROM BACKUPSET ‘/dmdata/BACKUP_FILE_01’”
./dmrman CTLSTMT=“RECOVER DATABASE ‘/dmdata/5236/DM02/dm.ini’ UPDATE DB_MAGIC”
./dmrman CTLSTMT=“RESTORE DATABASE ‘/dmdata/5236/DM03/dm.ini’ FROM BACKUPSET ‘/dmdata/BACKUP_FILE_01’”
./dmrman CTLSTMT=“RECOVER DATABASE ‘/dmdata/5236/DM03/dm.ini’ FROM BACKUPSET ‘/dmdata/BACKUP_FILE_01’”
./dmrman CTLSTMT=“RECOVER DATABASE ‘/dmdata/5236/DM03/dm.ini’ UPDATE DB_MAGIC”
备份之前要重启ap服务,配置归档,注册服务
./dm_service_installer.sh -t dmserver -p DM03 -dm_ini /dmdata/5236/test2/dmr.ini mount
二.配置主库
1.修改配置文件
(1)dm.ini
SYSDBA用户执行
call SF_SET_SYSTEM_PARA_VALUE (‘TIMER_INI’,1,1,2);
call SF_SET_SYSTEM_PARA_VALUE (‘DW_INACTIVE_INTERVAL’,60,1,2);
call SF_SET_SYSTEM_PARA_VALUE (‘ALTER_MODE_STATUS’,0,1,2);
call SF_SET_SYSTEM_PARA_VALUE (‘ENABLE_OFFLINE_TS’,2,1,2);
call SF_SET_SYSTEM_PARA_VALUE (‘MAL_INI’,1,1,2);
call SF_SET_SYSTEM_PARA_VALUE (‘RLOG_SEND_APPLY_MON’,100,1,2);
call SF_SET_SYSTEM_PARA_VALUE (‘ARCH_INI’,1,1,2);
(2)配置dmmal.ini
MAL_CHECK_INTERVAL = 5 #MAL链路检测时间间隔
MAL_CONN_FAIL_INTERVAL = 5 #判定MAL链路断开的时间
[MAL_INST1]
MAL_INST_NAME =DM01 #实例名&#x