controlfile autobackup (was: Re: disaster recovery)

From: joel garry <>
Date: Tue, 20 May 2008 09:25:57 -0700 (PDT)
Message-ID: <>

On May 17, 9:55am, wrote:
> On Fri, 16 May 2008 13:02:36 -0700 (PDT), Ben <>
> wrote:

> >now that we've lost the catalog, spfile, controlfiles, and everything
> >else. Is there a way to get the controlfile and spfile out of that
> >backup?
> If you didn't have controlfile autobackup on, which you didn't
> specify, shortly : NO.

I have a recently installed hp-ux with autobackup on. It's just idling along while I do app development on another machine. This thread made me take a closer look at the autobackup. I check the alert log, I see it is writing controlfile backups to specific files in directories with each days date on them, makes sense since I'm taking a full backup each day (I haven't set up a repository yet). It seems to be keeping a weeks worth of these directories, but I only just noticed it only is keeping the latest controlfile backup. Seems not paranoid enough to me. I have CONFIGURE RETENTION POLICY TO REDUNDANCY 2; The script as generated by the customization wizard is this:

$rman_script="backup device type disk tag '%TAG' database; backup device type disk tag '%TAG' archivelog all not backed up; allocate channel for maintenance type disk; delete noprompt obsolete device type disk; release channel;

Am I wrong to expect the delete obsolete to keep two of the controlfile/spfile backups? Or is it just also in the regular backup files?

Looking at the rman log, I see what is happening: It is backing up the controlfile/spfile once for the archivelog backup, then once again for the regular backup, then deleting all the others. So it is keeping two, from the same time - the log appears to have them before and after the backup, but the unix time is the same (I assume because rman must have closed the files at nearly the same time).

This seems strange, how should I be doing this? Shouldn't I want to have some spread of controlfile backup times, to avoid just propagating a messed up one when restoring?


-- is bogus.
I like candy in general,  I'm pretty favorably disposed toward
candy. - Warren Buffet
Received on Tue May 20 2008 - 11:25:57 CDT

Original text of this message