1.环境
os: Kylin Linux Advanced Server release V10 (Sword)
db:
ip地址
192.168.3.132
数据库节点
192.168.3.133
备份节点
/home/dmdba/dmdbms/bin/dmserver path=/data/DAMENG/dm.ini AUXILIARY_MODE=1
2.dmrman 远程备份功能
(1)创建远程辅助节点(192.168.3.133)
dminit path=/data/dmdata db_name=AUXILIARY port_num=25566 SYSDBA_PWD='dmDBzdcXQvk!F87H' SYSAUDITOR_PWD='dmDBzdcXQvk!F87H'
(2)启动远程辅助库(192.168.3.133)
/home/dmdba/dmdbms/bin/dmserver path=/data/dmdata/AUXILIARY/dm.ini AUXILIARY_MODE=1
(3) 本地数据库备份到辅助实例
本地数据库联机备份到辅助实例(192.168.3.132)
./disql
sql> backup database backupset 'bak_to_remote' device type remote parms 'USER=SYSDBA;PASSWORD=dmDBzdcXQvk!F87H;SVC_NAME=192.168.3.133:25566;';
远程节点验证备份: (192.168.3.133)
[dmdba@slave:/data/dmdata/AUXILIARY/bak/bak_to_remote]$ ll
总用量 36588
-rw-r--r-- 1 dmdba dinstall 13312 7月 30 15:00 bak_to_remote_1.bak
-rw-r--r-- 1 dmdba dinstall 37329408 7月 30 15:00 bak_to_remote.bak
-rw-r--r-- 1 dmdba dinstall 116224 7月 30 15:00 bak_to_remote.meta
[dmdba@slave:/data/dmdata/AUXILIARY/bak/bak_to_remote]$ dmrman CTLSTMT="check backupset '/data/dmdata/AUXILIARY/bak/bak_to_remote'"
dmrman V8
check backupset '/data/dmdata/AUXILIARY/bak/bak_to_remote'
[Percent:100.00%][Speed:0.00M/s][Cost:00:00:00][Remaining:00:00:00]
check backupset successfully.
time used: 391.636(ms)
[dmdba@slave:/data/dmdata/AUXILIARY/bak/bak_to_remote]$
本地地数据库脱机备份到辅助实例(192.168.3.132)
关闭该节点的备份数据库.
./dmrman
RMAN> backup database '/data/dmdata/DAMENG/dm.ini' backupset 'bak_remote2' device type remote parms 'USER=SYSDBA;PASSWORD=dmDBzdcXQvk!F87H;SVC_NAME=192.168.3.133:25566' ;
远程节点验证备份(192.168.3.132)
[dmdba@slave:/data/dmdata/AUXILIARY/bak]$ ll
总用量 0
drwxr-xr-x 2 dmdba dinstall 53 7月 30 15:18 bak_remote2
drwxr-xr-x 2 dmdba dinstall 84 7月 30 15:00 bak_to_remote
[dmdba@slave:/data/dmdata/AUXILIARY/bak]$ dmrman CTLSTMT="check backupset '/data/dmdata/AUXILIARY/bak/bak_remote2'"
dmrman V8
check backupset '/data/dmdata/AUXILIARY/bak/bak_remote2'
[Percent:100.00%][Speed:0.00M/s][Cost:00:00:00][Remaining:00:00:00]
check backupset successfully.
time used: 182.469(ms)
[dmdba@slave:/data/dmdata/AUXILIARY/bak]$
注意:
backupset 后面设置备份集名称, 不要添加路径.
远程备份路径为辅助数据库的默认路径.
(4) 从远程备份集还原恢复 (192.168.3.132)
./dmrman
RMAN> restore database '/data/dmdata/DAMENG/dm.ini' overwrite from backupset 'bak_remote2' device type remote parms 'USER=SYSDBA;PASSWORD=dmDBzdcXQvk!F87H;SVC_NAME=192.168.3.133:25566;';
RMAN> recover database '/data/dmdata/DAMENG/dm.ini' from backupset 'bak_remote2' device type remote parms 'USER=SYSDBA;PASSWORD=dmDBzdcXQvk!F87H;SVC_NAME=192.168.3.133:25566;';
RMAN> recover database '/data/dmdata/DAMENG/dm.ini' update db_magic;
执行记录:
文章
阅读量
获赞
