Re: RMAN restore/recover problem

  • From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
  • To: "Holvoet, Jo" <jo.holvoet@xxxxxxxxxxxxx>
  • Date: Wed, 28 Aug 2013 21:00:28 +0200

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@xxxxxxxxx]
> Sent: woensdag 28 augustus 2013 20:14
> To: jo.holvoet@xxxxxxxxx; Holvoet, Jo
> Cc: Guillermo Alan Bort; oracle@xxxxxxxxxxxxxxx; 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).

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2013