RMAN Script RMAN Recovery System Tablespace

Updated: 24-Nov-2004
Version: 1.0

Description

RMAN Script to Recover the System tablespace.

This script will perform a recovery on system tablespace and apply any nessesary redo required for media recovery. The database must be mounted but not open to run this script.

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 { 
     allocate channel ch1 type disk;
     restore tablespace system;
     recover tablespace system;
     sql 'ALTER DATABASE OPEN';
}

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