- Hewlett-Packard Garage Door Opener User Manual

Integrating Oracle and Data Protector
Troubleshooting
Chapter 1120
Start SQL*Plus and type:
connect <Recovery_Catalog_Login>;
select * from rc_database;
exit
If this fails, start the configuration using Data Protector or see the
Oracle documentation for details about how to register an Oracle
target database in the recovery catalog database.
6. Verify backup and restore directly to disk using an RMAN
channel type disk.
If you use the recovery catalog:
Export <ORACLE_HOME> as described on page 117 and start RMAN:
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:
Export <ORACLE_HOME> as described on page 117 and start RMAN:
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'