Re: RMAN Question.

Correct, its Oracle Version 9.2.0.2. It was at a customer site of a cots product where the vendor setup the database & backup procedures. I won't say the vendor name. Yeah, they found out the hard way. No catalog, only backup control file which was taken before the backup piece was created for archived log files on disk. Since there is no catalog and no later backup control file the archivelog backup piece on disk is unusable because there is no record of it in the control file copy. Was hoping someone knew of a way to basically "catalog" that backup piece into the controlfile copy. No such luck.

Thanks, mim

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:6et3i2pdek0k9g59r577b7mfop172ucn6g_at_4ax.com...
> On Mon, 2 Oct 2006 19:01:15 -0500, "News" <r.w.p_at_charter.net> wrote:
>
>>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
>>
>
> 1 Oracle does NOT support doing *anything* across the network using
> UNC notation
> 2 If this is Oracle 8i the script is just plain incorrect. And no,
> there is NO command to make RMAN 'aware' of the archivelog backup.
> You'll have to change the script.
> 3 If this is Oracle 9i or above, the RMAN command configure
> controlfile autobackup on would help you out
>
> If this is a real situation at a customer site, I would simply pray
> you never need to restore. Likely, there will be some very nasty
> surprises.
>
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
>
>
> ---
> avast! Antivirus: Inbound message clean.
> Virus Database (VPS): 0640-1, 10/03/2006
> Tested on: 10/3/2006 12:27:54 PM
> avast! - copyright (c) 1988-2006 ALWIL Software.
> http://www.avast.com
>
>
>
Received on Tue Oct 03 2006 - 12:38:05 CDT