This content has been marked as final. Show 2 replies
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.