注册

备份恢复失败

尚旭波🍟 2025/11/06 254 7

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: dm8_20250506_x86_rh7_64
【操作系统】: Linux dm 5.14.0-570.52.1.el9_6.x86_64 #1 SMP PREEMPT_DYNAMIC Wed Oct 15 13:59:22 UTC 2025 x86_64 x86_64 x86_64 GNU/Linux

【CPU】:
【问题描述】*:
单机版在测试备份还原时报错,

1、还原全量备份版本没有问题, 但是执行 增量还原时 报错

RMAN> RESTORE DATABASE '/home/dmdba/dm_data/software/dmdbms/database/bbx/dm.ini' FROM BACKUPSET '/home/dmdba/dm_data/software/dmdbms/database/bbx/bak/db_bak_20251106002'; RESTORE DATABASE '/home/dmdba/dm_data/software/dmdbms/database/bbx/dm.ini' FROM BACKUPSET '/home/dmdba/dm_data/software/dmdbms/database/bbx/bak/db_bak_20251106002'; [Percent:100.00%][Speed:0.00M/s][Cost:00:00:02][Remaining:00:00:00] restore successfully. time used: 00:00:02.908 RMAN> RECOVER DATABASE '/home/dmdba/dm_data/software/dmdbms/database/bbx/dm.ini' FROM BACKUPSET '/home/dmdba/dm_data/software/dmdbms/database/bbx/bak/incr_back_20251106001'; RECOVER DATABASE '/home/dmdba/dm_data/software/dmdbms/database/bbx/dm.ini' FROM BACKUPSET '/home/dmdba/dm_data/software/dmdbms/database/bbx/bak/incr_back_20251106001'; ==============================Error Stack============================== DM[-8262]:恢复备份集[DB_INCREMENT_20251106_145956_352095] N_MAGIC=219A0FA4 与还原备份集 N_MAGIC=35D166A4 不相同 =======================================================================

2、使用归档还原, 显示 收集到的归档日志不连续

RMAN> RECOVER DATABASE '/home/dmdba/dm_data/software/dmdbms/database/bbx/dm.ini' WITH ARCHIVEDIR '/home/dmdba/dm_data/software/dmdbms/database/bbx/arch' ; RECOVER DATABASE '/home/dmdba/dm_data/software/dmdbms/database/bbx/dm.ini' WITH ARCHIVEDIR '/home/dmdba/dm_data/software/dmdbms/database/bbx/arch'; ==============================Error Stack============================== DM[-718]:收集到的归档日志不连续 ======================================================================= RMAN>

3、备份过程如下:

BACKUP DATABASE BACKUPSET '/home/dmdba/dm_data/software/dmdbms/database/bbx/bak/db_bak_20251106002'; SHOW BACKUPSET '/home/dmdba/dm_data/software/dmdbms/database/bbx/bak/db_bak_20251106002'; |45869 |3246 |46225 2025-11-06 14:48:52 insert into bbx5 (id, name,age,create_time) values (11,'wangwu',23,'2025-10-30 09:53:10') , (12,'zhaoliu',24,'2025-10-30 09:54:10'); BACKUP DATABASE INCREMENT WITH BACKUPDIR '/home/dmdba/dm_data/software/dmdbms/database/bbx/bak' BACKUPSET '/home/dmdba/dm_data/software/dmdbms/database/bbx/bak/incr_back_20251106001'; # 查看备份链 SELECT backup_name, backup_type, begin_time, end_time, base_name, db_magic FROM v$backupset ORDER BY begin_time; insert into bbx5 (id, name,age,create_time) values (21,'wangwu',23,'2025-10-30 09:53:10') , (22,'zhaoliu',24,'2025-10-30 09:54:10'); BACKUP DATABASE INCREMENT WITH BACKUPDIR '/home/dmdba/dm_data/software/dmdbms/database/bbx/bak' BACKUPSET '/home/dmdba/dm_data/software/dmdbms/database/bbx/bak/incr_back_20251106002'; insert into bbx5 (id, name,age,create_time) values (31,'wangwu',23,'2025-10-30 09:53:10') , (32,'zhaoliu',24,'2025-10-30 09:54:10'); BACKUP ARCHIVE LOG ALL BACKUPSET '/home/dmdba/dm_data/software/dmdbms/database/bbx/bak/arch_bak_20251106001'; insert into bbx5 (id, name,age,create_time) values (41,'wangwu',23,'2025-10-30 09:53:10') , (42,'zhaoliu',24,'2025-10-30 09:54:10'); BACKUP ARCHIVE LOG ALL BACKUPSET '/home/dmdba/dm_data/software/dmdbms/database/bbx/bak/arch_bak_20251106002'; insert into bbx5 (id, name,age,create_time) values (51,'wangwu',23,'2025-10-30 09:53:10') , (52,'zhaoliu',24,'2025-10-30 09:54:10'); 15:21

4、导出的备份链信息如下

INSERT INTO "SYS"."V$BACKUPSET" ("backup_name","DEVICE_TYPE","BACKUP_ID","PARENT_ID","BACKUP_NAME","BACKUP_PATH","TYPE","LEVEL","RANGE#","OBJECT_NAME","OBJECT_ID","BASE_NAME","BACKUP_TIME","DESC#","ENCRYPT_TYPE","COMPRESS_LEVEL","WITHOUT_LOG","USE_PWR","PKG_SIZE","BEGIN_LSN","END_LSN","BKP_NUM","DBF_NUM","PARALLEL_NUM","BAKSET_TYPE","MPP_FLAG","MIN_TRX_START_LSN","MIN_EXEC_VER","CUMULATIVE","MIN_DCT_VER","DDL_CLONE","BAK_MAGIC","VERSION","SUB_VERSION","BAKSET_MAGIC" ) VALUES ('DB_FULL_20251106_144846_915596','DISK',902915748,-1,'DB_FULL_20251106_144846_915596','/home/dmdba/dm_data/software/dmdbms/database/bbx/bak/db_bak_20251106002',0,0,1,'bbx',-1,'','2025-11-06 14:48:52.082772','',0,0,0,0,67108864,45869,46225,2,4,1,0,0,0,134283815,0,4,0,0,16394,14,902915748); INSERT INTO "SYS"."V$BACKUPSET" ("backup_name","DEVICE_TYPE","BACKUP_ID","PARENT_ID","BACKUP_NAME","BACKUP_PATH","TYPE","LEVEL","RANGE#","OBJECT_NAME","OBJECT_ID","BASE_NAME","BACKUP_TIME","DESC#","ENCRYPT_TYPE","COMPRESS_LEVEL","WITHOUT_LOG","USE_PWR","PKG_SIZE","BEGIN_LSN","END_LSN","BKP_NUM","DBF_NUM","PARALLEL_NUM","BAKSET_TYPE","MPP_FLAG","MIN_TRX_START_LSN","MIN_EXEC_VER","CUMULATIVE","MIN_DCT_VER","DDL_CLONE","BAK_MAGIC","VERSION","SUB_VERSION","BAKSET_MAGIC" ) VALUES ('DB_INCREMENT_20251106_145956_352095','DISK',563744676,-1,'DB_INCREMENT_20251106_145956_352095','/home/dmdba/dm_data/software/dmdbms/database/bbx/bak/incr_back_20251106001',1,0,1,'bbx',-1,'DB_FULL_20251106_144846_915596','2025-11-06 15:00:05.702463','',0,0,0,0,67108864,46239,46285,2,4,1,0,0,0,134283815,0,4,0,0,16394,14,563744676); INSERT INTO "SYS"."V$BACKUPSET" ("backup_name","DEVICE_TYPE","BACKUP_ID","PARENT_ID","BACKUP_NAME","BACKUP_PATH","TYPE","LEVEL","RANGE#","OBJECT_NAME","OBJECT_ID","BASE_NAME","BACKUP_TIME","DESC#","ENCRYPT_TYPE","COMPRESS_LEVEL","WITHOUT_LOG","USE_PWR","PKG_SIZE","BEGIN_LSN","END_LSN","BKP_NUM","DBF_NUM","PARALLEL_NUM","BAKSET_TYPE","MPP_FLAG","MIN_TRX_START_LSN","MIN_EXEC_VER","CUMULATIVE","MIN_DCT_VER","DDL_CLONE","BAK_MAGIC","VERSION","SUB_VERSION","BAKSET_MAGIC" ) VALUES ('DB_INCREMENT_20251106_150604_737854','DISK',1142134828,-1,'DB_INCREMENT_20251106_150604_737854','/home/dmdba/dm_data/software/dmdbms/database/bbx/bak/incr_back_20251106002',1,0,1,'bbx',-1,'DB_INCREMENT_20251106_145956_352095','2025-11-06 15:06:09.817445','',0,0,0,0,67108864,46291,46374,2,4,1,0,0,0,134283815,0,4,0,0,16394,14,1142134828); INSERT INTO "SYS"."V$BACKUPSET" ("backup_name","DEVICE_TYPE","BACKUP_ID","PARENT_ID","BACKUP_NAME","BACKUP_PATH","TYPE","LEVEL","RANGE#","OBJECT_NAME","OBJECT_ID","BASE_NAME","BACKUP_TIME","DESC#","ENCRYPT_TYPE","COMPRESS_LEVEL","WITHOUT_LOG","USE_PWR","PKG_SIZE","BEGIN_LSN","END_LSN","BKP_NUM","DBF_NUM","PARALLEL_NUM","BAKSET_TYPE","MPP_FLAG","MIN_TRX_START_LSN","MIN_EXEC_VER","CUMULATIVE","MIN_DCT_VER","DDL_CLONE","BAK_MAGIC","VERSION","SUB_VERSION","BAKSET_MAGIC" ) VALUES ('ARCH_FULL_20251106_151618_012444','DISK',50363192,-1,'ARCH_FULL_20251106_151618_012444','/home/dmdba/dm_data/software/dmdbms/database/bbx/bak/arch_bak_20251106001',3,0,4,'bbx',-1,'','2025-11-06 15:16:23.001357','',0,0,1,0,67108864,45864,46463,1,1,1,0,0,0,134283815,0,4,0,0,16394,14,50363192); INSERT INTO "SYS"."V$BACKUPSET" ("backup_name","DEVICE_TYPE","BACKUP_ID","PARENT_ID","BACKUP_NAME","BACKUP_PATH","TYPE","LEVEL","RANGE#","OBJECT_NAME","OBJECT_ID","BASE_NAME","BACKUP_TIME","DESC#","ENCRYPT_TYPE","COMPRESS_LEVEL","WITHOUT_LOG","USE_PWR","PKG_SIZE","BEGIN_LSN","END_LSN","BKP_NUM","DBF_NUM","PARALLEL_NUM","BAKSET_TYPE","MPP_FLAG","MIN_TRX_START_LSN","MIN_EXEC_VER","CUMULATIVE","MIN_DCT_VER","DDL_CLONE","BAK_MAGIC","VERSION","SUB_VERSION","BAKSET_MAGIC" ) VALUES ('ARCH_FULL_20251106_152009_859711','DISK',807244952,-1,'ARCH_FULL_20251106_152009_859711','/home/dmdba/dm_data/software/dmdbms/database/bbx/bak/arch_bak_20251106002',3,0,4,'bbx',-1,'','2025-11-06 15:20:14.707901','',0,0,1,0,67108864,46464,46552,1,1,1,0,0,0,134283815,0,4,0,0,16394,14,807244952);

5、 检查 备份文件 没有问题

RMAN> CHECK BACKUPSET '/home/dmdba/dm_data/software/dmdbms/database/bbx/bak/arch_bak_20251106001'; CHECK BACKUPSET '/home/dmdba/dm_data/software/dmdbms/database/bbx/bak/arch_bak_20251106001'; [Percent:100.00%][Speed:0.00M/s][Cost:00:00:00][Remaining:00:00:00] check backupset successfully. time used: 182.148(ms) RMAN> CHECK BACKUPSET '/home/dmdba/dm_data/software/dmdbms/database/bbx/bak/arch_bak_20251106002'; CHECK BACKUPSET '/home/dmdba/dm_data/software/dmdbms/database/bbx/bak/arch_bak_20251106002'; [Percent:100.00%][Speed:0.00M/s][Cost:00:00:00][Remaining:00:00:00] check backupset successfully. time used: 174.338(ms)
回答 0
暂无回答
扫一扫
联系客服