Re: alarming experience with controlfile autobackup on
- From: "keydana@xxxxxx" <keydana@xxxxxx>
- To: Dragutin Jastrebic <orahawk@xxxxxxxxx>
- Date: Tue, 13 Nov 2012 23:03:26 +0100
Of course - I'm glad you're looking into it :-)
I just wonder - looking at oerr ora-19653:
Cause: SwitchToCopy was called with a datafile copy for a datafile that was
dropped prior to the time this control file was backed up.
Action: Restore and mount an earlier control file. It is acceptable to use a
control file that was backed up prior to the creation of the specified datafile.
- how about trying to create a controlfile that contains the file we want to
restore?
Anyway, it seems that RMAN uses historic schema information from the catalog,
that's why in fact it restores datafile 3 - but then, when it tries to "switch
to copy", it needs to change the controlfile, and that controlfile does not
contain the entry it wants to change... - right?
Sigrid
Am 13.11.2012 um 21:24 schrieb Dragutin Jastrebic:
> 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@xxxxxx <keydana@xxxxxx>
> 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@xxxxxx <keydana@xxxxxx>
>> 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
>>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
