DSC+异步备库备份还原测试

1 结果汇总

编号	备份方式	是否需要修改模式	结果	日志
1	只冷备主库，还原两库	是	成功	正常
2	先热备主库再热备备库，分别还原	否	失败	报错：-718
3	先热备备库再热备主库，分别还原	否	失败	报错：-718
4	只热备主库，还原两库	是	成功	正常
5	只热备备库，还原两库	是	成功	正常

2 环境准备

IP	操作系统	配置	实例名	数据库目录	版本
192.168.110.92	ky10.x86_64	192c512G	DSC0	/data/ssd1/sunhui/dmdbms	03134284172-20240617-231907-20093 Pack6
192.168.110.90	ky10.x86_64	192c256G	DSC1
192.168.110.94	ky10.x86_64	192c1T	DSC_STANDBY1

提前热备主库，用于恢复

backup database full backupset '/data/ssd1/sunhui/bak_test/bak_hot_20250912_0' parallel 4;
scp -r /data/ssd1/sunhui/bak_test/bak_hot_20250912_0 sunhui@192.168.110.94:/data/ssd1/sunhui/bak_test/

3 测试过程

3.1 主库冷备，还原两库（成功）

主库冷备

./dmrman ctlstmt="backup database '/data/ssd1/sunhui/DSC/dsc_config/DSC0/dm.ini' full backupset '/data/ssd1/sunhui/bak_test/bak_cold_20250912_1' parallel 4 " dcr_ini=/data/ssd1/sunhui/DSC/dsc_config/DSC0/dmdcr0.ini

（备库不能冷备，会显示不支持该操作）

./dmrman ctlstmt="backup database '/data/ssd1/sunhui/DSC_STANDBY01/dm.ini' full backupset '/data/ssd1/sunhui/bak_test/bak_cold_20250912_1' parallel 4 "
[-2015]:STANDBY模式下不支持该操作

拷贝

scp -r /data/ssd1/sunhui/bak_test/bak_cold_20250912_1 sunhui@192.168.110.94:/data/ssd1/sunhui/bak_test/

还原

DSC
./dmrman ctlstmt="restore database '/data/ssd1/sunhui/DSC/dsc_config/DSC0/dm.ini' from backupset '/data/ssd1/sunhui/bak_test/bak_cold_20250912_1'" dcr_ini=/data/ssd1/sunhui/DSC/dsc_config/DSC0/dmdcr0.ini
./dmrman ctlstmt="recover database '/data/ssd1/sunhui/DSC/dsc_config/DSC0/dm.ini' from backupset '/data/ssd1/sunhui/bak_test/bak_cold_20250912_1'" dcr_ini=/data/ssd1/sunhui/DSC/dsc_config/DSC0/dmdcr0.ini
./dmrman ctlstmt="recover database '/data/ssd1/sunhui/DSC/dsc_config/DSC0/dm.ini' update db_magic" dcr_ini=/data/ssd1/sunhui/DSC/dsc_config/DSC0/dmdcr0.ini 

异步备库
./dmrman ctlstmt="restore database '/data/ssd1/sunhui/DSC_STANDBY01/dm.ini' from backupset '/data/ssd1/sunhui/bak_test/bak_cold_20250912_1'"
./dmrman ctlstmt="recover database '/data/ssd1/sunhui/DSC_STANDBY01/dm.ini' from backupset '/data/ssd1/sunhui/bak_test/bak_cold_20250912_1'"
./dmrman ctlstmt="recover database '/data/ssd1/sunhui/DSC_STANDBY01/dm.ini' update db_magic"

启动

启动主库Server
启动备库Server

备库：
./disql
SQL> sp_set_para_value(1,'ALTER_MODE_STATUS',1);
SQL> alter database standby;
SQL> sp_set_para_value(1,'ALTER_MODE_STATUS',0);

启动主库Watcher
启动备库Watcher

结果：成功

3.2 先热备主库再热备备库，分别还原（失败）

分别热备

./disql
主库热备
backup database full backupset '/data/ssd1/sunhui/bak_test/bak_hot_20250912_2' parallel 4;
备库热备
backup database full backupset '/data/ssd1/sunhui/bak_test/bak_hot_20250912_2' parallel 4;

停止数据库

停止备库Watcher
停止主库Watcher
停止主库Service
停止备库Service

还原

DSC
./dmrman ctlstmt="restore database '/data/ssd1/sunhui/DSC/dsc_config/DSC0/dm.ini' from backupset '/data/ssd1/sunhui/bak_test/bak_hot_20250912_2'" dcr_ini=/data/ssd1/sunhui/DSC/dsc_config/DSC0/dmdcr0.ini
./dmrman ctlstmt="recover database '/data/ssd1/sunhui/DSC/dsc_config/DSC0/dm.ini' from backupset '/data/ssd1/sunhui/bak_test/bak_hot_20250912_2'" dcr_ini=/data/ssd1/sunhui/DSC/dsc_config/DSC0/dmdcr0.ini
./dmrman ctlstmt="recover database '/data/ssd1/sunhui/DSC/dsc_config/DSC0/dm.ini' update db_magic" dcr_ini=/data/ssd1/sunhui/DSC/dsc_config/DSC0/dmdcr0.ini 

异步备库
./dmrman ctlstmt="restore database '/data/ssd1/sunhui/DSC_STANDBY01/dm.ini' from backupset '/data/ssd1/sunhui/bak_test/bak_hot_20250912_2'"
./dmrman ctlstmt="recover database '/data/ssd1/sunhui/DSC_STANDBY01/dm.ini' from backupset '/data/ssd1/sunhui/bak_test/bak_hot_20250912_2'"
./dmrman ctlstmt="recover database '/data/ssd1/sunhui/DSC_STANDBY01/dm.ini' update db_magic"

启动

启动主库Server
启动备库Server
启动主库Watcher
启动备库Watcher

结果：失败

日志报错：

2025-09-12 11:06:17.028 [ERROR] database P0002274346 T0000000000002274497  rarch_rpkg_load failed, ep_seqno(0), ep->apply_lsn(44366) is not equal to rpkg->max_lsn(44419) for the same g_seqno(5426)
2025-09-12 11:06:17.028 [INFO] database P0002274346 T0000000000002274497  rarch_ep_init, ep->prev_term_id change from 0 to 0.
2025-09-12 11:06:17.028 [INFO] database P0002274346 T0000000000002274497  rarch_ep_init, code:-718, dsc_seqno:0, begin_pkg_seqno:5426, load ep pkg info[db_magic:0x57c2d540, dsc_seqno:0, pkg_seqno:5426, min_lsn:44416, max_lsn:44419], prev_term_id:0!
2025-09-12 11:06:17.028 [ERROR] database P0002274346 T0000000000002274497  rarch_sync_process, rarch_ep_init failed, code=-718
2025-09-12 11:06:17.028 [INFO] database P0002274346 T0000000000002274497  notify standby to cancel apply, code:-718 !!!
2025-09-12 11:06:17.028 [ERROR] database P0002274346 T0000000000002274497  rarch_local_arch_send, rarch_sync_process failed, code:-718!
2025-09-12 11:06:17.028 [INFO] database P0002274346 T0000000000002274497  Change DSC_STANDBY1 arch status from ASYNC_SEND to INVALID, arch_type[ASYNC]
2025-09-12 11:06:17.964 [INFO] database P0002274346 T0000000000002274495  Change DSC_STANDBY1 arch status from INVALID to ASYNC_SEND, arch_type[ASYNC]
2025-09-12 11:06:17.980 [INFO] database P0002274346 T0000000000002274497  rarch_sync_process from mal_site(2): n_apply_ep=2, apply_seq_arr[0]=5426, apply_lsn_arr[0]=44366
2025-09-12 11:06:17.980 [INFO] database P0002274346 T0000000000002274497  rarch_sync_process from mal_site(2): n_apply_ep=2, apply_seq_arr[1]=2540, apply_lsn_arr[1]=44334
2025-09-12 11:06:17.988 [INFO] database P0002274346 T0000000000002274497  rarch_ep_init begin, dsc_seqno:0, begin_pkg_seqno:5426, max_pkg_seqno:5428, rfil_off:4096, adjust_flag:0, rfil:+DMARCH/ARCH/DSC0/arch/ARCHIVE_LOCAL1_0x57C2D540_EP0_2025-09-12_11-03-44.log!

3.3 先热备备库再热备主库，分别还原（失败）

分别热备

./disql
备库热备
backup database full backupset '/data/ssd1/sunhui/bak_test/bak_hot_20250912_3' parallel 4;
主库热备
backup database full backupset '/data/ssd1/sunhui/bak_test/bak_hot_20250912_3' parallel 4;

停止数据库

停止备库Watcher
停止主库Watcher
停止主库Service
停止备库Service

还原

DSC
./dmrman ctlstmt="restore database '/data/ssd1/sunhui/DSC/dsc_config/DSC0/dm.ini' from backupset '/data/ssd1/sunhui/bak_test/bak_hot_20250912_3'" dcr_ini=/data/ssd1/sunhui/DSC/dsc_config/DSC0/dmdcr0.ini
./dmrman ctlstmt="recover database '/data/ssd1/sunhui/DSC/dsc_config/DSC0/dm.ini' from backupset '/data/ssd1/sunhui/bak_test/bak_hot_20250912_3'" dcr_ini=/data/ssd1/sunhui/DSC/dsc_config/DSC0/dmdcr0.ini
./dmrman ctlstmt="recover database '/data/ssd1/sunhui/DSC/dsc_config/DSC0/dm.ini' update db_magic" dcr_ini=/data/ssd1/sunhui/DSC/dsc_config/DSC0/dmdcr0.ini

异步备库
./dmrman ctlstmt="restore database '/data/ssd1/sunhui/DSC_STANDBY01/dm.ini' from backupset '/data/ssd1/sunhui/bak_test/bak_hot_20250912_3'"
./dmrman ctlstmt="recover database '/data/ssd1/sunhui/DSC_STANDBY01/dm.ini' from backupset '/data/ssd1/sunhui/bak_test/bak_hot_20250912_3'"
./dmrman ctlstmt="recover database '/data/ssd1/sunhui/DSC_STANDBY01/dm.ini' update db_magic"

启动

启动主库Server
启动备库Server
启动主库Watcher
启动备库Watcher

结果：失败

2025-09-12 11:34:38.516 [INFO] database P0002290875 T0000000000002291015  Change DSC_STANDBY1 arch status from INVALID to ASYNC_SEND, arch_type[ASYNC]
2025-09-12 11:34:38.531 [INFO] database P0002290875 T0000000000002291017  rarch_sync_process from mal_site(2): n_apply_ep=2, apply_seq_arr[0]=5426, apply_lsn_arr[0]=44440
2025-09-12 11:34:38.531 [INFO] database P0002290875 T0000000000002291017  rarch_sync_process from mal_site(2): n_apply_ep=2, apply_seq_arr[1]=2541, apply_lsn_arr[1]=44461
2025-09-12 11:34:38.540 [ERROR] database P0002290875 T0000000000002291017  rafil_collect_by_dsc_seqno failed, EP[0] rfil(+DMARCH/ARCH/DSC0/arch/ARCHIVE_LOCAL1_0x58C09C04_EP0_2025-09-12_11-32-15.log)->arch_seq(5433) > begin_seq(5427), buf4_restore(2), return -718.
2025-09-12 11:34:38.540 [ERROR] database P0002290875 T0000000000002291017  rarch_sync_process, rafil_collect_by_dsc_seqno failed, code=-718
2025-09-12 11:34:38.540 [ERROR] database P0002290875 T0000000000002291017  rarch_local_arch_send, rarch_sync_process failed, code:-718!
2025-09-12 11:34:38.540 [INFO] database P0002290875 T0000000000002291017  Change DSC_STANDBY1 arch status from ASYNC_SEND to INVALID, arch_type[ASYNC]

3.4 只热备主库，还原两库（成功）

热备主库（使用初始备份还原，不再另外备份）

backup database full backupset '/data/ssd1/sunhui/bak_test/bak_hot_20250912_0' parallel 4;

停止数据库

停止备库Watcher
停止主库Watcher
停止主库Service
停止备库Service

拷贝

scp -r /data/ssd1/sunhui/bak_test/bak_hot_20250912_0 sunhui@192.168.110.94:/data/ssd1/sunhui/bak_test/

还原

DSC
./dmrman ctlstmt="restore database '/data/ssd1/sunhui/DSC/dsc_config/DSC0/dm.ini' from backupset '/data/ssd1/sunhui/bak_test/bak_hot_20250912_0'" dcr_ini=/data/ssd1/sunhui/DSC/dsc_config/DSC0/dmdcr0.ini
./dmrman ctlstmt="recover database '/data/ssd1/sunhui/DSC/dsc_config/DSC0/dm.ini' from backupset '/data/ssd1/sunhui/bak_test/bak_hot_20250912_0'" dcr_ini=/data/ssd1/sunhui/DSC/dsc_config/DSC0/dmdcr0.ini
./dmrman ctlstmt="recover database '/data/ssd1/sunhui/DSC/dsc_config/DSC0/dm.ini' update db_magic" dcr_ini=/data/ssd1/sunhui/DSC/dsc_config/DSC0/dmdcr0.ini

异步备库
./dmrman ctlstmt="restore database '/data/ssd1/sunhui/DSC_STANDBY01/dm.ini' from backupset '/data/ssd1/sunhui/bak_test/bak_hot_20250912_0'"
./dmrman ctlstmt="recover database '/data/ssd1/sunhui/DSC_STANDBY01/dm.ini' from backupset '/data/ssd1/sunhui/bak_test/bak_hot_20250912_0'"
./dmrman ctlstmt="recover database '/data/ssd1/sunhui/DSC_STANDBY01/dm.ini' update db_magic"

启动

启动主库Server
启动备库Server

备库：
./disql
SQL> sp_set_para_value(1,'ALTER_MODE_STATUS',1);
SQL> alter database standby;
SQL> sp_set_para_value(1,'ALTER_MODE_STATUS',0);

启动主库Watcher
启动备库Watcher

结果：成功

2025-09-12 11:48:28.023 [INFO] database P0002298192 T0000000000002298377  rarch_ep_init begin, has no rpkg to send, dsc_seqno:0, begin_pkg_seqno:5426, max_pkg_seqno:5426, rfil free[49152], last_async_off[32768], last_async_plen[16384], rfil name[+DMARCH/ARCH/DSC0/arch/ARCHIVE_LOCAL1_0x77078D0E_EP0_2025-09-12_11-47-48.log], return EC_EMPTY!
2025-09-12 11:48:28.024 [INFO] database P0002298192 T0000000000002298377  rarch_ep_init begin, has no rpkg to send, dsc_seqno:1, begin_pkg_seqno:2541, max_pkg_seqno:2541, rfil free[24576], last_async_off[8192], last_async_plen[16384], rfil name[+DMARCH/ARCH/DSC1/arch/ARCHIVE_LOCAL1_0x77078D0E_EP1_2025-09-12_11-47-48.log], return EC_EMPTY!
2025-09-12 11:48:28.024 [INFO] database P0002298192 T0000000000002298377  rarch_sync_process, begin to send arch, db_magic:0x77078d0e.
2025-09-12 11:48:28.024 [INFO] database P0002298192 T0000000000002298377  rarch_sync_process, all rlog_pkg send over, rarch_apply_wait!
2025-09-12 11:48:28.034 [INFO] database P0002298192 T0000000000002298377  rarch_sync_process, all rlog_pkg send over, rarch_apply_wait success, site_seq:2, reach_until_time:0!
2025-09-12 11:48:28.035 [INFO] database P0002298192 T0000000000002298377  Change DSC_STANDBY1 arch status from ASYNC_SEND to INVALID, arch_type[ASYNC]
2025-09-12 11:48:28.304 [INFO] database P0002298192 T0000000000002298375  Change DSC_STANDBY1 arch status from INVALID to ASYNC_SEND, arch_type[ASYNC]
2025-09-12 11:48:28.325 [INFO] database P0002298192 T0000000000002298377  rarch_sync_process from mal_site(2): n_apply_ep=2, apply_seq_arr[0]=5426, apply_lsn_arr[0]=44440
2025-09-12 11:48:28.325 [INFO] database P0002298192 T0000000000002298377  rarch_sync_process from mal_site(2): n_apply_ep=2, apply_seq_arr[1]=2541, apply_lsn_arr[1]=44461

3.5 只热备备库，还原两库（成功）

热备备库

备库热备
backup database full backupset '/data/ssd1/sunhui/bak_test/bak_hot_20250912_5' parallel 4;

停止数据库

停止备库Watcher
停止主库Watcher
停止主库Service
停止备库Service

拷贝

scp -r /data/ssd1/sunhui/bak_test/bak_hot_20250912_5 sunhui@192.168.110.92:/data/ssd1/sunhui/bak_test/

还原

DSC
./dmrman ctlstmt="restore database '/data/ssd1/sunhui/DSC/dsc_config/DSC0/dm.ini' from backupset '/data/ssd1/sunhui/bak_test/bak_hot_20250912_5'" dcr_ini=/data/ssd1/sunhui/DSC/dsc_config/DSC0/dmdcr0.ini
./dmrman ctlstmt="recover database '/data/ssd1/sunhui/DSC/dsc_config/DSC0/dm.ini' from backupset '/data/ssd1/sunhui/bak_test/bak_hot_20250912_5'" dcr_ini=/data/ssd1/sunhui/DSC/dsc_config/DSC0/dmdcr0.ini
./dmrman ctlstmt="recover database '/data/ssd1/sunhui/DSC/dsc_config/DSC0/dm.ini' update db_magic" dcr_ini=/data/ssd1/sunhui/DSC/dsc_config/DSC0/dmdcr0.ini

异步备库
./dmrman ctlstmt="restore database '/data/ssd1/sunhui/DSC_STANDBY01/dm.ini' from backupset '/data/ssd1/sunhui/bak_test/bak_hot_20250912_5'"
./dmrman ctlstmt="recover database '/data/ssd1/sunhui/DSC_STANDBY01/dm.ini' from backupset '/data/ssd1/sunhui/bak_test/bak_hot_20250912_5'"
./dmrman ctlstmt="recover database '/data/ssd1/sunhui/DSC_STANDBY01/dm.ini' update db_magic"

启动

启动主库Server
启动备库Server

主库：
./disql
SQL> sp_set_para_value(1,'ALTER_MODE_STATUS',1);
SQL> alter database primary;
SQL> sp_set_para_value(1,'ALTER_MODE_STATUS',0);

启动主库Watcher
启动备库Watcher

结果：成功

DSC+异步备库 备份还原测试

1 结果汇总

2 环境准备

3 测试过程

3.1 主库冷备，还原两库（成功）

3.2 先热备主库再热备备库，分别还原（失败）

3.3 先热备备库再热备主库，分别还原（失败）

3.4 只热备主库，还原两库（成功）

3.5 只热备备库，还原两库（成功）

作者

DSC+异步备库备份还原测试