No Controlfile # No Recovery Catalog # Restore Controlfile from tape # Netbackup

Restore Controlfile Without Backup entries in controlfile ( control file lost ) and without recovery catalog.

/usr/openv/netbackup/bin/bplist -C <client_name> -S <masterserver_name> -s mm/dd/yyyy -e mm/dd/yyyy -t 4 -l -R /

 '/oracletm/control01.dbf'

DECLARE

v_devtype VARCHAR2(100);

v_done BOOLEAN;

v_maxPieces NUMBER;

TYPE t_pieceName IS TABLE OF varchar2(255) INDEX BY binary_integer;

v_pieceName t_pieceName;

BEGIN

-- You must write backup piece name

v_pieceName(1) := '/xxxxxxxxx';

-- Allocate a channel... (for disk backup type=>null, for tape backup type=>'sbt_tape')

v_devtype := DBMS_BACKUP_RESTORE.deviceAllocate(type=>'sbt_tape', ident=>'d1');

DBMS_BACKUP_RESTORE.restoreSetDataFile;

-- The folder that controlfile will be restored

DBMS_BACKUP_RESTORE.restoreControlFileTo(cfname=>'/tmp/control01.dbf');

-- Restore process

DBMS_BACKUP_RESTORE.restoreBackupPiece(handle=>v_pieceName(1), done=>v_done, params=>null);

-- Deallocate the channel...

DBMS_BACKUP_RESTORE.deviceDeAllocate('d1');

EXCEPTION

WHEN OTHERS THEN

DBMS_BACKUP_RESTORE.deviceDeAllocate;

RAISE;

END;

/

x