RE: RMAN restore/recover problem

The only backups listed are all newer than the point-in-time I want.

-----Original Message-----
From: Radoulov, Dimitre [mailto:cichomitiko_at_gmail.com] Sent: woensdag 28 augustus 2013 21:00
To: Holvoet, Jo
Cc: jo.holvoet_at_gmail.com; Guillermo Alan Bort; oracle_at_dunbar-it.co.uk; oracle-l-freelists
Subject: Re: RMAN restore/recover problem

Connect to catalog and execute:

list backup of controlfile;

If you find the backup in some backupset, try (I'm not sure about the exact syntax):

restore controlfile from 'backupset_name';

Regards
Dimitre

On 28/08/2013 20:56, Holvoet, Jo wrote:
> Hi Dimitre,
>
> Since I registered the backupsets in our rman catalog, shouldn't I see
> this in the RC_BACKUP_CONTROLFILE view ? It's not there.
>
> Mvg/regards
> Jo
>
> -----Original Message-----
> From: Radoulov, Dimitre [mailto:cichomitiko_at_gmail.com]
> Sent: woensdag 28 augustus 2013 20:14
> To: jo.holvoet_at_gmail.com; Holvoet, Jo
> Cc: Guillermo Alan Bort; oracle_at_dunbar-it.co.uk; oracle-l-freelists
> Subject: Re: RMAN restore/recover problem
>
> Just to add that RMAN automatically includes the control file and
> server parameter file in backups of data file 1, so I believe that you
> should have
> a backup of the controlfile in the backupset of datafile 1 (tablespace
> system).
>
> Regards
> Dimitre
>
> On 28/08/2013 19:54, Guillermo Alan Bort wrote:
>> [...] (ever since I had to
>> restore a database without the correct controlfile and learned to
> check the
>> controlfiles are being backed up properly).

--
http://www.freelists.org/webpage/oracle-l