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

From: bdbafh <>
Date: Thu, 20 Mar 2008 08:16:18 -0700 (PDT)
Message-ID: <>

On Mar 19, 11:01 pm, wrote:
> 10g Release 2
> I have cloned a database onto a 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 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 to and used exactly the same technique (alter
> database open upgrade). This also seemed to work fine but is it a
> supported/stable approach..?
> Thanks

What is the value for the parameter "compatible" in the spfile/ init.ora when you're recovering the cloned database backup set?

Perhaps setting that to during the "open resetlogs" phase might prevent the database needing to be opened with the UPGRADE option.

After the logs have been reset, then startup upgrade and execute the upgrade script ...


-bdbafh Received on Thu Mar 20 2008 - 10:16:18 CDT

Original text of this message