======================================================= Oracle: Point in time recovery ======================================================= :Title: Oracle: Point in time recovery :Author: Douglas O'Leary :Description: Oracle: Point in time recovery :Date created: 07/20/2010 :Date updated: 07/20/2010 :Disclaimer: Standard: Use the information that follows at your own risk. If you screw up a system, don't blame it on me... Point in time recovery can be done to a specific time, until an SCN number, or to a specific archive log. The process is as follows: 1. Recover all datafiles from a backup that ended prior to the desired point in time. 2. ``startup mount`` 3. Recover to point in time: a. To a specific time: recover database until time '07-20-2010 21:10:00'; b. To a specific SCN: recover database until change '221122'; c. To a desired archive log: recover database until cancel 3. ``alter database open`` I believe there's a requirement to reset the archive logs, creating another incarnation of your database, when you do this. I will have to verify that, though, as the oracle rman book doesn't specify that.