RMAN Script Tivoli Storage Manager PIT RMAN recovery

Updated: 24-Nov-2004
Version: 1.0

Description

Point in Time Recovery using TSM as the backup Media Manager. 

Restores a previously TSM/TDP backed up Oracle on-line database

Parameters

SQL Source

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



# Restore the database
#shutdown immediate;
startup mount;
run {
	allocate channel 'tsm_dev0' type 'SBT_TAPE'
		parms 'ENV=(DSMI_DIR=/opt/tivoli/tsm/client/api/bin,
			    DSMI_ORC_CONFIG=/opt/tivoli/tsm/client/api/bin/dsm.opt,
			    DSMO_NODE=cwgsud8,
			    DSMO_AVG_SIZE=1000)';
	allocate channel 'tsm_dev1' type 'SBT_TAPE'
		parms 'ENV=(DSMI_DIR=/opt/tivoli/tsm/client/api/bin,
			    DSMI_ORC_CONFIG=/opt/tivoli/tsm/client/api/bin/dsm.opt,
			    DSMO_NODE=cwgsud8,
			    DSMO_AVG_SIZE=1000)';
        set until time 'Jun-09-2001 09:00:00';
	restore database; 
	recover database;
	release channel tsm_dev0;
	release channel tsm_dev1;
	sql 'alter database open resetlogs ';
}

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