RMAN Script RMAN Recovery Tablespace

Updated: 24-Nov-2004
Version: 1.0

Description

RMAN Script to Recover a Tablespace.

This script will perform a tablespace recovery and apply any nessesary redo required for media recovery. Change the tablespace name accordingly.

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

Parameters

SQL Source

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


run { 
     sql 'ALTER DATABASE DATAFILE 5 OFFLINE';
     sql 'ALTER TABLESPACE users OFFLINE TEMPORARY';
     allocate channel ch1 type disk;
     restore tablespace users;
     recover tablespace users;
     sql 'ALTER TABLESPACE users ONLINE';
}

Related Links

Oracle 8i: (RMAN Script) RMAN Validate Tablespace 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