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:
Recover all datafiles from a backup that ended prior to the desired point in time.
startup mount
Recover to point in time:
To a specific time: recover database until time ‘07-20-2010 21:10:00’;
To a specific SCN: recover database until change ‘221122’;
To a desired archive log: recover database until cancel
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.