搭建读写分离集群
主机
内网:10.10.10.7
外网:192.168.152.133
备机
内网:10.10.10.8
外网:192.168.152.134
步骤一:主机脱机备份
关闭服务
cd /etc/init.d
./DmServiceDW_1 stop
到bin目录
./dmrman,使用dmrman工具脱机备份
脱机备份
BACKUP DATABASE ‘/home/dmdba/dmdbms/data/DW_1/dm.ini’ FULL BACKUPSET ‘/home/dmdba/bak/fullbak2’;
把主机全量备份的备份集拷贝到备机
scp -r /home/dmdba/bak/fullbak2 192.168.152.134:/home/dmdba/bak
restore database ‘/home/dmdba/dmdbms/dmdata/DW_2/dm.ini’ from backupset ‘/home/dmdba/bak/fullbak2’
recover database ‘/home/dmdba/dmdbms/dmdata/DW_2/dm.ini’ from backupset ‘/home/dmdba/bak/fullbak2’
recover database ‘/home/dmdba/dmdbms/dmdata/DW_2/dm.ini’ update db_magic
确认主备库的lsn和永久魔数是否一致
前台启动数据库,mount状态
./dmserver …/data/DW_1/dm.ini mount
./dmserver /home/dmdba/dmdbms/dmdata/DW_2/dm.ini mount