Sunday, November 17, 2013

Cloning Single instance oracle home

Cloning the single instance oracle home (This method require -Sudo privilage on both servers)

here I am going to clone the oracle home to the new server which has same hardware configuration as the source server)

1. login as root user

$su -
password:

#echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/db_1

#cd /u01/app/oracle/product/11.2.0/db_1

2.check the present directory disk usage size
(Note: we need to move the size across the network and makwe sure we have space in the destination location)

du -sh

3. Then copy the directory without changing the permission of the file
(note : "-rp " option help to copy the witout changing the permission of file or folder)
cp -rp

cd /u01/app/oracle/product/11.2.0/

11.2.0] cp -rp db_1  clonedb_1

tar -zvCf clonedb_1.tar.gz

scp -rp clonedb_1 oracle@192.168.168.1:/u01/app/oracle/product/11.2.0/db_home


4.In the new server create required directory structure

$ mkdir -p /u01/app/oracle/product/11.2.0/dbhome_1
$ export ORACLE_BASE=/u01/app
$ export ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/dbhome_1
$ cd $ORACLE_HOME/

5. In the clone location unzip tar file what
dbhome_1]$ cp ~/orahome11gR2_lin32.tar.gz .

dbhome_1]$ gunzip clonedb_1.tar.gz

dbhome_1]$ tar -xvf clonedb_1.tar

dbhome_1]$su -

# tar -xvf clonedb_1

# exit
$ cd /u01/app/oracle/product/11.2.0/clonedb_1/clone/bin


6. Now we need to provide the oracle base location. it is going to create the "oracle inventory location"
and run the perl script in clone/bin location

11.2.0/clonedb_1/clone/bin]$ perl clone.pl ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 ORACLE_HOME_NAME=11gR2_NEW


by the same time tail the log when the the location mentioned after using the above command

in another terminal
$tail-f /u01/app/oraInventory/logs/cloneAction2012-09-02_10-22.0PM.log
.
.
.
.
.
.
.

The cloning of 11gR2_NEW was sucessesful.
(Note when you get this message in log file cole preocess is sucessful)


7. run the root script ( to change the permission of the files and folder)

$su -

# /u01/app/oracle/product/11.2.0/clonedb_1/root.sh


8. then check the entry of the database in the /etc/oratab location

and we can check the oracle home location by checking the xml file in the inventory location

cd /u01/app/oraInventory/ContentsXML

cat inventory.xml

then change the listener entry

No comments:

Post a Comment