This content has been marked as final. Show 2 replies
Does RMAN use online redo logs during restore/recover?Yes, if it finds them.
I want to able to backup/restore a database to the time when I issued backup archivelog allSpecify SET UNTIL SEQUENCE or SET UNTIL TIME before the RECOVER
Hemant K Chitale
Hi my friend,
restore database: means take the files from backup and put it in their location.
recover database: means apply all changes from the time of backup until current time using the archivelogs and online redologs (complete recovery).
that is why you saw the updated data.
but if you want to not see your updated data you have to use incomplete recovery (before execute the your update statement) using the following commands:
RMAN> restore database; --- to restore datafile
RMAN> recover database until time to_timestamp(2012-04-29:11:59:00, 'YYYY-MM-DD:HH24:MI:SS'); -- the time of update statement.
RMAN> alter database open resetlogs;
but again my friend be careful when you do that, because it will undo all changes by all users.