Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> how to extract control file from RMAN's backup-set

how to extract control file from RMAN's backup-set

From: Edward Rusu <erusu_at_softcomputer.com>
Date: Thu, 7 Jun 2001 16:35:12 -0400
Message-ID: <3b1fe58a$1@smtp2.softcomputer.com>

Hi All!
We use the following RMAN command script to make backup of an Oracle database to tape:
run
{
  allocate channel t1 type 'sbt_tape';
  backup full format '%d_s%s_p%p.bkpdf' (database);   sql 'alter system archive log current';   backup format '%d_s%s_p%p.bkpal' (archivelog all delete input);   backup current controlfile format '%d_s%s_p%p_full_al.bkpcf';   release channel t1;
}

We do not use the recovery catalog, so in situation when we lost all files, the only way to restore control file is to extract control file from bacjup-set, which is on the tape. According to Oracle documentation there is no possibility to restore control file without recovery catalog. Does anyone know if there is an utility that can extract the control file from backup set? A simple program could save a lot of time against using an additional database with recovery catalog. I'll appreciate any hints or advices.
Thank you,
Edward Rusu Received on Thu Jun 07 2001 - 15:35:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US