Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> how to extract control file from RMAN's backup-set
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
![]() |
![]() |