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
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 Mon Nov 12 2012 - 22:34:43 CET

Original text of this message