Re: Unsupported Recovery Technique......?
Date: Fri, 21 Mar 2008 12:03:50 -0700 (PDT)
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
> 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..?
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