Re: upgrade and moving to another server in one stop

From: bdbafh <>
Date: Fri, 4 Feb 2011 20:12:31 -0800 (PST)
Message-ID: <>

On Feb 3, 5:48 pm, charles <> wrote:
> Dear group,
> We are moving our Oracle database on redhat 4 to redhat 5 and
> upgrade it to
> so, on server A(redhat 4), i took a hot backup using RMAN,
> on server B, (redhat 5), i installed,  i can restore and
> recover the database without problem.  But i cannot start the
> database.  I tried
> alter database open resetlogs;
> alter database open upgrade resetlogs;
> alter database open upgrade;
> None of them seems working.  Could somebody help me out?
> Thanks very much for your help

separate your steps.
If you performed a cold backup using rman whereby the online redo logs would be moved over as well, no recovery would be required. Why not just perform a manual cold backup and move that backup set? Using a cold backup set (with a clean shutdown) no recovery is required and you can go straight into upgrading the catalog, e.g.

( from a home on the new server)

cd $ORACLE_HOME/rdbms/admin
sqlplus / as sysdba
startup upgrade
shutdown immediate
alter system set compatible='' scope=spfile -- or make the change in the pfile and create a new spfile if you wish. shutdown immediate

check your invalids and apply whatever patch set update you feel is appropriate (or not).

By using a backup method that requires recovery to be made consistent, you can't change the catalog in that same step. open database set restored - needs to be recovered on that version. After its brought to be consistent - and opened resetlogs, it can be cleanly shutdown and opened upgrade in order to upgrade the catalog to the new patchset.

but you could have found out all of this info from the upgrade guides.

-bdbafh Received on Fri Feb 04 2011 - 22:12:31 CST

Original text of this message