Integrating Oracle and Data Protector

Troubleshooting

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

If you use the recovery catalog:

Set <ORACLE_HOME> and start RMAN from the <ORACLE_HOME> directory:

Oracle 9i/10g:

bin\rman target <Target_Database_Login> catalog <Recovery_Catalog_Login> cmd_file=rman_script

Oracle 8i:

Use rcvcat instead of catalog in the above syntax. If you do not use the recovery catalog:

Set <ORACLE_HOME> and start RMAN from the <ORACLE_HOME> 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.

124

Chapter 1