Step by Step process of R12.2.X cloning [application and DB]

 Step by Step R12.2 cloning (Application and DB)


1. Pre-Clone


we can take a backup of the files below:

EBSapps.env

$CONTEXT_FILE

$TNS_ADMIN

$ORACLE_HOME/dbs ==> Password file and parameter file

Create pfile from spfile

Create controlfile from trace

$<Custom_TOP>


2. Check Disk Space on the Source system and Target


3. Prepare  Source Instance ( Primary DB)


Check for in-progress online patching cycle. online patching should be done till cleanup stage and also fs_clone should be run to synchronize with the application file system RUN and PATCH.


4. Source  DB Tier


Methods can be followed for refresh -


- Cold backup

- Hot backup

- Rman backup ( But we will prefer rman tool for cloning )


5. After Rman cloning completed. bringup target database and Run adpreclone.pl script


cd $ORACLE_HOME/appsutil/scripts/${CONTEXT_NAME}


perl adpreclone.pl dbTier


6. Target Apps Server: Apps Tier


Log on to the Application node of the Source System as the ebsamdi user (depends on ur user. lot of people using applmgr ).


Source the environment file of the Run Edition File system.

          

$. EBSapps.env run


***** When you do cloning make to sure to note down the run file system in the source. If your source has fs1 has the run file system then we must refresh fs1 as run file system in the target. If source has fs2 in run file system then we must refresh fs2 as run file system in the target.




example: If my run file system is in fs2 in source then i would do the below.


 - Make fs2 in target (Run file system first)

 - Make fs1 from fs2 (Patch file system)


7. Run adpreclone.pl script


Check edition , should run file system


echo $FILE_EDITION

Execute adpreclone

$cd $ADMIN_SCRIPTS_HOME

$perl adpreclone.pl appsTier


8. Cleanup Target Application File System


Remove application directory structure from target application instance under $RUN_BASE and $PATCH_BASE in the target application tier system.


$. EBSapps.env run


$ cd /a01/apps/CLONE/


$ ls


EBSapps.env   L2866958.log  L2866963.log  fs1           fs2           fs_ne         scripts


$ pwd

/a01/apps/CLONE/

$ rm -rf *


Once everything is deleted make a empty directories for run and patch file system.


mkdir -p /a01/apps/CLONE/fs1

mkdir - /a01/apps/CLONE/fs2




Comments

Popular posts from this blog

ORA-01565: error in identifying file '?/dbs/spfile@.ora'

Reboot Exadata Machine

How to combine Oracle .ova files