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
提示备份还原成功,但是数据库还有备份之后的数据,备份时没有这些数据
你检查一下是先删除的表再进行备份的,还是先备份再进行删除的