RE: RMAN restore/recover problem

  • From: "Holvoet, Jo" <jo.holvoet@xxxxxxxxxxxxx>
  • To: "Mark Bobak" <Mark.Bobak@xxxxxxxxxxxx>, "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
  • Date: Thu, 29 Aug 2013 09:26:55 +0200

Mark,

This also asks for archive log sequence 1 ...

Anyway, after a (not-so-) good night's sleep, the plot thickens.
The level 0 backup I'm starting from does NOT contain the undo tbs ...
Upon restore one is created with a checkpoint time way in the past (I
think DB creation time) and so the request for arch seq 1.
This is a data warehouse and the point-in-time I need shouldn't have any
open transactions at that time.

I've got an SR open because I think this is heading toward some
not-so-supported actions ...

Mvg/regards
Jo

-----Original Message-----
From: Mark Bobak [mailto:Mark.Bobak@xxxxxxxxxxxx] 
Sent: woensdag 28 augustus 2013 22:05
To: Holvoet, Jo; Radoulov, Dimitre
Cc: jo.holvoet@xxxxxxxxx; Guillermo Alan Bort; oracle@xxxxxxxxxxxxxxx;
oracle-l-freelists
Subject: Re: RMAN restore/recover problem

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

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


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@xxxxxxxxxxxxx> wrote:

>Hi Dimitre,
>
>The only backups listed are all newer than the point-in-time I want.
>
>-----Original Message-----
>From: Radoulov, Dimitre [mailto:cichomitiko@xxxxxxxxx]
>Sent: woensdag 28 augustus 2013 21:00
>To: Holvoet, Jo
>Cc: jo.holvoet@xxxxxxxxx; Guillermo Alan Bort; oracle@xxxxxxxxxxxxxxx;
>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@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
>
>
>
>


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

Other related posts:

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