1.备份主库数据库
/home/dmdba/dmdbms/bin/dmrman use_ap=2
backup database '/dmdata/DAMENG/dm.ini' backupset '/home/dmdba/dmbak/BACKUPFULL_20230530' COMPRESSED LEVEL 5;
2.传输备份文件
scp -rp /home/dmdba/dmbak/BACKUPFULL_20230530 dmdba@172.24.22.44:/backup/
3.停止数据库主库/备库实例
su - dmdba
/opt/dmdbms/bin/dmcssm dmcssm.ini
show
set GRP_DSC auto restart off
ep stop GRP_DSC
4.恢复数据库
dmrman dcr_ini=/opt/dmdbms/dsc_config/DSC1/dmdcr.ini
restore database '/opt/dmdbms/dsc_config/DSC1/dm.ini' from backupset '/backup/BACKUPFULL_20230530';
recover database '/opt/dmdbms/dsc_config/DSC1/dm.ini' from backupset '/backup/BACKUPFULL_20230530';
recover database '/opt/dmdbms/dsc_config/DSC1/dm.ini' update db_magic;
5.启动数据库主库/备库实例
su - dmdba
/opt/dmdbms/bin/dmcssm dmcssm.ini
show
set GRP_DSC auto restart on