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);

show backupset '/dmbak/DB_DAMENG_FULL_2025_10_21_15_59_21_BP2_A' info db   ---查看dpc_magic

show backupset '/dmbak/DB_DAMENG_FULL_2025_10_21_15_59_21_BP2_A' info meta ---查看bak_magic


RESTORE DATABASE '/dmdata/dmdpc/BP2_B/DAMENG/dm.ini' FROM BACKUPSET '/dmbak/DB_DAMENG_FULL_2025_10_21_15_59_21_BP2_A'  use bak_magic 0

RECOVER DATABASE '/dmdata/dmdpc/BP2_B/DAMENG/dm.ini' FROM BACKUPSET '/dmbak/DB_DAMENG_FULL_2025_10_21_15_59_21_BP2_A' use bak_magic 0  until end_lsn

RECOVER DATABASE '/dmdata/dmdpc/BP2_B/DAMENG/dm.ini' UPDATE dpc_magic  2114798857;

RECOVER DATABASE '/dmdata/dmdpc/BP2_B/DAMENG/dm.ini' UPDATE db_magic;