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

Home -> Community -> Usenet -> c.d.o.server -> RMAN Question.

RMAN Question.

From: News <r.w.p_at_charter.net>
Date: Mon, 2 Oct 2006 19:01:15 -0500
Message-ID: <TNhUg.75$rP4.18@newsfe06.lga>


Here's the scenario.
You use rman to backup your database disk-to-disk, then copy the control file, the backup your archived log files as shown in this script segment.

run {
allocate channel chn1 type disk;
backup full format = '\\FS1\backups\dbf\data%U' ; copy current controlfile to '\\FS1\backups\dbf\control.ctl'; backup format = '\\FS1\backups\archlog%U' archivelog all delete input; }

Now you loose your entire database including control files. Your backups above are ok and you intend to use the copy of the control file to restore and recover your database.

The problem is that the control file copy in the above backup was taken BEFORE the archivelog file backup. This means that the copy of the control file does not have a record of the archived log file rman backup piece on disk.

Question:

After I do the restore of the database using rman, how can I get rman to recognize the archivelog backup piece that was created? Is there a way to make rman "aware" of that archivelog file backup piece?

This is a real scenario at a customer site.

Thanks.
mim Received on Mon Oct 02 2006 - 19:01:15 CDT

Original text of this message

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