Cloning R12

$RUN THE ENVIRONMENT FILE

If you have to take the existing backup or just performing clonning then first down apps and  then db execute the

make_tar_db.sh it will create db backup then change this script for apps backup like following.

dated=`date +"%d-%b-%y"`

tar -zcvf /ofsa_apps/backup/"APPS_PROD_"$dated".tar.gz" /ofsa_apps/oracle 2 > /ofsa_apps/backup/"APPS_PROD_"$dated".log"

SOURCE DB NODE

* Services should be up while the following steps will be done.

* run the environment file.

* cd /ofsa_db/oracle/db/tech_st/10.2.0/appsutil/scripts/PROD_ofsa-live-db       

                                                --PROD is the Sid and ofsa-live-db is the machine name

* perl adpreclone.pl dbTier

* Enter password------->apps

* . /home/oracle/down.sh (application should be down first)

* . /home/oracle/maketar.sh

* . up.sh

* transfer backup to the destination system                                           

SOURCE APPS NODE

* Services should be up while the following steps will be done.

* run the environment file.

* cd /ofsa_app/oracle/inst/apps/PROD_ofsa-live-app/admin/scripts

  perl adpreclone.pl appsTier

* . down.sh

* . maketar.sh

* . up.sh (db should be up first)

* transfer backup to the destination system

Transfer backup from live 10.200.141(DB) to DR(10.200.3.116)

$ scp DB_PROD_17-May-10.tar.gz 10.200.3.116:/ofsa_db/backup

It will ask password of 10.200.3.116(give password) then scp will start.

(same method for ofsa_apps)

Cloning Scripts after backup

Before extract the backup delete previous files from oracle folder

rm -rf * (for db and apps both) e.g cd /ofsa_db/oracle then rm -rf * (It's better to reboot machine after removing db n apps so that no process will left)

To extract the backup  perform the following steps

$ cd /

tar zxvf  /ofsa_apps/backup/apps_prod_14-may-10.tar.gz (enter)

tar zxvf /ofsa_db/backup/DB_prod_14-may-10.tar.gz(enter)

Target DB TIER

 [oracle@testdb ~]$ cd $ORACLE_HOME

[oracle@testdb ~]$ cd appsutil/clone/bin

[oracle@testdb ~]$ perl adcfgclone.pl dbTier

Enter the APPS user password: apps

Enter the APPS password: apps

DB TIER SREENSHOT:

If  listener  port 1521 error occurred then kill listern process e.g ps -ef |grep lsnr  then $kill -9 4345 (give listener process number)

Target system domain name = nibpk.com

Target APPS TIER

[oracle@testapps ~]$ cd /ofsa_apps/oracle/apps/apps_st/comn/clone/bin

[oracle@testapps ~]$ vi adcfgclone.pl

10.200.122.140 set JAVA_HOME=”/usr/java/jdk1.6.0_20”

10.200.3.78= JAVA_HOME=”/usr/java/jdk1.5.0_22”

[oracle@testapps bin]$ perl adcfgclone.pl appsTier

Enter the APPS user password: apps

Enter the APPS password: apps

APPS SERVER (MULTINODE)

If Web SSL port 4443 is not free error occurred then reboot the machine and then start apps cloning again.

APPSTIER SCREENSHOT (Single Node):

Add the Path /usr/vac/bin , in case of the following error