DPC单节点备份还原
cd /dmbak
scp -r DB_DAMENG_FULL_2024_12_01_01_00_12_BP7_B dmdba@172.17.59.17:/dmbak
密码
Dameng@123

–检查备份集
CHECK BACKUPSET ‘/dmbak/DB_DAMENG_FULL_2024_12_01_01_00_12_BP7_B’

–停止BP7_A
cd /dmdata/dmdpc/BP7_A/bin
./DmService_BP7_A stop

./dmrman
cd /dmdata/dmdpc/BP7_A/bin
–使用dmrman进行还原
show backupset ‘/dmbak/DB_DAMENG_FULL_2024_12_01_01_00_12_BP7_B’ info meta;
（bak_magic）

RESTORE DATABASE ‘/dmdata/dmdpc/BP7_A/DAMENG/dm.ini’ FROM BACKUPSET ‘/dmbak/DB_DAMENG_FULL_2024_12_01_01_00_12_BP7_B’ use bak_magic 161238372;

RECOVER DATABASE ‘/dmdata/dmdpc/BP7_A/DAMENG/dm.ini’ FROM BACKUPSET ‘/dmbak/DB_DAMENG_FULL_2024_12_01_01_00_12_BP7_B’ use bak_magic 161238372 UNTIL END_LSN;

RECOVER DATABASE ‘/dmdata/dmdpc/BP7_A/DAMENG/dm.ini’ update DB_MAGIC;

–在BP7_B上设置异步恢复间隔（如果归档状态变了就不用执行了）
./disql SYSDBA/’“SJZWJW1@#”’:5241#{mpp_type=local}
SP_SET_RAFT_ASYNC_INTERVAL(‘BP7_A’, 30);

SP_SET_RAFT_ASYNC_INTERVAL(‘BP7_A’, 3);