HP OpenView Storage B6960-96008 restored from Data Protector managed backup, The Recovery Catalog was lost and the control file cannot be

	Integrating Oracle and Data Protector
	Troubleshooting
	1. Rename the util_orarest.exe to util_orarest.exe.orig
	2. Rename the util_orarest9.exe to util_orarest.exe
Problem	The Recovery Catalog was lost and the control file cannot be
	restored from Data Protector managed backup
	The Recovery Catalog was not used, the RMAN autobackup feature was
	not used (for Oracle 9i/10g), and the control file cannot be restored from
	Data Protector managed backup. A valid control file backup exists on
	tape.
Action	• For Oracle 8i, restore the control file from RMAN backupset with the

following SQL script:

DECLARE

devtype varchar2(256); done boolean;

BEGIN

devtype:=dbms_backup_restore.deviceallocate('sbt_tape', params=>'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=<DB_NAME>,OB2 BARHOSTNAME=<hostname>)');

dbms_backup_restore.restoresetdatafile;

dbms_backup_restore.restorecontrolfileto('/tmp/tmp.cf');

dbms_backup_restore.restorebackuppiece('<backup piece handle>',done=>done);

END;

For the <backup piece handle> search the Data Protector internal database and session outputs of previous backup sessions.

Use the following RMAN script to copy the control file, mount and restore the database, and perform a database recovery:

run {

allocate channel 'dev_0' type disk; replicate controlfile from '/tmp/foo.cf'; sql 'alter database mount';

set until time 'MMM DD YY HH24:MM:SS';

Chapter 1 139