Re: RMAN restore/recover problem

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Wed, 28 Aug 2013 21:00:28 +0200
Message-ID: <521E48CC.9010204_at_gmail.com>



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
Received on Wed Aug 28 2013 - 21:00:28 CEST

Original text of this message