Filter
Top Products
Integrating Oracle and Data Protector
Troubleshooting
Chapter 1 139
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';