Re: Why I don't like RMAN repositories

From: Paresh Yadav <>
Date: Wed, 11 Dec 2013 19:53:01 -0500
Message-ID: <>

Excellent thread. There is a "magical" workaround to getting older control file from storage media even when CONTROL_FILE_RECORD_KEEP_TIME = 7 (or whatever the value is) as long as the backups are retained on the media. Not sure if this was available in 8i, 9i but have used this in 10g recovery at a large Canadian grocer. In RMAN configure controlfile autobackup to ON. With that, when you ask RMAN to recover a controlfile to a particular point in time it asks media manager to restore files and provides appropriate file names to the media manager. This works because with controlfile autoback, the backup pieces that have controlfile are named in particular fashion. This is all well documented. It has been 5+ years when this was done so don't remenber the details or the control file autobackup piece naming convention. There are few gotchas with that e.g. if you have an hourly script to add "partitions + tablespace" to table/s, there will be a controlfile autobackup triggered with each tablespace/data file addition (as designed) but this holds controlfile enque for duration of the backup (as far as I can remember)...


On Wed, Dec 11, 2013 at 6:59 PM, Dick Goulet <> wrote:

> To catalog or not to catalog has always been a question that never has had
> a good answer. So let me put it this way, I have a catalog db and I use
> it. But I also practice restores without it and don't have a problem.
> Course it helps to have a tape librarian with lots of memory. Ours likes
> to retain stuff for 3 years. The controlfile 90 days. Try "restore
> controlfile from '<media handle>';" where <media handle> =
> c-<date>-<dbid>-00 if you need something beyond that 90 day point.
> Dick Goulet
> Senior Oracle Dba
> ----------------------------------------------------------------------
> From: Dustin Hayden<>
> Subject: RE: Why I don't like RMAN repositories
> Date: Mon, 9 Dec 2013 12:53:12 +0000
> So what it if ages out you can always just re-catalog it and then restore.
> --

Received on Thu Dec 12 2013 - 01:53:01 CET

Original text of this message