We are getting lot of questions on Hot Backup Cloning of 11i in the forum. So we thought that, if we write one article regarding this, it will be more useful for the apps newbies. Here I am sharing the information that, what i follow during the hotbackup cloning. You all might have done this before.
Source System (PROD):
(a) P4 3.0 GHz System with 2GB RAM and 200 GB HDD (Redhat Linux AS 4)
/d01 ——- 40 GB (Application Tier Files)
/d02 ——- 10 GB (10g Oracle Home)
/d03 ——- 80 GB (Data Files)
/backup —- 100 GB (NFS mount point Shared on TEST Server)
Hostname: prodserver
Application Version: 11.5.10.2
Database Version: 10.2.0.2 Target System (TEST):
(b) P4 2.6 GHz system with 1.5 GB RAM with 300 GB HDD (Redhat Linux AS 4)
/d01 ——- 40 GB (Application Tier Files)
/d02 ——- 10 GB (10g Oracle Home)
/d03 ——- 80 GB (Data Files)
/backup —- 100GB (NFS Share Directory)
Hostname: testserver
Application Version: 11.5.10.2
Database Version: 10.2.0.2
Note: This target System was previously cloned with cold backup. This is second time cloning with Hot Backup from PRODSERVER.
Stage1: Prerequisites:
========> Apply OUI22 Patch, 5035661 to every IAS Oracle Home
and RDBMS Oracle Home to be cloned.
If you are having 10g Oracle Home,
there is no need of applying this patch.
You need to apply this patch on IAS Oracle Home
(if Database is not 10g)
A. Applying the patch on the iAS $ORACLE_HOME:
====================================================
(a) Unzip the patch into the <iAS ORACLE_HOME> directory:
$unzip -od /d01/prodora/iAS p5035661_11i_LINUX.zip
(b) Source the Apps environment file :
$. $APPL_TOP/APPSORA.env
(c) Change directory to the <IAS ORACLE_HOME>/appsoui/setup
$cd $IAS_ORACLE_HOME/appsoui/setup
(d) Execute the perl script OUIsetup.pl:
$perl OUIsetup.pl
NOTE:
In the case of a Multi-Node instance, the above process
should be repeated on the <iAS ORACLE_HOME> of each Node.
(B) Applying the patch on the RDBMS $ORACLE_HOME:
(This step is not required for my current setup,
because my database version is 10g R2)
(a) Unzip the patch into the <RDBMS ORACLE_HOME> directory:
$unzip -od /u01/proddb/9.2.0 p5035661_11i_LINUX.zip
(b) Source the DB environment file :
$. $ORACLE_HOME/PROD_prodserver.env
(c) Change directory to the <RDBMS ORACLE_HOME>/appsoui/setup
$cd $ORACLE_HOME/appsoui/setup
(d) Execute the perl script OUIsetup.pl:
$perl OUIsetup.pl
======> Check all other Requirements as Perl, JRE, JDK, ZIP utilities on Source and Target Nodes as per
document “Cloning Oracle Applications Release 11i with Rapid Clone”
=======> Apply the Latest AD Minipack on Application Tier (Latest One is AD.I.5)
=======è Apply the Latest Autoconfig Template Patch and Latest Rapidclone Patches to Application Tier (Check Metalink for These Patches)
Stage2: Prepare the Source System (PRODSERVER)
(a) Login into Database Tier as ORACLE user and run the preclone
$cd $ORACLE_HOME/appsutil/scripts/PROD_prodserver
$perl adpreclone.pl dbTier
(b) Login into the Application Tier as APPLMGR User and run the preclone
$cd $COMMON_TOP/admin/scripts/PROD_prodserver
$perl adpreclone.pl appsTier
Stage3: Put the Database in Begin Backup Mode and copy the Database Files
(a) Login into database as sysdba user
$sqlplus “/as sysdba”
Sql> alter database begin backup;
(b) Copy Archive log files created during hot backup to /backup directory.
(c) Copy the All Data files to /backup directory.
(d) Backup the control file to trace.
Sql> alter database backup control file to trace;
Copy this trace file to /backup directory
(e) Copy the current init.ora file to /backup directory
(f) End the Begin Backup Mode.
Sql> alter database end backup.
Stage4: Copy the Application Tier File System Files
(a)Login into the Application Tier as APPLMGR user and copy the APPL_TOP, COMMON_TOP,
IAS ORACLE HOME and 8.0.6 Oracle Home to /backup directory
Stage5: Copy the Source Database files and Application Files to Target server
Copy the parameter file, backup control file and archive log files from /backup directory
to /d01, /d02 and /d03 in target server.
Stage 6: Configure the Target Database (TESTSERVER)
Log on to the target system as the ORACLE user
(1) Configure the <RDBMS ORACLE_HOME>
cd <RDBMS ORACLE_HOME>/appsutil/clone/bin
perl adcfgclone.pl dbTechStack
(2) Create the target database control file manually
Open the backed up control file
a. remove all lines before the startup nomount statement
b. Modify the REUSE to SET
c. Modify Source DB SID to Target SID (Here PROD to TEST)
d. Modify NORESETLOGS TO RESETLOGS
e. delete all lines after the CHARACTER SET statement
————————————
CREATE CONTROLFILE SET DATABASE “TEST” NORESETLOGS ARCHIVELOG…
LOGFILEGROUP 1
‘/d03/log01.log’ SIZE 50M,
…
DATAFILE
‘/d03/system01.dbf’,
‘/d03/undotbs01.dbf’,
…
CHARACTER SET UTF8;
—————————————————–
On the target system, modify the init.ora to have the target SID and location of the control file and also make sure that init.ora parameters are set for archive log mode On the target system,
starup the database in nomount stage
sql> startup nomount pfile=< Target init.ora path>
sql> @clone.ctl ( here clone.ctl is the control file which we have modified above)
Once control file is created, database will be in mount stage
execute recover command using backup control file after the database is mounted
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
After the last archive log has been applied, issue the following command
SQL> alter database open resetlogs;
After opening the database, add temp files to target database
(3) Run the library update script against the database
cd <RDBMS ORACLE_HOME>/appsutil/install/<CONTEXT NAME sqlplus “/ as sysdba” @adupdlib.sql <libext>
Where <libext> is “sl” for HP-UX, “so” for any other UNIX platform and not required for Windows.
(4)Configure the target database (the database must be open)
cd <RDBMS ORACLE_HOME>/appsutil/clone/bin
perl adcfgclone.pl dbconfig <target context file>
where target context file is: <RDBMS ORACLE_HOME>/appsutil/<Target CONTEXT_NAME>.xml
Stage 7 : Configure the Target Application Tier
Logon to the target system as the APPLMGR user and type the following commands
$Cd $COMMON_TOP/clone/bin
$Perl adcfgclone.pl appsTier
Finishing tasks:
(1) Update Profile options
(2) Update Printer Settings
(3) Update the workflow configuration settings
(4) Verify the APPLCSF variable setting
(5) Update the session_cookie_domain value in icx_parameters
For the finishing tasks, check the finishing tasks section of the following document
Cloning Oracle Applications Release 11i with rapid clone Note: 230672.1
Popularity: 12% [?]
Good hands-on exercises (installation, patching, cloning), very experienced trainer worth for Money 
46 users commented in " Oracle Applications 11i Hot Backup Cloning with Rapid Clone "
Follow-up comment rss or Leave a TrackbackHi Subbu,
Its a good post .What is the significance of applying OUI22 Patch, 5035661 to every IAS Oracle Home and running perl OUIsetup.pl ?
Hi vasanth,
Thanks,
OUI22 Patch is the prerequisite, if you want to clone using rapid clone. You have to upgrade the Oracle Universal Installer to Version 2. If you dont, you will get errors while running preclone on source system(while creating stage area for clone).
For more, please check the following note
perl adpreclone.pl dbTier returns “RC-00012: Error while creating cloning stage area” Note:392887.1
Regards,
SubbaRao
Thanks .
hey it s very nice Vasanth
What nice raghu,
Regards,
SubbaRao
Hi,
Please can any body tell me , how to do a cloning without running adpreclone script in source system.
Thanks,
reddy
Hi Reddy,
As far as I know, if you are doing cloning with rapid clone, for first time, if you are doing cloning to target system. It’s must to run the preclone in the source system.
Thanks,
SubbaRao
Hi SubbaRao,
Thanks,
Reddy
Always welcome my friend,
Regards,
SubbaRao
Hi Subba,
This is an excellent article…..thank you very much for your efforts and keep up the good work…
thanks,
Virendra Patel
Hi Virendra,
Thank you,
I really appreciate your words,
Regards,
SubbaRao
Good one , I tried this and it worked perfectly. Thanks for posting this.
Hi Anony,
Thanks.
Always welcome my friend.
Regards,
SubbaRao
Hi,
Please can anyone give me the syllabus for Oracle 10g OCP and procedure to do.
Thanks,
Reddy
Reddy,
Please check the following links
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=151
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=41&p_exam_id=1Z0_042
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=41&p_exam_id=1Z0_043
Those links contains engough information
Hope it helps, Good Luck
Regards,
SubbaRao
Hello SubbaRao,
Could you tell me how you copy all the files from source machine to the target machine? I’ve tried wget, but it didn’t work.
Thank you in advance.
Best regards,
Lilian
Hi Lilian,
==========================
take backup using tar in source system and copy the tar files to target machine.
for example, if /u05 is the application partition, as a root user take tar backup
#tar -cvf /backup/u05.tar /u05
copy the u05.tar to target machine using ftp or sftp and extract the files
#cd /u05
#tar -xvf /backup/u05.tar
=====================
apart from tar, you can also try the rsync command,if rsync is installed
===> NFS mount the source partion to target machine
# mount -f nfs source_system:/u05 /target_mount
#rsync -avz /target_mount /u05
================================
You can also use cpio with find
NFS mount /u05 of source system to /target_mount point
#mount -f nfs source_system:/u05 /target_mount
#cd /target_mount
#find . -print | cpio -pmdV /u05
========================
Hope it helps,
Good Luck,
Regards,
Subbarao
Hello Subbarao,
It’s very kind of you to have replied me so quickly.
Thank you very much.
Best regards,
Lilian
Always welcome my friend,
Regards,
Subbu
Hi
Can you please explain finishing task:
(2) Update Printer Settings
and another thing what all changes are required if I am not using standard ports
Thanks
Hi,
Thanks much for the great write up. Helped immensly.
I’m running into one issue. When trying to launch forms from the Self Service Page i get an error.
Bad Request.
Your browser sent a request the server can not understand.
Any suggestions would be great!
Thanks
Hi,
is it possible to view the concurrent manager log/output files(in target system) from source after being cloned to target?
Yes, copy log & out files to target instance from source and update table FND_CONCURRENT_REQUESTS for column values LOGFILE_NAME & OUTFILE_NAME to new location.
Check metalink note 230672.1 Cloning Oracle Applications Release 11i with Rapid Clone
Under Section 3 in finishing tasks “Update workflow configuration settings”
hi subbu,
Very nice post.
Can u please explain me where i can get information or logs related to :
In Oracle Apps 11i
1.When we submit URL request in browser to access the front-end of applications…
What exactly happens in the background…say which template or php from which location is first called…ie
i)self serviced applications
ii)web applications
iii)mobile applications..
What are all the files/process involved in getting the front-end till we get the login page..
Please help me with above…
I am really confused..
Check this for overview
for list of files/directories involved stay tunes to this post
http://onlineappsdba.com/index.php/2006/08/01/oracle-applications-request-flow
Thanks Atul,
Your post is really helpful..
Could u please further give logfile location
of the actions involved in these processes..
Hi Rao,
Nice docuemnt…Actually i want to clone/restore production instance database to Test instance database.
We are taking RMAN backup daily…Can you tell me without shutting down the produciton instance how i can clone prod database to test database.
thanks
Regards
Bala
Hi Subbu,
Are you missing the step to copy RDBMS ORACLE HOME from prodserver to testserver?
Moses
Hi moses,
In Stage 5,I mentioned to copy the Oracle Home to target /d02 Partition ( Target Server).
Regards,
SubbaRao
hi, thanks for such a nice article.
I have a question.
Suppose I have followed all the steps you mentioned in this article and set up the test system.
Now, one week later, I want to update my test system with the changes which took place in the production. My question is regarding the cloning of DB tier. Do I need to copy the entire system everytime(i.e. Oracle Home and the DBFs) or is it sufficient to copy the modified DBFs and new archive logs from production. Could you please explain how do i update my test system with the changes from production.
Thanks,
Hi,
If you did not apply any database patches and Application patches in Production after first cloning, then you can just copy the All Database Files and Archive logs to target system and create the controlfile as specified above.
Regards,
SubbaRao
Hi Subba,
Do you have this document for windows ? I am planning to clone apps/db to test servers. Test servers already have a clonned copy but its very old. what is the best method to clone in this situation. I am doing this for the first time also the prod has millions of records. Do I need to have oracle installed on target systems
Hi SP,
You no need to install oracle in target system. If you have hot backup of Production, just follow the above procedure or if you have Cold Backup of Production, please follow the given document, it is very easy to understand.
Cloning Oracle Applications Release 11i with rapid clone Note: 230672.1
If you have any doubts, post here, we will help you.
Regards,
SubbaRao
Hi subbarao/Atul,
i am doing cloning with the help of this document .
but here is nothing related with ORACLE_HOME.
should we copy RDBMS ORACLE HOME from source to copy or there is no need. adcfgclone will automatically create this?
please reply back asap.
waiting for your reply
thanx in advance
akshay
Hi Akshay,
If you are first time doing the Cloning in target system. You need to copy RDBMS ORACLE_HOME to Target System. Cfgclone will not create target oracle home.
If targe RDBMS oracle home is already there and you did not apply database patches, then no need to copy the RDBMS oracle home.
If you still don’t understand, please let me know.
Hope it helps,
Good Luck,
Regards,
SubbaRao
Hi subbarao/Atul,
Thanks for reply.
I was able to do with this document.
Now i have to write a script for autometed cloning.
But i am not able to understand from where i should start, if you gone through this type of scenerio previously then please help to write a shell script.
i have never done the shell script before.
waiting for your reply.
Thanks and regards,
akshay
Hello Buddy,
Thanks a lot, it’s really a good document. I learnt a new thing. Thanks again.
Regards,
Sandeep
Hi Sandeep,
always welcome my friend.
Regards,
SubbaRao
Dear Mr.Subbarao,
Can i get steps for automated cloning.
If possible some scheduling of cloning in R12
12.0.5
on HP-unix platform
and from multi node to single node
Hi friends,
i have a doubt on Step 6(Point 4):
perl adcfgclone.pl dbconfig
whether we need to create target context file?i believe the adcfgclone script only creates context file in normal cloning.so here the target context file referred is already created or we need to create?
Hi Arun,
The command
perl adcfgclone.pl dbTechStack will create target context file based on the information you provided.
once this command is finised, you will have target contxt file created
to the below command, you have to provide the target context file created above
perl adconfig.pl dbconfig will update the database tables with the information of context file.
Hope it is clear.
Regards,
Subbarao
Dear SubbaRao,
Thanks for the information.By the way what is the Metalink doc ID for this Hotbackup Cloning.
Thanks and Regards,
Arun
Hi,
please refer the Appendix B of the below metalink document. ( Last One)
Cloning Oracle Applications Release 11i with Rapid Clone Doc ID: 230672.1
Today I have seen one document, it might be helpful.
Cloning Oracle Application 11i /R12 with Rapid Clone - Database (9i/10g/11g) Using Hot Backup on Open Database Doc ID: 760772.1
Good Luck,
Regards,
Subbarao
HI,
I need to do rman clonning from ASM to non asm instance as my PROD DB is running on ASM on r12 and the test , dev environments are on non ASM.
kindly can you tell me the steps for that
HI,
I have 2 node application r12 db is running on ASM and the backup is taken by RMAN can u tell the steps for doing clonning
Dear Subba,
Very nice artical.
Please tell me if I want to keep my Target system uptodate with source system on daily basis, what should I do further?
My data changes made in source system should be applied in target system.
Please suggest.
Regards,
Gaurav
Leave A Reply