HP OpenView Storage Data Protector B6960-96008 User Manual

Integrating Oracle and Data Protector

6. Verify backup and restore directly to disk using an RMAN 

If you use the recovery catalog:

Set <

start RMAN from the <

 

directory:

bin\rman target <Target_Database_Login>

 

catalog 

<Recovery_Catalog_Login> cmd_file=rman_script

Use 

rcvcat

 instead of 

catalog

 in the above syntax.

If you do not use the recovery catalog:

Set <

start RMAN from the 

 

directory:

bin\rman target <Target_Database_Login>

 

nocatalog 

cmd_file=rman_script

An example of the RMAN script is presented below:

run {allocate channel 'dev0' type disk;

backup tablespace <tablespace_name>

format '<ORACLE_HOME>\tmp\<datafile_name>';}

After a successful backup, try to restore the backed up tablespace by 
running the following restore script:

run {

allocate channel 'dev0' type disk;

sql 'alter tablespace <tablespace_name> offline immediate';

restore tablespace <tablespace_name>;

recover tablespace <tablespace_name>;

sql 'alter tablespace <tablespace_name> online'

release channel 'dev0';

}

If this fails, see the Oracle documentation for details on how to 
execute a backup and restore directly to disk using RMAN.