Cloning Oracle Database Home From RAC to Single-Node

Recently, I’ve been trying to clone an oracle database installation home from production (3-node RAC) to a test environment (single-node). I’ve faced some troubles until I got it running successfully at the end.

Below are the steps that I followed (used on solaris 10 SPARC 64-bit):

1- copy the database installation home from production to test environment.
(I used tar & gzip)

2- cleanup unnecessary files (e.g. init.ora files, network files, …)

3- relink oracle without RAC support.

$ cd $ORACLE_HOME/rdbms/lib
$ make -f rac_off
$ make -f ioracle

4- clone the copied oracle home to fix it’s local inventory, and attach to central inventory

$ cd $ORACLE_HOME/clone/bin

(will be prompted to run root scripts)

after this step, both central and local inventories have reference to names of RAC nodes from production.

(many other files in the local inventory also have reference to RAC nodes from production)

5- deattach from central inventory to remove references to RAC nodes in both central and local inventories

$ cd $ORACLE_HOME/oui/bin
$ ./ -detachHome ORACLE_HOME=$ORACLE_HOME ORACLE_HOME_NAME="OraDb10g_home1"

6- attach the home again to fix the central inventory

$ cd $ORACLE_HOME/oui/bin
$ ./ -attachHome ORACLE_HOME=$ORACLE_HOME ORACLE_HOME_NAME="OraDb10g_home1"

it should work fine now.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Current day month ye@r *