Unsupported Recovery Technique......?

From: <mccmx_at_hotmail.com>
Date: Wed, 19 Mar 2008 20:01:07 -0700 (PDT)
Message-ID: <8f25b68a-d251-4246-ae2c-9bb468594115@s8g2000prg.googlegroups.com>


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 Received on Wed Mar 19 2008 - 22:01:07 CDT

Original text of this message