RMAN Script Tivoli Storage Manager RMAN Script

Updated: 24-Nov-2004
Version: 1.0

Description

Full RMAN database Recovery from  files backed up to TSM

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. 


startup nomount;
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=cwgsup2,
			    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=cwgsup2,
			    DSMO_AVG_SIZE=1000)';
	restore controlfile;
	sql 'alter database mount';
	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