Re: RMAN restore/recover problem

From: Mark Bobak <Mark.Bobak_at_proquest.com>
Date: Wed, 28 Aug 2013 20:05:25 +0000
Message-ID: <CE43CFB6.349BF%Mark.Bobak_at_ProQuest.com>

Have you tried 'recover database using backup control file until cancel'?

http://docs.oracle.com/cd/B12037_01/server.101/b10734/rcmrecov.htm#1006247

I think someone previously suggested that, but I don't recall seeing that you tried it?

-Mark

On 8/28/13 3:48 PM, "Holvoet, Jo" <jo.holvoet_at_thomascook.be> wrote:

>Hi Dimitre,
>
>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
>
>
>
>

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

Received on Wed Aug 28 2013 - 22:05:25 CEST