Re: alarming experience with controlfile autobackup on

From: Dragutin Jastrebic <orahawk_at_gmail.com>
Date: Tue, 13 Nov 2012 21:24:10 +0100
Message-ID: <CANGCQwnUQDARwEuw=jU41bTPR71RZquGRWKdNPg09fFDVU=Pqg_at_mail.gmail.com>

OK,
This proves that your controlfile is at the right incarnation (in fact I didn't read well your previous
post, sorry. I did'nt reproduce your testcase but your ORA-message is suggesting a slightly different, but similar, problem=> not the wrong controlfile incarnation but the wrong controlfile)

Your RMAN catalog is useful to extract some older controlfile , but if you don't have it, the
catalog will not help you.

I'm actually testing a scenario with alter database create datafile command to see whether it
can apply to your case.

Just give me some more time, and I'll comme back with some conclusion

Dragutin

2012/11/12 keydana_at_gmx.de <keydana_at_gmx.de>

> Hi,
>
> List of Database Incarnations
> DB Key Inc Key DB Name DB ID status reset scn reset time
> 1 2 munip 2487076727 parent 1 30-oct-12
> 1 470 munip 2487076727 parent 1829011 11-nov-12
> 1 923 munip 2487076727 current 1833123 11-nov-12
>
> I've tried to restore to scn 1884846.
> The only remaining controlfile backup's scn is 1886230.
>
> Ciao and thanks,
> Sigrid
>
>
>
> Am 12.11.2012 um 09:20 schrieb Dragutin Jastrebic:
>
> Hi ,
>
> Now you are facing another problem (you need to manually put your control
> file at the right incarnation)
> Can you execute the following command and post the result:
>
>
>
> rman>
> list incarnation of database;
>
>
> Dragutin
>
> 2012/11/11 keydana_at_gmx.de <keydana_at_gmx.de>
>
>> Hi Dragutin,
>>
>> many thanks for your doublecheck! And please excuse the delay, I was on
>> vacation.
>>
>>
>>
>> This is a normal and expected behaviour, all files were restored and
>> recovered to their point in time,except the files that are unkown to the
>> control file used. One more reason to use the rman catalog.
>>
>>
>>
>> I have performed your test (the exact same steps) using a catalog - and
>> now RMAN restores file 3 ( the one not in the autobackup controlfile any
>> more) but the restore fails with ORA-19653: cannot switch to older file
>> incarnation
>>
>> So I don't get something that "wasn't in the database at any point in
>> time" now, but restore fails....
>>
>> Or did you imply different steps to be executed/additional information to
>> be extracted from the catalog?
>>
>> Best greetings
>> Sigrid
>>
>
>
>

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

Received on Tue Nov 13 2012 - 21:24:10 CET