注册

求助:表空间备份,还原恢复后,表的数据未恢复。

2023/04/14 1421 2

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:linux 7
【CPU】:
【问题描述】*:DM管理工具备份表空间后,删除属于该表空间的表table_1内部分数据,备份前6条数据,删除后3条数据,然后执行表空间备份还原后,表table_1还是3条数据,并没有恢复到备份的时候,怎么回事呀?
下面是执行的的操作命令:
RMAN> restore database '/u01/dm8/dmdata/DMDB/dm.ini' tablespace "systesttbs" from backupset '/u01/dm8/dmdata/DMDB/bak/TS_systesttbs_FULL_2023_04_14_14_49_54';
restore database '/u01/dm8/dmdata/DMDB/dm.ini' tablespace "systesttbs" from backupset '/u01/dm8/dmdata/DMDB/bak/TS_systesttbs_FULL_2023_04_14_14_49_54';
Database mode = 0, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]'s cur_lsn[52674], file_lsn[52674]
[Percent:100.00%][Speed:0.00M/s][Cost:00:00:02][Remaining:00:00:00]
restore successfully.
time used: 00:00:02.522
RMAN> recover database '/u01/dm8/dmdata/DMDB/dm.ini' tablespace "systesttbs";
recover database '/u01/dm8/dmdata/DMDB/dm.ini' tablespace "systesttbs";
Database mode = 0, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]'s cur_lsn[53582], file_lsn[53582]
dres_backupset_recover_ts bgein.
[Percent:100.00%][Speed:0.00PKG/s][Cost:00:00:00][Remaining:00:00:00]
dres_backupset_recover_ts end.
recover successfully.
time used: 590.942(ms)
RMAN>

回答 0
暂无回答
扫一扫
联系客服