Cold Backup Cloning of Oracle Apps DBA R12.1.1

Cold Backup Cloning

Assumptions:

1)      Target database is similar in configuration to source database.

2)      oratest and appltest users are created in the target database under dba group.

3)      Environment is always set when logged in as oracle or applmgr in source system.

Pre Cloning Steps:

1) DB Tier is precloned first. Ex: cd $ORACLE_HOME/appsutil/scripts/SID/   perl adpreclone.pl dbTier

2) Apps Tier to be precloned next. Ex: cd $COMMON_TOP/admin/scripts/SID/ perl adpreclone.pl appsTier

Cold Backup:

1)      Shutdown Application, Listener and Database. Verify if they are down.

$ ps -ef|grep applprod

applprod 10031  1471  0 18:24:46 pts/ta    0:00 ps -ef

applprod 10032  1471  1 18:24:46 pts/ta    0:00 grep applprod

applprod  1471 29301  0 18:06:07 pts/ta    0:00 –sh

$ ps -ef|grep tns

applprod 10105  1471  0 18:25:41 pts/ta    0:00 grep tns

$ ps -ef|grep oraprod

applprod 10107  1471  0 18:25:46 pts/ta    0:00 grep oraprod

oraprod 29760 29518  0 17:48:26 pts/tb    0:00 -sh

2)      Copy APPL_TOP, COMMON_TOP and ORA_TOP from applmgr and move it to Target system under appltest directory.

Ex : scp –r <filename> root@<ipaddress>:<location>

3)      Copy DATA_TOP and DB_TOP from oracle and move it to Target System under oratest directory.

Ex : scp –r <filename> root@<ipaddress>:<location>

4)      Now change the ownerships of the moved files in the target system accordingly.

Ex: chown –R appltest:dba <filename>

      chown  –R oratest:dba  <filename>

Post Cloning Steps:

1)      DB Tier is configured first. Ex: cd $ORACLE_HOME/appsutil/clone/bin  Perl adcfgclone.pl dbTier.

2)      Enter apps password and all other relevant information.

3)      The database is started.

4)      Apps Tier is configured next. Ex: cd $COMMON_TOP/clone/bin   perl adcfgclone.pl appsTier

5)      Enter apps password and all other relevant information accordingly.

6)      After it is completed, it prompts whether to start Applications or not.

Log Files :

1)      cd $ORACLE_HOME/appsutil/log/CONTEXT NAME/*.log

2) cd $APPPL_TOP/admin/CONTEXT NAME/log/*.log or 

cd  /u01/inst/apps/PROD_ashirwad/admin/log/StageAppsTier_11021810.log(R12)

Note:    If u want to take backup use commands

            tar -cvf filename.tar <directoryname>  ß creates

            tar -xvf filename.tar <directoryname>  ß reads

            tar –C <location> -xvf filename.tar     ß untars at a particular location