If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Requirement is to convert the Above Source into the below Target configuration
------------------------------------------------------------------------------------------------------------------
Target:

STEPS we are planning to follow:
--------------------------------
1.Shutdown the Source (production) and take cold backup of datafiles and Oracle home.
2. Copy the Raw files from source to target using dd command.
(The target has veritas FS)
To do this we are using dd command.

3. Copy Oracle Home from Source to Target. (Single Node)

4. Recreate Controlfile and bring up the single Node on Veritas File system

Take a backup of the whole database
Install 10.2.0.1 CRS on 2 nodes for RAC
Startup the 10.1.0.4 RAC with 10.2.0.1 CRS
Install a New Oracle home for 10.2.0.1
Shutdown the 10.1.0.4 RAC Database
Use DBUA to upgrade the database to 10.2.0.1
Bring up the RAC and check everything
Shutdown the Database and instances
Use RMAN (you can also switch the database to copies etc) or DD the datafile to VXFS filesystem
Recreate the controlfile
restart the database

Note i have not done a upgrade from 10.1 to 10.2 RAC but i guess the key is getting the 10.2.0.1 CRS up and running right others all should be normal steps.

Wundering did you check with oracle support guys on this i am curious

I am curious why you went up the route of conveting to single instance and then back to a clustered instance ?

1. Backup the database.
1a. Export the entire database.
2. Install the new CRS 10.2.0.1.0 and upgrade it to 10.2.0.3.0.
3. Create database using dbca which will be of version 10.2.0.3.0.
4. Import the full database.

1. Backup the database.
1a. Export the entire database.
2. Install the new CRS 10.2.0.1.0.
2a. Install Database software 10.2.0.1.0 and patch it 10.2.0.3.0 and upgrade crs IF NEEDED.
3. Create database using dbca which will be of version 10.2.0.3.0.
4. Import the full database.

1. Backup the database.
1a. Export the entire database.
2. Install the new CRS 10.2.0.1.0.
2a. Install Database software 10.2.0.1.0 and patch it 10.2.0.3.0 and upgrade crs IF NEEDED.
3. Create database using dbca which will be of version 10.2.0.3.0.
4. Import the full database.

It is 500gb db. It would take long time for Export / Import.

------------------------------------------------------------------------The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway

For a std upgrade from 10.1 to 10.2, shut down the CRS stack on all nodes, & unlock the CRS home using the script [B]mountpoint/clusterware/upgrade/preupdate.sh. When u run OUI & select the option to install Oracle Clusterware on a subset of nodes, OUI installs Oracle 10.2 clusterware into the existing CRS home on the local & remote node subset.
When all member nodes of the cluster are running clusterware 10.2, then the new clusterware becomes the active version.
You can now upgrade ur db from 10.1 to 10.2. If u're planning to use ASM for storage, then i'll suggest u install & patch the ASM from 10.2.0.1 to 10.2.0.3 & do the same for the oracle software separately. I found it easier trouble shooting separate ASM/software installs than first laying down the software & using dbca to create an ASM instance.