Re: alarming experience with controlfile autobackup on
From: <keydana_at_gmx.de>
Date: Mon, 12 Nov 2012 22:34:43 +0100
Message-Id: <8D54919E-2E3C-4341-8882-18E49540A3CB_at_gmx.de>
Hi,
List of Database Incarnations
>
>
> 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
>
Date: Mon, 12 Nov 2012 22:34:43 +0100
Message-Id: <8D54919E-2E3C-4341-8882-18E49540A3CB_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-lReceived on Mon Nov 12 2012 - 22:34:43 CET