HP OpenView Storage B6960-96008 manual Unix, Windows

Integrating Oracle and Data Protector

Restoring an Oracle Database

Use rcvcat instead of catalog in the above syntax.

If you do not use the recovery catalog database, run:

•On Windows: <ORACLE_HOME>\bin\rman target sys/manager@PROD nocatalog

•On UNIX: <ORACLE_HOME>/bin/rman target sys/manager@PROD nocatalog

•On OpenVMS: rman target sys/manager@PROD nocatalog

2.Start the datafile restore and recovery:

•If the database is in an open state, the script to restore the datafile should have the following format:

UNIX	run{
	allocate channel dev1 type 'sbt_tape' parms
	'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=<DB_NAME>)';
	sql "alter database datafile
	''/opt/oracle/data/oradata/DATA/temp01.dbf'' offline";
	restore datafile
	'/opt/oracle/data/oradata/DATA/temp01.dbf';
	recover datafile
	'/opt/oracle/data/oradata/DATA/temp01.dbf';
	sql "alter database datafile
	'/opt/oracle/data/oradata/DATA/temp01.dbf' online";
	release channel dev1;
	}
Windows	run{
	allocate channel dev1 type 'sbt_tape' parms
	'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=<DB_NAME>)';
	sql "alter database datafile
	''C:\oracle\data\oradata\DATA\temp01.dbf'' offline";
	restore datafile
	'C:\oracle\data\oradata\DATA\temp01.dbf';
	recover datafile
	'C:\oracle\data\oradata\DATA\temp01.dbf';
	sql "alter database datafile

Chapter 1 103