Re: RMAN restore/recover problem
Date: Wed, 28 Aug 2013 14:54:40 -0300
Message-ID: <CAJ2dSGQufKDHLX6xE-U3K1b3dbLnYfv0HaYiRCnGcMBZSvCAWg_at_mail.gmail.com>
you might get around that with a recover database using backup controlfile. I've not used that in a long time (ever since I had to restore a database without the correct controlfile and learned to check the controlfiles are being backed up properly). It's a sqlplus command, not rman if I recall. you can usually use it with recover database using backup controlfile until cancel, and it will ask for each controlfile. You may be able to specify a sequence range, but I'm not sure, again, it's been a while.
hth
Alan.-
On Wed, Aug 28, 2013 at 1:13 PM, Norman Dunbar <oracle_at_dunbar-it.co.uk>wrote:
> Hi Jo,
>
> On 28/08/13 17:03, Jo Holvoet wrote:
> > the current incarnation dates from 2011. So, no recent resetlogs.
> :-(
>
> > As I replied to Alan, I think the cause may be that I don't have a
> > sufficiently "old" controlfile to work with ...--
> Yes, I saw that reply. Time to slap a Unix guy by the sound of things. ;-)
>
> At the risk of poking you with a sharp stick, does your company/DBAs
> practice recoveries?
>
> Andrew mentioned recreating the controlfile from a trace, and trying to
> recover again. I've never done that, but if your backup data is in the
> controlfile, you'll need to re-catalogue all the backups again. :-(
>
> I think you said you were using a catalog[ue] so you should be ok with
> that.
>
> Good luck, and please, let me know how it went, I'm interested. Thanks.
> (If you get time that is.)
>
>
> Cheers,
> Norm.
>
> --
> Norman Dunbar
> Dunbar IT Consultants Ltd
>
> Registered address:
> 27a Lidget Hill
> Pudsey
> West Yorkshire
> United Kingdom
> LS28 7LG
>
> Company Number: 05132767
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 28 2013 - 19:54:40 CEST