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.