Re: Unsupported Recovery Technique......?

On Mar 19, 11:01 pm, mc..._at_hotmail.com wrote:
> 10g Release 2
>
> I have cloned a 10.2.0.1 database onto a 10.2.0.3 home by using a cold
> backup and recreating the controlfile.  During the 'alter database
> open resetlogs' the instance crashes because of the version mistmatch:
>
> ORA-00704: bootstrap process failure
> ORA-39700: database must be opened with UPGRADE option
> Thu Mar 20 02:46:27 2008
>
> I then run:
>
> startup mount
> alter database open upgrade
>
> and then upgrade the database to 10.2.0.3 with
>
> @$ORACLE_HOME/rdbms/admin/catupgrd.sql
>
> Everything appears OK.
>
> My question is.......  is this a supported procedure..?  Is there a
> danger that the database is corrupted in some way after performing
> this restore/upgrade step together....?
>
> Incidentally, I also used this technique to restore an RMAN backup
> from 10.2.0.1 to 10.2.0.3 and used exactly the same technique (alter
> database open upgrade).  This also seemed to work fine but is it a
> supported/stable approach..?
>
> Thanks

If you are cloning from datafile copies and a cold backup you will have better luck using the same version of the database on both sides aka 10.2.01 and 10.2.0.1. Received on Fri Mar 21 2008 - 14:03:50 CDT