Integrating Oracle and Data Protector
Troubleshooting
Chapter 1124
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.