增量+归档恢复，归档部分未恢复

为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:8
【操作系统】：
【CPU】:
【问题描述】*：全量+增量+归档恢复数据，归档中数据未恢复，只回复到最后一次增量备份。
5236库备份，5237库中进行恢复
备份文件：
/dm/2023-11-10_db_full
/dm/2023-11-10_db_inc01
/dm/2023-11-10_db_inc02
/dm/2023-11-10_db_inc03
恢复命令：
restore database '/dm/5237/dm.ini' from backupset '/dm/2023-11-10_db_inc03' with backupdir '/dm/2023-11-10_db_full'
recover database '/dm/5237/dm.ini' from backupset '/dm/2023-11-10_db_inc03';
recover database '/dm/5237/dm.ini' with archivedir '/dm/5237/dmarch/';
recover database '/dm/5237/dm.ini' update db_magic;

结果：
5236中有2000条
5237中只有1000条
15:40:58 SYSDBA@LOCALHOST:5237>select count(*) from t4;

COUNT(*)

1000

归档文件是dmdba用户从5236目录中，拷贝到5237目录中的

回答 0

暂无回答

喜欢就是喜欢

恢复命令执行后是否确实的恢复成功？
注意事项：
1，备份集还原之前先校验是否有效。
check backupset '/dmdata/dmbak/backupfull';
2，注意备份集或归档日志属组权限等，是否属于数据库安装用户dmdba。（如果没有安装用户忽略此条）
3，通过归档恢复时，注意归档日志必须要包含备份集备份时间至恢复时间点所有的归档，不可缺少。
数据库物理备份还原文档：
https://eco.dameng.com/document/dm/zh-cn/ops/physical-backup-restore.html

发布于 2023/11/10 18:35

喜欢就是喜欢

测试了命令是没有问题的，应该是你操作不当，重新还原恢复试试。

[dmdba@localhost bin]$ ./dmrman
dmrman V8
RMAN> 
RMAN> 
RMAN> restore database '/home/dmdba/dmdbms/data/dmdb/dm.ini' from backupset '/home/dmdba/dmdbms/data/dmbak/backupfull_20231110' with backupdir '/home/dmdba/dmdbms/data/dmbak/backupfull_20230817';
restore database '/home/dmdba/dmdbms/data/dmdb/dm.ini' from backupset '/home/dmdba/dmdbms/data/dmbak/backupfull_20231110' with backupdir '/home/dmdba/dmdbms/data/dmbak/backupfull_20230817';
file dm.key not found, use default license!
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
[Percent:100.00%][Speed:0.00M/s][Cost:00:00:02][Remaining:00:00:00]                                 
restore successfully.
time used: 00:00:02.383
RMAN> recover database '/home/dmdba/dmdbms/data/dmdb/dm.ini' from backupset '/home/dmdba/dmdbms/data/dmbak/backupfull_20231110';
recover database '/home/dmdba/dmdbms/data/dmdb/dm.ini' from backupset '/home/dmdba/dmdbms/data/dmbak/backupfull_20231110';
Database mode = 0, oguid = 450000
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]'s cur_lsn[79887], file_lsn[79887]
备份集[/home/dmdba/dmdbms/data/dmbak/backupfull_20231110]备份过程中未产生日志
recover successfully!
time used: 235.523(ms)
RMAN> recover database '/home/dmdba/dmdbms/data/dmdb/dm.ini' with archivedir '/home/dmdba/dmdbms/data/arch';
recover database '/home/dmdba/dmdbms/data/dmdb/dm.ini' with archivedir '/home/dmdba/dmdbms/data/arch';
Database mode = 0, oguid = 450000
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]'s cur_lsn[79887], file_lsn[79887]
[Percent:100.00%][Speed:11.96PKG/s][Cost:00:00:01][Remaining:00:00:00]                              
recover successfully!
time used: 00:00:01.990
RMAN> recover database '/home/dmdba/dmdbms/data/dmdb/dm.ini' update db_magic;
recover database '/home/dmdba/dmdbms/data/dmdb/dm.ini' update db_magic;
Database mode = 0, oguid = 450000
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]'s cur_lsn[85088], file_lsn[85088]
recover successfully!
time used: 00:00:01.004
RMAN> exit
time used: 0.334(ms)
[dmdba@localhost bin]$ ./DmServiceDW start
Starting DmServiceDW:                                      [ OK ]
[dmdba@localhost bin]$ ./disql SYSDBA/SYSDBA

服务器[LOCALHOST:5236]:处于普通打开状态
登录使用时间 : 1.530(ms)
disql V8
SQL> select * from TEST_01;              

行号     ID          NAME     
---------- ----------- ---------
1          1           李子柒
2          2           李子数
3          2           李蓝牙

已用时间: 3.111(毫秒). 执行号:500.
SQL> exit
[dmdba@localhost bin]$

发布于 2023/11/10 18:55

彴约

不太确定，但是看你的描述感觉是，归档没有识别？
可以试一下新建一个新的目录存放原先5236的归档文件，
与原先5237的归档分开存放

发布于 2023/11/14 16:49