DM8 单机备份还原至DSC集群

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