注册
dmrman 远程备份和恢复功能测试
培训园地/ 文章详情 /

dmrman 远程备份和恢复功能测试

于亮 2026/04/13 101 0 0

1.环境
os: Kylin Linux Advanced Server release V10 (Sword)

db:
局部截取_20260407_180212.png

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;

执行记录:
局部截取_20260407_180309.png

评论
后发表回复

作者

文章

阅读量

获赞

扫一扫
联系客服