HP (Hewlett-Packard) B6960-96008 Garage Door Opener User Manual


 
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.