数据守护搭建
1.关闭主备实例root:systemctl stop
2.创建主备备份目录data/
3.主库备份:./dmrman backup DATABASE 'ini目录' FULL TO 文件名 BACKUPSET '存放目录'
4.备库拷贝:scp root@地址目录 .(当前目录)
5.备库还原、恢复:./dmrman RESTORE/recover DB 'ini' FROM '目录'
6.同步数据模数:./dmrman RECOVER DATABASE 'ini' UPDATE DB_MAGIC
7.启动主库:dmserver /ini mount
8.修改配置SP_SET_PARA_VALUE(1,'ALTER_MODE_STATUS',1);
sp_set_oguid();
alter database primary;
sp_set_para_value(1,'alter_mode_status',0);
9.修改mal/arch/watcher/ini文件配置
主备服务注册:
./dm_service_installer.sh -t dmserver -p DMSERVER -m mount -dm_ini /dm8/DAMENG/dm.ini
./dm_service_installer.sh -t dmwatcher -p DMWATCHER -watcher_ini /dm8/DAMENG/dmwatcher.ini
10.启动备库dmserver /ini mount
11.同主库修改,standby
12.启动主备守护:dmwatcher /dmwatcher.ini
13.登录主备库验证
14.配置监视器:ini文件
监视器服务注册:
./dm_service_installer.sh -t dmmonitor -p DMMONITOR -monitor_ini /dm8/DAMENG/dmmonitor.ini
15.启动监视器:dmmonitor /ini
16.login登录、switchover切换主备
17.退出步骤,exit退出监视器-退出备机-退出主机-关闭备库-关闭主库
文章
阅读量
获赞