注册

备份数据恢复之后还存在备份时没有表

Poisonous 2024/06/07 472 1

RMAN> RESTORE DATABASE 'D:\dm8\data\DAMENG\dm.ini' FROM BACKUPSET 'C:\Users\52888\Desktop\test\2024-06-06_17-59.dmp';
RESTORE DATABASE 'D:\dm8\data\DAMENG\dm.ini' FROM BACKUPSET 'C:\Users\52888\Desktop\test\2024-06-06_17-59.dmp';
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:03.366
RMAN> RECOVER DATABASE 'D:\dm8\data\DAMENG\dm.ini' WITH ARCHIVEDIR 'D:\dm8\data\gd';
RECOVER DATABASE 'D:\dm8\data\DAMENG\dm.ini' WITH ARCHIVEDIR 'D:\dm8\data\gd';
Database mode = 2, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]'s cur_lsn[52841], file_lsn[52841]
[Percent:100.00%][Speed:0.00PKG/s][Cost:00:00:00][Remaining:00:00:00]
recover successfully!
time used: 638.382(ms)
RMAN> RECOVER DATABASE 'D:\dm8\data\DAMENG\dm.ini' UPDATE DB_MAGIC;
RECOVER DATABASE 'D:\dm8\data\DAMENG\dm.ini' UPDATE DB_MAGIC;
Database mode = 2, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]'s cur_lsn[53453], file_lsn[53453]
recover successfully!
time used: 00:00:01.269

提示备份还原成功,但是数据库还有备份之后的数据,备份时没有这些数据
image.png

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