This content has been marked as final. Show 6 replies
851707 wrote:I think you mean point in time recovery via RMAN, if it is, refer to the oracle documentation
what is this set until sysdate-<some number>
i am confusing with this sysdate and its number. could you please explain me about this sys date and how and upto how much data we can recover using this sys date.
An example :
Today is 20-April. I know that there were some very bad updates to the database because of a wrong application schema and code update. Those changes cannot be undone. My only recourse is to restore and recover the database as of upto 17-April (Sunday).
A daily full backup runs as an automated job.
If I attempt a RESTORE DATABASE now, it will restore from the backup of 19-April.
I know I want the backup of 17-April. Therefore, I use SET UNTIL 'SYSDATE-3' before I issue RESTORE DATABASE and RECOVER DATABASE commands.
Hemant K Chitale