Re: Copying Oracle Database to 11.2

From: John D Groenveld <>
Date: Mon, 8 Aug 2011 15:59:16 +0000 (UTC)
Message-ID: <j1p14k$eg7a$>

In article <>, <> wrote:
>We have an SAP system (ECC6.0) running on Oracle on Solaris
>5.9 in, say, servera.
>We are looking to copy it, and rename its Oracle SID, to a Solaris
>5.10 server (serverb)
>running Oracle 11.2.

Why rename the SID?

>The tentative plan is as follows:
>(i) Install SAP/Oracle 11.2 on serverb.
>(ii) Copy a cold backup of the servera database from tapes to serverb.
>(iii) Rename the database to the new SID using "Create controlfile set
>(iv) Run the SAP tool that upgrades Oracle to 11.2 so that the
>database is upgraded (Skip the
>part that install the Oracle binaries). SAP documentation indicates
>that this step works.

Why not restore the cold backup of serverA to serverB and then upgrade SAP and Oracle on serverB?

John Received on Mon Aug 08 2011 - 10:59:16 CDT

Original text of this message