Manage
Learn to apply best practices and optimize your operations.
How to restore a database using RMAN to Point in Time
An Oracle user asks how to restore a database using RMAN to Point in Time.
How would you restore a database using RMAN to Point in Time?
This question can easily be found in
this Oracle documentation.
The RMAN command to perform Point In Time Recovery (PITR) is:
RECOVER DATABASE
The
You can recovery until a specific SCN, a specific log sequence, a restore point, or a specific time. To recover to a specific point in time, use:
RECOVER DATABASE UNTIL TIME "TO_DATE('12/01/07 13:15','MM/DD/YY HH24:MI')";
