RMAN Script RMAN Incomplete Recovery

Updated: 24-Nov-2004
Version: 1.0

Description

RMAN Script to Recover to a defined log sequence number.

This script will perform an incomplete recovery of the database until the specified SCN number.  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.rman first.

Parameters

SQL Source

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


shutdown immediate;
startup mount;
run { 
     set until logseq 87 thread 1; 
     allocate channel ch1 type disk;
     restore database;
     recover database;
     alter database open resetlogs;
}
reset database;

Related Links

Oracle 8i: (RMAN Script) RMAN Validate Recover Database

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