RMAN Script RMAN Point in Time Recovery

Updated: 24-Nov-2004
Version: 1.0

Description

RMAN Script to Recover until point in time.

This script will perform an incomplete recovery of the database until the specified time.  This method will imply loss of data.

NOTE: After operning with RESETLOGS do an immediate backup!

To check RMAN can access files needed run check_recover_database_pit.rman first.

Parameters

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 


shutdown immediate;
startup dba mount;
run { 
     set until time "to_date('Feb 27 2002 14:37:00','Mon DD YYYY HH24:MI:SS')";
     allocate channel ch1 type disk;
     allocate channel ch2 type disk;
     restore database;
     recover database;
     sql 'alter database open resetlogs';
}
reset database;

Related Links

Oracle 8i: (RMAN Script) RMAN Validate Database PIT recovery

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links