Few of the customer in Middle-east uses the tape to backup the database and application binaries. whenever they need clone just they restore the backup from tape to the target server.
Here is the high level steps to do the clone of ERP from tape backup.
1) Drop the database
2) Database and binaries will be restore from Tape
3)Startup nomount
4)Take backup of controlfile from production and transfer it to target database
Production
alter database backup controlfile to trace as '/u01/backup/ctrl.sql';
Transfer to clone to server.
Copy the control file script
cp -pr ctrl.sql control_7july2018.sql
open the file "control_7july2018.sql" and check datafile path , controlfile path ,set dbname and create the controlfile.
SQL> @control_7july2018.sql
Control file created.
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
MOUNTED
SQL> alter database open resetlogs;
Database altered.
SQL> SQL> select name,created from v$database;
NAME CREATED
--------- ------------------
DEV 07-JUL-18
SQL>
Application Cloning
$ perl adcfgclone.pl appsTier
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications Rapid Clone
Version 12.0.0
adcfgclone Version 120.31.12010000.12
Enter the APPS password :
Running:
/u03/dev/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -cp /u03/dev/apps/apps_st/comn/clone/jlib/java:/u03/dev/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/u03/dev/apps/apps_st/comn/clone/jlib/ojdbc14.jar oracle.apps.ad.context.CloneContext -e /u03/dev/apps/apps_st/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_3652.lst -stage /u03/dev/apps/apps_st/comn/clone 2> /tmp/adcfgclone_3652.err; echo $? > /tmp/adcfgclone_3652.res
Log file located at /u03/dev/apps/apps_st/comn/clone/bin/CloneContext_0924114239.log
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [ctssd] :
Target System Domain Name : abc.com.bh
Target System Database SID : DEV
Target System Database Server Node [ctssd] :
Target System Database Domain Name [abc.com.bh] :
Target System Base Directory : /u03/dev
Target System Tools ORACLE_HOME Directory [/u03/dev/apps/tech_st/10.1.2] :
Target System Web ORACLE_HOME Directory [/u03/dev/apps/tech_st/10.1.3] :
Target System APPL_TOP Directory [/u03/dev/apps/apps_st/appl] :
Target System COMMON_TOP Directory [/u03/dev/apps/apps_st/comn] :
Target System Instance Home Directory [/u03/dev/inst] :
Username for the Applications File System Owner [appldev] :
Target System Root Service [enabled] :
Target System Web Entry Point Services [enabled] :
Target System Web Application Services [enabled] :
Target System Batch Processing Services [enabled] :
Target System Other Services [No] : YES
Do you want to preserve the Display [ykapps:0.0] (y/n) : n
Target System Display [ctssd:0.0] :
Do you want the the target system to have the same port values as the source system (y/n) [y] ? : n
Target System Port Pool [0-99] : 10
Checking the port pool 10
done: Port Pool 10 is free
Report file located at /u03/dev/inst/apps/DEV_ctssd/temp/portpool.lst
Complete port information available at /u03/dev/inst/apps/DEV_ctssd/temp/portpool.lst
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /usr/tmp
3. /u21/oradb/db/tech_st/11.2.0/appsutil/outbound/DEV_ykr12erp
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] : 1
Backing up /u03/dev/inst/apps/DEV_ctssd/appl/admin/DEV_ctssd.xml to /u03/dev/inst/apps/DEV_ctssd/appl/admin/DEV_ctssd.xml.bak
Creating the new APPL_TOP Context file from :
/u03/dev/apps/apps_st/appl/ad/12.0.0/admin/template/custom/adxmlctx.tmp
The new APPL_TOP context file has been created :
/u03/dev/inst/apps/DEV_ctssd/appl/admin/DEV_ctssd.xml
Log file located at /u03/dev/apps/apps_st/comn/clone/bin/CloneContext_0924114239.log
Check Clone Context logfile /u03/dev/apps/apps_st/comn/clone/bin/CloneContext_0924114239.log for details.
Running Rapid Clone with command:
perl /u03/dev/apps/apps_st/comn/clone/bin/adclone.pl java=/u03/dev/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/u03/dev/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/u03/dev/inst/apps/DEV_ctssd/appl/admin/DEV_ctssd.xml showProgress contextValidated=true
Running:
perl /u03/dev/apps/apps_st/comn/clone/bin/adclone.pl java=/u03/dev/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/u03/dev/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/u03/dev/inst/apps/DEV_ctssd/appl/admin/DEV_ctssd.xml showProgress contextValidated=true
APPS Password :
Beginning application tier Apply - Sun Sep 24 11:44:08 2017
/u03/dev/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /u03/dev/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/u03/dev/apps/apps_st/comn/clone/jlib/ojdbc14.jar:/u03/dev/apps/apps_st/comn/clone/jlib/java:/u03/dev/apps/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/u03/dev/apps/apps_st/comn/clone/jlib/oui/ewt3.jar:/u03/dev/apps/apps_st/comn/clone/jlib/oui/share.jar:/u03/dev/apps/apps_st/comn/clone/jlib/oui/srvm.jar:/u03/dev/apps/apps_st/comn/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyAppsTier -e /u03/dev/inst/apps/DEV_ctssd/appl/admin/DEV_ctssd.xml -stage /u03/dev/apps/apps_st/comn/clone -showProgress
APPS Password : Log file located at /u03/dev/inst/apps/DEV_ctssd/admin/log/ApplyAppsTier_09241144.log
- 73% completed
Completed Apply...
Sun Sep 24 12:06:39 2017
Do you want to startup the Application Services for DEV? (y/n) [y] : n
Services not started
$
No comments:
Post a Comment