HP OpenView Storage B6960-96008 manual 120

Integrating Oracle and Data Protector

Troubleshooting

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'

120 Chapter 1