为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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】:
【问题描述】*:
单机版在测试备份还原时报错,
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 不相同
=======================================================================
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>
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
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);
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)
这样恢复呢?
./dmrman
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/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/db_bak_20251106002';
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' update db_magic;

你的这个增量备份语句是怎么执行的?
增量备份是基于作业调度执行的吗?
归档备份的语句以及增量备份的语句也可以发一下。