check backupset '/dmdata/dmbak/DB_DAMENG_FULL_2025_10_19_21_00_00_MP_A';
check backupset '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_22_21_00_00_MP_A';

获取bak_magic
show backupset '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_22_21_00_00_MP_A' info meta;
1087531106
获取DPC_MAGIC
show backupset '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_22_21_00_00_MP_A' info db;
605690568

--还原MP_A
--还原 MP_A 归档
RESTORE ARCHIVE LOG FROM BACKUPSET '/dmdata/dmbak/ARCH_FULL_DAMENG_2025_10_23_19_30_00_MP_A' TO DATABASE '/dmdata/dmdpc/MP_A/DAMENG/dm.ini' OVERWRITE 2;
--还原MP_A数据
RESTORE DATABASE '/dmdata/dmdpc/MP_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_22_21_00_00_MP_A' USE BAK_MAGIC 1087531106;
RECOVER DATABASE '/dmdata/dmdpc/MP_A/DAMENG/dm.ini' WITH ARCHIVEDIR '/dmdata/arch' UNTIL TIME '2025-10-22 14:00:00';
RECOVER DATABASE '/dmdata/dmdpc/MP_A/DAMENG/dm.ini' UPDATE DPC_MAGIC 303765128;
RECOVER DATABASE '/dmdata/dmdpc/MP_A/DAMENG/dm.ini' update DB_MAGIC;

--还原MP_B
--还原 MP_B 归档
RESTORE ARCHIVE LOG FROM BACKUPSET '/dmdata/dmbak/ARCH_FULL_DAMENG_2025_10_23_19_30_00_MP_A' TO DATABASE '/dmdata/dmdpc/MP_B/DAMENG/dm.ini' OVERWRITE 2;
--还原MP_B数据
RESTORE DATABASE '/dmdata/dmdpc/MP_B/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_22_21_00_00_MP_A' USE BAK_MAGIC 1087531106;
RECOVER DATABASE '/dmdata/dmdpc/MP_B/DAMENG/dm.ini' WITH ARCHIVEDIR '/dmdata/arch' UNTIL TIME '2025-10-22 14:00:00';
RECOVER DATABASE '/dmdata/dmdpc/MP_B/DAMENG/dm.ini' UPDATE DPC_MAGIC 303765128;
RECOVER DATABASE '/dmdata/dmdpc/MP_B/DAMENG/dm.ini' update DB_MAGIC;

--还原MP_C
--还原 MP_C 归档
RESTORE ARCHIVE LOG FROM BACKUPSET '/dmdata/dmbak/ARCH_FULL_DAMENG_2025_10_23_19_30_00_MP_A' TO DATABASE '/dmdata/dmdpc/MP_C/DAMENG/dm.ini' OVERWRITE 2;
--还原MP_C数据
RESTORE DATABASE '/dmdata/dmdpc/MP_C/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_22_21_00_00_MP_A' USE BAK_MAGIC 1087531106;
RECOVER DATABASE '/dmdata/dmdpc/MP_C/DAMENG/dm.ini' WITH ARCHIVEDIR '/dmdata/arch' UNTIL TIME '2025-10-22 14:00:00';
RECOVER DATABASE '/dmdata/dmdpc/MP_C/DAMENG/dm.ini' UPDATE DPC_MAGIC 303765128;
RECOVER DATABASE '/dmdata/dmdpc/MP_C/DAMENG/dm.ini' update DB_MAGIC;

--校验备份集完整性
check backupset '/dmdata/dmbak/DB_DAMENG_FULL_2025_10_19_21_00_00_MP_A';
check backupset '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_22_21_00_00_MP_A';

--还原BP1_A
--还原BP1_A归档
RESTORE ARCHIVE LOG FROM BACKUPSET '/dmdata/dmbak/ARCH_FULL_DAMENG_2025_10_23_19_30_00_BP4_A' TO DATABASE '/dmdata/dmdpc/BP4_A/DAMENG/dm.ini' OVERWRITE 2;
--还原BP4_A数据
RESTORE DATABASE '/dmdata/dmdpc/BP1_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_22_21_00_00_BP1_A' USE BAK_MAGIC 1087531106;
RECOVER DATABASE '/dmdata/dmdpc/BP1_A/DAMENG/dm.ini' WITH ARCHIVEDIR '/dmdata/arch' UNTIL TIME '2025-10-22 14:00:00';
RECOVER DATABASE '/dmdata/dmdpc/BP1_A/DAMENG/dm.ini' UPDATE DPC_MAGIC 303765128;
RECOVER DATABASE '/dmdata/dmdpc/BP1_A/DAMENG/dm.ini' update DB_MAGIC;

--还原BP2_A
--还原BP2_A归档
RESTORE ARCHIVE LOG FROM BACKUPSET '/dmdata/dmbak/ARCH_FULL_DAMENG_2025_10_23_19_30_00_BP4_A' TO DATABASE '/dmdata/dmdpc/BP4_A/DAMENG/dm.ini' OVERWRITE 2;
--还原BP2_A数据
RESTORE DATABASE '/dmdata/dmdpc/BP2_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_22_21_00_00_BP2_A' USE BAK_MAGIC 1087531106;
RECOVER DATABASE '/dmdata/dmdpc/BP2_A/DAMENG/dm.ini' WITH ARCHIVEDIR '/dmdata/arch' UNTIL TIME '2025-10-22 14:00:00';
RECOVER DATABASE '/dmdata/dmdpc/BP2_A/DAMENG/dm.ini' UPDATE DPC_MAGIC 303765128;
RECOVER DATABASE '/dmdata/dmdpc/BP2_A/DAMENG/dm.ini' update DB_MAGIC;

--还原BP3_A
--还原BP3_A归档
RESTORE ARCHIVE LOG FROM BACKUPSET '/dmdata/dmbak/ARCH_FULL_DAMENG_2025_10_23_19_30_00_BP4_A' TO DATABASE '/dmdata/dmdpc/BP4_A/DAMENG/dm.ini' OVERWRITE 2;
--还原BP3_A数据
RESTORE DATABASE '/dmdata/dmdpc/BP3_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_22_21_00_00_BP3_A' USE BAK_MAGIC 1087531106;
RECOVER DATABASE '/dmdata/dmdpc/BP3_A/DAMENG/dm.ini' WITH ARCHIVEDIR '/dmdata/arch' UNTIL TIME '2025-10-22 14:00:00';
RECOVER DATABASE '/dmdata/dmdpc/BP3_A/DAMENG/dm.ini' UPDATE DPC_MAGIC 303765128;
RECOVER DATABASE '/dmdata/dmdpc/BP3_A/DAMENG/dm.ini' update DB_MAGIC;



--还原BP4_A
--还原BP4_A归档
RESTORE ARCHIVE LOG FROM BACKUPSET '/dmdata/dmbak/ARCH_FULL_DAMENG_2025_10_23_19_30_00_BP4_A' TO DATABASE '/dmdata/dmdpc/BP4_A/DAMENG/dm.ini' OVERWRITE 2;
--还原BP4_A数据
RESTORE DATABASE '/dmdata/dmdpc/BP4_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_22_21_00_00_BP4_A' USE BAK_MAGIC 1087531106;
RECOVER DATABASE '/dmdata/dmdpc/BP4_A/DAMENG/dm.ini' WITH ARCHIVEDIR '/dmdata/arch' UNTIL TIME '2025-10-22 14:00:00';
RECOVER DATABASE '/dmdata/dmdpc/BP4_A/DAMENG/dm.ini' UPDATE DPC_MAGIC 303765128;
RECOVER DATABASE '/dmdata/dmdpc/BP4_A/DAMENG/dm.ini' update DB_MAGIC;

--还原BP5_A
--还原BP5_A归档
RESTORE ARCHIVE LOG FROM BACKUPSET '/dmdata/dmbak/ARCH_FULL_DAMENG_2025_10_23_19_30_00_BP4_A' TO DATABASE '/dmdata/dmdpc/BP4_A/DAMENG/dm.ini' OVERWRITE 2;
--还原BP5_A数据
RESTORE DATABASE '/dmdata/dmdpc/BP5_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_22_21_00_00_BP5_A' USE BAK_MAGIC 1087531106;
RECOVER DATABASE '/dmdata/dmdpc/BP5_A/DAMENG/dm.ini' WITH ARCHIVEDIR '/dmdata/arch' UNTIL TIME '2025-10-22 14:00:00';
RECOVER DATABASE '/dmdata/dmdpc/BP5_A/DAMENG/dm.ini' UPDATE DPC_MAGIC 303765128;
RECOVER DATABASE '/dmdata/dmdpc/BP5_A/DAMENG/dm.ini' update DB_MAGIC;

--还原BP6_A
--还原BP6_A归档
RESTORE ARCHIVE LOG FROM BACKUPSET '/dmdata/dmbak/ARCH_FULL_DAMENG_2025_10_23_19_30_00_BP4_A' TO DATABASE '/dmdata/dmdpc/BP4_A/DAMENG/dm.ini' OVERWRITE 2;
--还原BP6_A数据
RESTORE DATABASE '/dmdata/dmdpc/BP6_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_22_21_00_00_BP6_A' USE BAK_MAGIC 1087531106;
RECOVER DATABASE '/dmdata/dmdpc/BP6_A/DAMENG/dm.ini' WITH ARCHIVEDIR '/dmdata/arch' UNTIL TIME '2025-10-22 14:00:00';
RECOVER DATABASE '/dmdata/dmdpc/BP6_A/DAMENG/dm.ini' UPDATE DPC_MAGIC 303765128;
RECOVER DATABASE '/dmdata/dmdpc/BP6_A/DAMENG/dm.ini' update DB_MAGIC;

--还原BP7_A
--还原BP7_A归档
RESTORE ARCHIVE LOG FROM BACKUPSET '/dmdata/dmbak/ARCH_FULL_DAMENG_2025_10_23_19_30_00_BP4_A' TO DATABASE '/dmdata/dmdpc/BP4_A/DAMENG/dm.ini' OVERWRITE 2;
--还原BP7_A数据
RESTORE DATABASE '/dmdata/dmdpc/BP7_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_22_21_00_00_BP7_A' USE BAK_MAGIC 1087531106;
RECOVER DATABASE '/dmdata/dmdpc/BP7_A/DAMENG/dm.ini' WITH ARCHIVEDIR '/dmdata/arch' UNTIL TIME '2025-10-22 14:00:00';
RECOVER DATABASE '/dmdata/dmdpc/BP7_A/DAMENG/dm.ini' UPDATE DPC_MAGIC 303765128;
RECOVER DATABASE '/dmdata/dmdpc/BP7_A/DAMENG/dm.ini' update DB_MAGIC;

--还原BP8_A
--还原BP8_A归档
RESTORE ARCHIVE LOG FROM BACKUPSET '/dmdata/dmbak/ARCH_FULL_DAMENG_2025_10_23_19_30_00_BP4_A' TO DATABASE '/dmdata/dmdpc/BP4_A/DAMENG/dm.ini' OVERWRITE 2;
--还原BP8_A数据
RESTORE DATABASE '/dmdata/dmdpc/BP8_A/DAMENG/dm.ini' FROM BACKUPSET '/dmdata/dmbak/DB_DAMENG_INCREMENT_2025_10_22_21_00_00_BP8_A' USE BAK_MAGIC 1087531106;
RECOVER DATABASE '/dmdata/dmdpc/BP8_A/DAMENG/dm.ini' WITH ARCHIVEDIR '/dmdata/arch' UNTIL TIME '2025-10-22 14:00:00';
RECOVER DATABASE '/dmdata/dmdpc/BP8_A/DAMENG/dm.ini' UPDATE DPC_MAGIC 303765128;
RECOVER DATABASE '/dmdata/dmdpc/BP8_A/DAMENG/dm.ini' update DB_MAGIC;



SP_MODIFY_DPC_INSTANCE('MP_A','172.16.63.21','172.16.63.21','','');
SP_MODIFY_DPC_INSTANCE('MP_B','172.16.63.22','172.16.63.22','','');
SP_MODIFY_DPC_INSTANCE('MP_C','172.16.63.23','172.16.63.23','','');