Oracle: Point in time recoveryΒΆ

Title:Oracle: Point in time recovery
Author:Douglas O’Leary <dkoleary@olearycomputers.com>
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:
    1. To a specific time: recover database until time ‘07-20-2010 21:10:00’;
    2. To a specific SCN: recover database until change ‘221122’;
    3. To a desired archive log: recover database until cancel
  1. 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.