./disql SYSDBA/'"Sjzwjw1@#"':5220#"{mpp_type=local}"
--检察备份集完整性
check backupset '/dmdata/dmbak/DB_DAMENG_FULL_2025_10_19_21_00_00_MP_A';
check backupset '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_21_21_00_00_MP_A';

2）获取bak_magic
show backupset '/dmdata/dmbak/DB_DAMENG_FULL_1027' info meta;
获取DPC_MAGIC
show backupset '/dmdata/dmbak/DB_DAMENG_FULL_10272' info db;


--还原MP_A:
RESTORE DATABASE '/dmdata/dmdpc/MP_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_21_21_00_00_MP_A' USE BAK_MAGIC 55542134 MODE 'NORMAL';
RECOVER DATABASE '/dmdata/dmdpc/MP_A/DAMENG/dm.ini'  FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_21_21_00_00_MP_A' USE BAK_MAGIC 55542134;
RECOVER DATABASE '/dmdata/dmdpc/MP_A/DAMENG/dm.ini' UPDATE DPC_MAGIC 605690568;
RECOVER DATABASE '/dmdata/dmdpc/MP_A/DAMENG/dm.ini' UPDATE DB_MAGIC;

--还原BP1_A
nohup ./dmrman CTLSTMT="RESTORE DATABASE '/dmdata/dmdpc/BP1_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_21_21_00_00_BP1_A' USE BAK_MAGIC 55542134 MODE 'NORMAL';" > dmrman_restore.log 2>&1 &
./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/dmdpc/BP1_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_21_21_00_00_BP1_A' USE BAK_MAGIC 55542134;"
./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/dmdpc/BP1_A/DAMENG/dm.ini' UPDATE DPC_MAGIC 605690568;"
./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/dmdpc/BP1_A/DAMENG/dm.ini' update DB_MAGIC;"

--还原BP2_A

nohup ./dmrman CTLSTMT="RESTORE DATABASE '/dmdata/dmdpc/BP2_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_21_21_00_00_BP2_A' USE BAK_MAGIC 55542134 MODE 'NORMAL';" > dmrman_restore.log 2>&1 &
./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/dmdpc/BP2_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_21_21_00_00_BP2_A' USE BAK_MAGIC 55542134;"
./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/dmdpc/BP2_A/DAMENG/dm.ini' UPDATE DPC_MAGIC 605690568;"
./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/dmdpc/BP2_A/DAMENG/dm.ini' update DB_MAGIC;"

--还原BP3_A

nohup ./dmrman CTLSTMT="RESTORE DATABASE '/dmdata/dmdpc/BP3_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_21_21_00_00_BP3_A' USE BAK_MAGIC 55542134 MODE 'NORMAL';" > dmrman_restore.log 2>&1 &
./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/dmdpc/BP3_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_21_21_00_00_BP3_A' USE BAK_MAGIC 55542134;"
./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/dmdpc/BP3_A/DAMENG/dm.ini' UPDATE DPC_MAGIC 605690568;"
./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/dmdpc/BP3_A/DAMENG/dm.ini' update DB_MAGIC;"



--还原BP4_A
nohup ./dmrman CTLSTMT="RESTORE DATABASE '/dmdata/dmdpc/BP4_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_21_21_00_00_BP4_A' USE BAK_MAGIC 55542134 MODE 'NORMAL';" > dmrman_restore.log 2>&1 &
./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/dmdpc/BP4_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_21_21_00_00_BP4_A' USE BAK_MAGIC 55542134;"
./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/dmdpc/BP4_A/DAMENG/dm.ini' UPDATE DPC_MAGIC 605690568;"
./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/dmdpc/BP4_A/DAMENG/dm.ini' update DB_MAGIC;"

--还原BP5_A
nohup ./dmrman CTLSTMT="RESTORE DATABASE '/dmdata/dmdpc/BP5_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_21_21_00_00_BP5_A' USE BAK_MAGIC 55542134 MODE 'NORMAL';" > dmrman_restore.log 2>&1 &
./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/dmdpc/BP5_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_21_21_00_00_BP5_A' USE BAK_MAGIC 55542134;"
./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/dmdpc/BP5_A/DAMENG/dm.ini' UPDATE DPC_MAGIC 605690568;"
./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/dmdpc/BP5_A/DAMENG/dm.ini' update DB_MAGIC;"

--还原BP6_A
nohup ./dmrman CTLSTMT="RESTORE DATABASE '/dmdata/dmdpc/BP6_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_21_21_00_00_BP6_A' USE BAK_MAGIC 55542134 MODE 'NORMAL';" > dmrman_restore.log 2>&1 &
./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/dmdpc/BP6_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_21_21_00_00_BP6_A' USE BAK_MAGIC 55542134;"
./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/dmdpc/BP6_A/DAMENG/dm.ini' UPDATE DPC_MAGIC 605690568;"
./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/dmdpc/BP6_A/DAMENG/dm.ini' update DB_MAGIC;"

--还原BP7_A

nohup ./dmrman CTLSTMT="RESTORE DATABASE '/dmdata/dmdpc/BP7_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_21_21_00_00_BP7_A' USE BAK_MAGIC 55542134 MODE 'NORMAL';" > dmrman_restore.log 2>&1 &
./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/dmdpc/BP7_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_21_21_00_00_BP7_A' USE BAK_MAGIC 55542134;"
./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/dmdpc/BP7_A/DAMENG/dm.ini' UPDATE DPC_MAGIC 605690568;"
./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/dmdpc/BP7_A/DAMENG/dm.ini' update DB_MAGIC;"


--还原BP8_A数据
nohup ./dmrman CTLSTMT="RESTORE DATABASE '/dmdata/dmdpc/BP8_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_21_21_00_00_BP8_A' USE BAK_MAGIC 55542134 MODE 'NORMAL';" > dmrman_restore.log 2>&1 &
./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/dmdpc/BP8_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_21_21_00_00_BP8_A' USE BAK_MAGIC 55542134;"
./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/dmdpc/BP8_A/DAMENG/dm.ini' UPDATE DPC_MAGIC 605690568;"
./dmrman CTLSTMT="RECOVER DATABASE '/dmdata/dmdpc/BP8_A/DAMENG/dm.ini' update DB_MAGIC;"

--全局登录MP修改注册信息
SP_MODIFY_DPC_INSTANCE(name varchar(128),ip_inter varchar(256), ip_exter varchar(256), ap_port int, inst_port int)

SP_MODIFY_DPC_INSTANCE('MP_A','172.16.63.21','172.16.63.21','','5220');
SP_MODIFY_DPC_INSTANCE('BP1_A','172.16.63.21','172.16.63.21','','5240');
SP_MODIFY_DPC_INSTANCE('BP2_A','172.16.63.22','172.16.63.22','','5240');
SP_MODIFY_DPC_INSTANCE('BP3_A','172.16.63.23','172.16.63.23','','5240');
SP_MODIFY_DPC_INSTANCE('BP4_A','172.16.63.24','172.16.63.24','','5240');
SP_MODIFY_DPC_INSTANCE('BP5_A','172.16.63.25','172.16.63.25','','5240');
SP_MODIFY_DPC_INSTANCE('BP6_A','172.16.63.26','172.16.63.26','','5240');
SP_MODIFY_DPC_INSTANCE('BP7_A','172.16.63.27','172.16.63.27','','5240');
SP_MODIFY_DPC_INSTANCE('BP8_A','172.16.63.28','172.16.63.28','','5240');
SP_MODIFY_DPC_INSTANCE('SP1','172.16.63.21','172.16.63.21','','5236');

--删除MP中其他节点信息数据
SP_DROP_DPC_INSTANCE('MP_B');
SP_DROP_DPC_INSTANCE('MP_C');
SP_DROP_DPC_INSTANCE('BP1_B');
SP_DROP_DPC_INSTANCE('BP1_C');
SP_DROP_DPC_INSTANCE('BP2_B');
SP_DROP_DPC_INSTANCE('BP2_C');
SP_DROP_DPC_INSTANCE('BP3_B');
SP_DROP_DPC_INSTANCE('BP3_C');
SP_DROP_DPC_INSTANCE('BP4_B');
SP_DROP_DPC_INSTANCE('BP4_C');
SP_DROP_DPC_INSTANCE('BP5_B');
SP_DROP_DPC_INSTANCE('BP5_C');
SP_DROP_DPC_INSTANCE('BP6_B');
SP_DROP_DPC_INSTANCE('BP6_C');
SP_DROP_DPC_INSTANCE('BP7_B');
SP_DROP_DPC_INSTANCE('BP7_C');
SP_DROP_DPC_INSTANCE('BP8_B');
SP_DROP_DPC_INSTANCE('BP8_C');
--将设置为单库模式
SP_ALTER_DPC_INSTANCE('MP_A', 'NORMAL', 4, 1);
SP_ALTER_DPC_INSTANCE('BP1_A', 'NORMAL', 4, 1);
SP_ALTER_DPC_INSTANCE('BP2_A', 'NORMAL', 4, 1);
SP_ALTER_DPC_INSTANCE('BP3_A', 'NORMAL', 4, 1);
SP_ALTER_DPC_INSTANCE('BP4_A', 'NORMAL', 4, 1);
SP_ALTER_DPC_INSTANCE('BP5_A', 'NORMAL', 4, 1);
SP_ALTER_DPC_INSTANCE('BP6_A', 'NORMAL', 4, 1);
SP_ALTER_DPC_INSTANCE('BP7_A', 'NORMAL', 4, 1);
SP_ALTER_DPC_INSTANCE('BP8_A', 'NORMAL', 4, 1);
--查询MP注册信息
select * from dpc_instance;