Copying Oracle 10.2.0.4 Database to 11.2
Date: Mon, 8 Aug 2011 07:13:28 -0700 (PDT)
Message-ID: <2e5d62d9-0155-4ab2-9c55-dff6c8ecc0f2_at_k3g2000vbz.googlegroups.com>
Hi,
We have an SAP system (ECC6.0) running on Oracle 10.2.0.4 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.
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
database....".
(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.
My question is on step #(iii).
On 11.2, will the "Create controlfile" command work if the database is 10g?
Thanks,
QZ
Received on Mon Aug 08 2011 - 09:13:28 CDT