准备相同linux环境和版本的数据库
192.168.100.111:5236
192.168.100.112:5237(辅助实例)

1、辅助实例（112）启动AUXILIARY_MODE=1
./dmserver /home/dmdba/dmdbms/data/DAMENG/dm.ini AUXILIARY_MODE=1

2、----111服务器disql登录：将111数据备份到112服务器
./disql SYSDBA/'"Dameng@123"'
BACKUP DATABASE BACKUPSET 'remote-bakset01' DEVICE TYPE REMOTE PARMS 'USER=SYSDBA;PASSWORD=Dameng@123;SVC_NAME=192.168.100.112:5237';

备份集添加时间（年月日时分秒）
BACKUP DATABASE FORMAT '%R_%d_%T%H' DEVICE TYPE REMOTE PARMS 'USER=SYSDBA;PASSWORD=Dameng@123;SVC_NAME=192.168.100.112:5237';
备份集添加时间（年月日）
BACKUP DATABASE FORMAT '%R_%d_%T' DEVICE TYPE REMOTE PARMS 'USER=SYSDBA;PASSWORD=Dameng@123;SVC_NAME=192.168.100.112:5237';
-----112服务器disql登录111服务器数据库：将111数据备份到112服务器
./disql SYSDBA/'"Dameng@123"'@192.168.100.111:5236
BACKUP DATABASE BACKUPSET 'remote-bakset01' DEVICE TYPE REMOTE PARMS 'USER=SYSDBA;PASSWORD=Dameng@123;SVC_NAME=192.168.100.112:5237';

3、 dmrman查看远程备份集信息
SHOW BACKUPSET 'remote-bakset01' DEVICE TYPE REMOTE PARMS 'USER=SYSDBA;PASSWORD=Dameng@123;SVC_NAME=192.168.100.112:5237';

校验远程备份集正确性
CHECK BACKUPSET 'remote-bakset01' DEVICE TYPE REMOTE PARMS 'USER=SYSDBA;PASSWORD=Dameng@123;SVC_NAME=192.168.100.112:5237';

4、从远程备份集还原
restore database '/home/dmdba/dmdbms/data/DAMENG/dm.ini' from backupset 'remote-bakset01' DEVICE TYPE REMOTE PARMS 'USER=SYSDBA;PASSWORD=Dameng@123;SVC_NAME=192.168.100.112:5237';
从远程备份集恢复
recover database '/home/dmdba/dmdbms/data/DAMENG/dm.ini' from backupset 'remote-bakset01' DEVICE TYPE REMOTE PARMS 'USER=SYSDBA;PASSWORD=Dameng@123;SVC_NAME=192.168.100.112:5237';
recover database '/home/dmdba/dmdbms/data/DAMENG/dm.ini' update DB_MAGIC;

5、dmrman删除远程备份
REMOVE BACKUPSET 'remote-bakset01' DEVICE TYPE REMOTE PARMS 'USER=SYSDBA;PASSWORD=Dameng@123;SVC_NAME=192.168.100.112:5237';

6、定时作业
本地配置定时作业（每天全量备份111服务器数据库到112默认备份路径）
call SP_CREATE_JOB('REMOTEBAK',1,0,'',0,0,'',0,'');

call SP_JOB_CONFIG_START('REMOTEBAK');

call SP_ADD_JOB_STEP_EX('REMOTEBAK', 'R1', 0, 'BACKUP DATABASE FORMAT ''%R_%d_%T%H'' DEVICE TYPE REMOTE PARMS ''USER=SYSDBA;PASSWORD=Dameng@123;SVC_NAME=192.168.100.112:5237'';', 1, 1, 0, 0, NULL, 0, 'null');

call SP_ADD_JOB_SCHEDULE('REMOTEBAK', 'R2', 1, 1, 1, 0, 0, '00:30:00', NULL, '2025-09-23 14:11:30', NULL, '');

call SP_JOB_CONFIG_COMMIT('REMOTEBAK');

call SP_JOB_SET_SCHEMA('REMOTEBAK', 'SYSDBA');