Loading...

Cloning Single instance oracle home

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

here we are 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 
Single Instance Oracle Home - Oracle
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
VirtualNuggets 4340992726154475907

Post a Comment

emo-but-icon

Home item

Popular Posts

Random Posts

Flickr Photo