Oracle Apps R12 cloning online hotbackup/rman
http://appsdbaworkshop.blogspot.in/2013/02/oracle-apps-r12-cloning-online.html
In this article i will illustrate all steps involved in cloning an Oracle E-Business suite environment using online backup.
There are other ways also to do a clone of database with online backup. But in this article I am illustrating rman database cloning with nocatalog option.
- Database will be backed up using rman
- Application File system will be backed up when all services are up and running.
source system - Existing system for which you want to create a new copy
target system - New system on which clone is prepared
Source and target OS - oracle solaris 10 - sparc 64-bit
Application Version - R12.1.1
Database Version - 11.1.0.7
High Level Steps:
1. Install all required rapid clone patches from Note "406982.1" on source system if doesn't exists.
2. Run clone preparation script (adpreclone.pl) on database and application Tier
3. Perform full database backup using rman
4. Perform application file system backup using tar/backup tool
5. Copy RDBMS ORACLE_HOME, rman backup pieces and Application FS on target node
6. Create database context file using clone configuration script (adcfgclone.pl)
7. Restore and recover database using rman
8. Run autoconfig on target database node
9. Run clone configuration script on application Tier on targte node.
10. perform post clone steps
Source System Application dash board:
Source and Target system Information:
check pre-req patches on source system:
- Perform all OS pre-requisites on target system (OS packages, users, groups, kernel parameters, Display, File system privileges and space requirements)
For LINUX refer section "Perform all operating system per-requisites":
http://appsdbaworkshop.blogspot.com/2011/11/installation-of-oracle-applications.html
For Solaris refer:
http://appsdbaworkshop.blogspot.com/2010/11/oracle-applications-r1211-installation.html
SQL> select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='&num';
Enter value for num: 9239089
old 1: select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='&num'
new 1: select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='9239089'
BUG_ID BUG_NUMBER
---------- ------------------------------
374712 9239089
SQL> /
Enter value for num: 9171651
old 1: select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='&num'
new 1: select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='9171651'
BUG_ID BUG_NUMBER
---------- ------------------------------
375423 9171651
SQL> /
Enter value for num: 9833058
old 1: select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='&num'
new 1: select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='9833058'
BUG_ID BUG_NUMBER
---------- ------------------------------
375424 9833058
SQL> /
Enter value for num: 12404574
old 1: select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='&num'
new 1: select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='12404574'
BUG_ID BUG_NUMBER
---------- ------------------------------
375421 12404574
SQL> /
Enter value for num: 12598630
old 1: select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='&num'
new 1: select BUG_ID, BUG_NUMBER from ad_bugs where bug_number='12598630'
BUG_ID BUG_NUMBER
---------- ------------------------------
375422 12598630
Run clone preparation script (adpreclone.pl) on database Tier:
bash-3.00$ adpreclone.pl dbTier
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications Rapid Clone
Version 12.0.0
adpreclone Version 120.20.12010000.5
Enter the APPS User Password:
Running:
perl
/data/R12_ERP/db/tech_st/11.1.0/appsutil/bin/adclone.pl
java=/data/R12_ERP/db/tech_st/11.1.0/appsutil/jre mode=stage
stage=/data/R12_ERP/db/tech_st/11.1.0/appsutil/clone component=dbTier
method=CUSTOM
dbctx=/data/R12_ERP/db/tech_st/11.1.0/appsutil/ERPTEST_devdb.xml
showProgress
APPS Password :
Beginning database tier Stage - Sun Feb 3 11:45:39 2013
/data/R12_ERP/db/tech_st/11.1.0/appsutil/jre/bin/java
-Xmx600M -DCONTEXT_VALIDATED=false
-Doracle.installer.oui_loc=/data/R12_ERP/db/tech_st/11.1.0/oui
-classpath
/data/R12_ERP/db/tech_st/11.1.0/lib/xmlparserv2.jar:/data/R12_ERP/db/tech_st/11.1.0/jdbc/lib/ojdbc6.jar:/data/R12_ERP/db/tech_st/11.1.0/appsutil/java:/data/R12_ERP/db/tech_st/11.1.0/oui/jlib/OraInstaller.jar:/data/R12_ERP/db/tech_st/11.1.0/oui/jlib/ewt3.jar:/data/R12_ERP/db/tech_st/11.1.0/oui/jlib/share.jar:/data/R12_ERP/db/tech_st/11.1.0/oui/jlib/srvm.jar:/data/R12_ERP/db/tech_st/11.1.0/jlib/ojmisc.jar
oracle.apps.ad.clone.StageDBTier -e
/data/R12_ERP/db/tech_st/11.1.0/appsutil/ERPTEST_devdb.xml -stage
/data/R12_ERP/db/tech_st/11.1.0/appsutil/clone -tmp /tmp -method
CUSTOM -showProgress
APPS Password :
Log file located at /data/R12_ERP/db/tech_st/11.1.0/appsutil/log/ERPTEST_devdb/StageDBTier_02031145.log
- 50% completed
Completed Stage...
Sun Feb 3 11:48:10 2013
bash-3.00$
Run clone preparation script (adpreclone.pl) on Application Tier:
bash-3.00$ adopmnctl.sh status
You are running adopmnctl.sh version 120.6.12010000.4
Checking status of OPMN managed processes...
Processes in Instance: ERPTEST_devappl.devaappl.orasol.com
---------------------------------+--------------------+---------+---------
ias-component | process-type | pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group | OC4J:oafm | 28611 | Alive
OC4JGroup:default_group | OC4J:forms | 28580 | Alive
OC4JGroup:default_group | OC4J:oacore | 28503 | Alive
HTTP_Server | HTTP_Server | 28450 | Alive
adopmnctl.sh: exiting with status 0
adopmnctl.sh:
check the logfile
/appl/R12_ERP/inst/apps/ERPTEST_devappl/logs/appl/admin/log/adopmnctl.txt
for more information ...
bash-3.00$ adpreclone.pl appsTier
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications Rapid Clone
Version 12.0.0
adpreclone Version 120.20.12010000.5
Running:
perl
/appl/R12_ERP/apps/apps_st/appl/ad/12.0.0/bin/adclone.pl
java=/appl/R12_ERP/apps/tech_st/10.1.3/appsutil/jdk mode=stage
stage=/appl/R12_ERP/apps/apps_st/comn/clone component=appsTier method=
appctx=/appl/R12_ERP/inst/apps/ERPTEST_devappl/appl/admin/ERPTEST_devappl.xml
showProgress
APPS Password :
method defaulted to CUSTOM
Beginning application tier Stage - Sun Feb 3 11:54:33 2013
/appl/R12_ERP/apps/tech_st/10.1.3/appsutil/jdk/bin/java
-Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui
-classpath
/appl/R12_ERP/apps/tech_st/10.1.3/lib/xmlparserv2.jar:/appl/R12_ERP/apps/tech_st/10.1.3/jdbc/lib/ojdbc14.jar:/appl/R12_ERP/apps/apps_st/comn/java/classes:/appl/R12_ERP/apps/tech_st/10.1.3/oui/jlib/OraInstaller.jar:/appl/R12_ERP/apps/tech_st/10.1.3/oui/jlib/ewt3.jar:/appl/R12_ERP/apps/tech_st/10.1.3/oui/jlib/share.jar:/appl/R12_ERP/apps/tech_st/10.1.3/oui/jlib/srvm.jar:/appl/R12_ERP/apps/tech_st/10.1.3/jlib/ojmisc.jar
oracle.apps.ad.clone.StageAppsTier -e
/appl/R12_ERP/inst/apps/ERPTEST_devappl/appl/admin/ERPTEST_devappl.xml
-stage /appl/R12_ERP/apps/apps_st/comn/clone -tmp /tmp -method CUSTOM
-showProgress
Log file located at /appl/R12_ERP/inst/apps/ERPTEST_devappl/admin/log/StageAppsTier_02031154.log
\ 80% completed
Completed Stage...
Sun Feb 3 11:57:14 2013
Perform full database RMAN backup:
bash-3.00$ rman target /
Recovery Manager: Release 11.1.0.7.0 - Production on Sun Feb 3 12:05:35 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: ERPTEST (DBID=1262470248)
RMAN> RUN {
2> configure controlfile autobackup format for device type diks to '/data/R12_ERP/rman_backup/3feb2013_Bkp/%F';
3> configure controlfile autobackup on;
4> allocate channel d1 type disk;
5> backup tag FULL_DB database plus archivelog format '/data/R12_ERP/rman_backup/3feb2013_Bkp/db_%t_%s.bkp';
6> release channel d1;
7> }
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'DIKS' TO '/data/R12_ERP/rman_backup/3feb2013_Bkp/%F';
new RMAN configuration parameters are successfully stored
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
allocated channel: d1
channel d1: SID=359 device type=DISK
Starting backup at 03-FEB-13
current log archived
channel d1: starting archived log backup set
channel d1: specifying archived log(s) in backup set
input archived log thread=1 sequence=22 RECID=1 STAMP=805281948
input archived log thread=1 sequence=23 RECID=2 STAMP=805282565
input archived log thread=1 sequence=24 RECID=3 STAMP=806418436
channel d1: starting piece 1 at 03-FEB-13
channel d1: finished piece 1 at 03-FEB-13
piece handle=/data/R12_ERP/rman_backup/3feb2013_Bkp/db_806418437_7.bkp tag=FULL_DB comment=NONE
channel d1: backup set complete, elapsed time: 00:00:25
Finished backup at 03-FEB-13
Starting backup at 03-FEB-13
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00023 name=/data/R12_ERP/db/apps_st/data/a_txn_data02.dbf
input datafile file number=00025 name=/data/R12_ERP/db/apps_st/data/a_txn_ind01.dbf
input datafile file number=00022 name=/data/R12_ERP/db/apps_st/data/a_txn_data01.dbf
input datafile file number=00024 name=/data/R12_ERP/db/apps_st/data/a_txn_data03.dbf
input datafile file number=00026 name=/data/R12_ERP/db/apps_st/data/a_txn_ind02.dbf
input datafile file number=00027 name=/data/R12_ERP/db/apps_st/data/a_txn_ind03.dbf
input datafile file number=00029 name=/data/R12_ERP/db/apps_st/data/a_txn_ind05.dbf
input datafile file number=00012 name=/data/R12_ERP/db/apps_st/data/undo01.dbf
input datafile file number=00028 name=/data/R12_ERP/db/apps_st/data/a_txn_ind04.dbf
input datafile file number=00009 name=/data/R12_ERP/db/apps_st/data/system09.dbf
input datafile file number=00008 name=/data/R12_ERP/db/apps_st/data/system08.dbf
input datafile file number=00020 name=/data/R12_ERP/db/apps_st/data/a_ref02.dbf
input datafile file number=00019 name=/data/R12_ERP/db/apps_st/data/a_ref01.dbf
input datafile file number=00015 name=/data/R12_ERP/db/apps_st/data/a_media01.dbf
input datafile file number=00006 name=/data/R12_ERP/db/apps_st/data/system06.dbf
input datafile file number=00014 name=/data/R12_ERP/db/apps_st/data/a_int01.dbf
input datafile file number=00021 name=/data/R12_ERP/db/apps_st/data/a_summ01.dbf
input datafile file number=00004 name=/data/R12_ERP/db/apps_st/data/system04.dbf
input datafile file number=00010 name=/data/R12_ERP/db/apps_st/data/system10.dbf
input datafile file number=00002 name=/data/R12_ERP/db/apps_st/data/system02.dbf
input datafile file number=00003 name=/data/R12_ERP/db/apps_st/data/system03.dbf
input datafile file number=00001 name=/data/R12_ERP/db/apps_st/data/system01.dbf
input datafile file number=00005 name=/data/R12_ERP/db/apps_st/data/system05.dbf
input datafile file number=00011 name=/data/R12_ERP/db/apps_st/data/system11.dbf
input datafile file number=00007 name=/data/R12_ERP/db/apps_st/data/system07.dbf
input datafile file number=00013 name=/data/R12_ERP/db/apps_st/data/a_archive01.dbf
input datafile file number=00038 name=/data/R12_ERP/db/apps_st/data/a_txn_data4.dbf
input datafile file number=00017 name=/data/R12_ERP/db/apps_st/data/a_queue01.dbf
input datafile file number=00018 name=/data/R12_ERP/db/apps_st/data/a_queue02.dbf
input datafile file number=00036 name=/data/R12_ERP/db/apps_st/data/apps_ts_tools01.dbf
input datafile file number=00035 name=/data/R12_ERP/db/apps_st/data/sysaux01.dbf
input datafile file number=00037 name=/data/R12_ERP/db/apps_st/data/interim.dbf
input datafile file number=00031 name=/data/R12_ERP/db/apps_st/data/odm.dbf
input datafile file number=00032 name=/data/R12_ERP/db/apps_st/data/olap.dbf
input datafile file number=00034 name=/data/R12_ERP/db/apps_st/data/portal01.dbf
input datafile file number=00016 name=/data/R12_ERP/db/apps_st/data/a_nolog01.dbf
input datafile file number=00030 name=/data/R12_ERP/db/apps_st/data/ctxd01.dbf
input datafile file number=00033 name=/data/R12_ERP/db/apps_st/data/owad01.dbf
channel d1: starting piece 1 at 03-FEB-13
channel d1: finished piece 1 at 03-FEB-13
piece handle=/data/R12_ERP/db/tech_st/11.1.0/dbs/08o11u10_1_1 tag=FULL_DB comment=NONE
channel d1: backup set complete, elapsed time: 00:09:55
Finished backup at 03-FEB-13
Starting backup at 03-FEB-13
current log archived
channel d1: starting archived log backup set
channel d1: specifying archived log(s) in backup set
input archived log thread=1 sequence=25 RECID=4 STAMP=806419062
channel d1: starting piece 1 at 03-FEB-13
channel d1: finished piece 1 at 03-FEB-13
piece handle=/data/R12_ERP/rman_backup/3feb2013_Bkp/db_806419062_9.bkp tag=FULL_DB comment=NONE
channel d1: backup set complete, elapsed time: 00:00:01
Finished backup at 03-FEB-13
Starting Control File Autobackup at 03-FEB-13
piece handle=/data/R12_ERP/db/tech_st/11.1.0/dbs/c-1262470248-20130203-00 comment=NONE
Finished Control File Autobackup at 03-FEB-13
released channel: d1
RMAN>
Restore backup of database and application on Target Node:
- RDBMS Oracle Home
bash-3.00$ pwd
/data/R12_ERP/db
bash-3.00$ ls
apps_st tech_stbash-3.00$ tar -cvf DbHome.tar tech_st
bash-3.00$ ls
DbHome.tar apps_st tech_st
bash-3.00$ scp DbHome.tar oraclone@testappl:/appl/ERP_CLONE/dbclone
The authenticity of host 'testappl (10.10.17.53)' can't be established.
RSA key fingerprint is 04:b2:6a:ac:28:90:12:45:cd:2c:a1:56:fe:cd:2b:a1.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'testappl,10.10.17.53' (RSA) to the list of known hosts.
Password:
DbHome.tar
100%
|****************************************************************************************************|
12370 MB 10:37
bash-3.00$
bash-3.00$ scp /data/R12_ERP/db/tech_st/11.1.0/dbs/c-1262470248-20130203-00 oraclone@testappl:/appl/rman_backup
Password:
c-1262470248-2013020 100% |************************************************************************************************
bash-3.00$ scp -r /data/R12_ERP/rman_backup/3feb2012_backup oraclone@testappl:/appl/rman_backup
Password:
ERPTEST_DB_06o11r42_ 100% |************************************************************************************************
ERPTEST_DB_05o11qhe_ 100% |************************************************************************************************
- On Target Node testappl
bash-3.00$ pwd
/appl/ERP_CLONE/dbclone
bash-3.00$ tar -xvf DbHome.tar
Running Clone Configuration script on database Tier using dbTechStack option:
bash-3.00$ pwd
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/bin
bash-3.00$ ls
adcfgclone.pl adchkutl.sh adclone.pl adclonectx.pl
bash-3.00$ export PATH=/usr/ccs/bin:/usr/bin:/usr/ucb:/etc:.
bash-3.00$ perl adcfgclone.pl dbTechStack
Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA
Oracle Applications Rapid Clone
Version 12.0.0
adcfgclone Version 120.31.12010000.8
Enter the APPS password :
Running:
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/bin/../jre/bin/java
-Xmx600M -cp
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/jlib/java:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/jlib/xmlparserv2.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/jlib/ojdbc5.jar
oracle.apps.ad.context.CloneContext -e
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/bin/../context/db/CTXORIG.xml
-validate -pairsfile /tmp/adpairsfile_1233.lst -stage
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone -dbTechStack
2> /tmp/adcfgclone_1233.err; echo $? >
/tmp/adcfgclone_1233.res
Log file located at /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/bin/CloneContext_0204091224.log
Provide the values required for creation of the new Database Context file.
Target System Hostname (virtual or normal) [testappl] :
Target Instance is RAC (y/n) [n] :
Target System Database SID : CLONE
Target System Base Directory : /appl/ERP_CLONE/dbclone
Target System utl_file_dir Directory List : /usr/tmp
Number of DATA_TOP's on the Target System [1] :
Target System DATA_TOP Directory 1 [/data/R12_ERP/db/apps_st/data] : /appl/ERP_CLONE/dbclone/clone_data
Target System RDBMS ORACLE_HOME Directory [/appl/ERP_CLONE/dbclone/db/tech_st/11.1.0] : /appl/ERP_CLONE/dbclone/tech_st/11.1.0
Do you want to preserve the Display [null] (y/n) : n
Target System Display [testappl: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] : 22
Checking the port pool 22
done: Port Pool 22 is free
Report file located at /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/temp/portpool.lst
Complete port information available at /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/temp/portpool.lst
Creating the new Database Context file from :
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/template/adxdbctx.tmp
The new database context file has been created :
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/CLONE_testappl.xml
Log file located at /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/bin/CloneContext_0204091224.log
Check Clone Context logfile /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/bin/CloneContext_0204091224.log for details.
Running Rapid Clone with command:
perl
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/bin/adclone.pl
java=/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/bin/../jre
mode=apply stage=/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone
component=dbTechStack method=CUSTOM
dbctxtg=/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/CLONE_testappl.xml
showProgress contextValidated=true
Running:
perl
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/bin/adclone.pl
java=/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/bin/../jre
mode=apply stage=/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone
component=dbTechStack method=CUSTOM
dbctxtg=/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/CLONE_testappl.xml
showProgress contextValidated=true
APPS Password :
Beginning rdbms home Apply - Mon Feb 4 09:13:28 2013
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/bin/../jre/bin/java
-Xmx600M -DCONTEXT_VALIDATED=true
-Doracle.installer.oui_loc=/appl/ERP_CLONE/dbclone/tech_st/11.1.0/oui
-classpath
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/jlib/xmlparserv2.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/jlib/ojdbc6.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/jlib/java:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/jlib/oui/OraInstaller.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/jlib/oui/ewt3.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/jlib/oui/share.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/jlib/oui/srvm.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone/jlib/ojmisc.jar
oracle.apps.ad.clone.ApplyDBTechStack -e
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/CLONE_testappl.xml
-stage /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/clone
-showProgress
APPS Password : Log file located at
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/log/CLONE_testappl/ApplyDBTechStack_02040913.log
\ 0% completed
Completed Apply...
Mon Feb 4 09:16:10 2013
Starting database listener for CLONE:
Running:
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/scripts/CLONE_testappl/addlnctl.sh start CLONE
Logfile: /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/log/CLONE_testappl/addlnctl.txt
You are running addlnctl.sh version 120.1.12010000.4
Starting listener process CLONE ...
LSNRCTL for Solaris: Version 11.1.0.7.0 - Production on 04-FEB-2013 09:16:10
Copyright (c) 1991, 2008, Oracle. All rights reserved.
Starting /appl/ERP_CLONE/dbclone/tech_st/11.1.0/bin/tnslsnr: please wait...
TNSLSNR for Solaris: Version 11.1.0.7.0 - Production
System parameter file is /appl/ERP_CLONE/dbclone/tech_st/11.1.0/network/admin/CLONE_testappl/listener.ora
Log messages written to /appl/ERP_CLONE/dbclone/tech_st/11.1.0/admin/CLONE_testappl/diag/tnslsnr/testappl/clone/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testappl.orasol.com)(PORT=1543)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=testappl.orasol.com)(PORT=1543)))
STATUS of the LISTENER
------------------------
Alias CLONE
Version TNSLSNR for Solaris: Version 11.1.0.7.0 - Production
Start Date 04-FEB-2013 09:16:11
Uptime 0 days 0 hr. 0 min. 4 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /appl/ERP_CLONE/dbclone/tech_st/11.1.0/network/admin/CLONE_testappl/listener.ora
Listener Log File /appl/ERP_CLONE/dbclone/tech_st/11.1.0/admin/CLONE_testappl/diag/tnslsnr/testappl/clone/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testappl.orasol.com)(PORT=1543)))
Services Summary...
Service "CLONE" has 1 instance(s).
Instance "CLONE", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
addlnctl.sh: exiting with status 0
addlnctl.sh:
check the logfile
/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/log/CLONE_testappl/addlnctl.txt
for more information ...
bash-3.00$
• Change ORACLE_SID to ERP test in newly created enviroment file
As we are not using catalog database from target we need to first restore and recover database using the same source SID. Later we can change it to required SID (CLONE) using "nid"
bash-3.00$ ls -l *.env
-rw-r--r-- 1 oraclone dbaclone 4382 Feb 4 09:29 CLONE_testappl.env
-rw-r--r-- 1 oraclone dbaclone 4225 Jan 20 15:14 ERPTEST_devdb.env
bash-3.00$ pwd
/appl/ERP_CLONE/dbclone/tech_st/11.1.0
bash-3.00$
ORACLE_SID="ERPTEST"
export ORACLE_SID
#Original Value is CLONE, replaced for restore and recover of rman db
• copy initCLONE.ora to initERPTEST.ora
• Edit db_name to ERPTEST instead of clone in newly copied file and make sure location of control file
db_name = ERPTEST
control_files = /appl/ERP_CLONE/dbclone/clone_data/cntrl01.dbf
Restore and Recover database using rman on target Node:
- startup nomount
SQL> startup nomount
ORACLE instance started.
Total System Global Area 1069252608 bytes
Fixed Size 2109352 bytes
Variable Size 427823192 bytes
Database Buffers 624951296 bytes
Redo Buffers 14368768 bytes
SQL>
- List backup piece of controlfile on source system (devdb)
RMAN> list backup of controlfile;
using target database control file instead of recovery catalog
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 40.27M DISK 00:00:02 21-JAN-13
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20130121T092605
Piece Name: /data/R12_ERP/rman_backup/ERPTEST_DB_03nvv8o3_3_1
Control File Included: Ckp SCN: 77924707 Ckp time: 21-JAN-13
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6 Full 40.27M DISK 00:00:03 03-FEB-13
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20130203T120813
Piece Name: /data/R12_ERP/rman_backup/3feb2012_backup/ERPTEST_DB_06o11r42_6_1
Control File Included: Ckp SCN: 78217166 Ckp time: 03-FEB-13
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10 Full 40.27M DISK 00:00:02 03-FEB-13
BP Key: 10 Status: AVAILABLE Compressed: NO Tag: TAG20130203T131743
Piece Name: /data/R12_ERP/db/tech_st/11.1.0/dbs/c-1262470248-20130203-00
Control File Included: Ckp SCN: 78223859 Ckp time: 03-FEB-13
- Restore controlfile and mount database
bash-3.00$ pwd
/appl/rman_backup/3feb2012_backup
bash-3.00$ ls -lrt
total 48953331
-rw-r----- 1 oraclone dbaclone 42237952 Feb 3 14:14 c-1262470248-20130203-00
-rw-r----- 1 oraclone dbaclone 42237952 Feb 3 14:15 ERPTEST_DB_06o11r42_6_1
-rw-r----- 1 oraclone dbaclone 24959320064 Feb 3 14:37 ERPTEST_DB_05o11qhe_5_1
bash-3.00$ pwd
/appl/rman_backup/3feb2012_backup
bash-3.00$ rman target / nocatalog
Recovery Manager: Release 11.1.0.7.0 - Production on Mon Feb 4 10:08:26 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: ERPTEST (not mounted)
using target database control file instead of recovery catalog
RMAN> restore controlfile from '/appl/rman_backup/3feb2012_backup/c-1262470248-20130203-00';
Starting restore at 04-FEB-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=383 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/appl/ERP_CLONE/dbclone/clone_data/cntrl01.dbf
Finished restore at 04-FEB-13
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
- Catalog backup Pieces ( not required if location of rman bkp same on target)
RMAN> catalog backuppiece '/appl/rman_backup/3feb2012_backup/ERPTEST_DB_06o11r42_6_1';
cataloged backup piece
backup piece handle=/appl/rman_backup/3feb2012_backup/ERPTEST_DB_06o11r42_6_1 RECID=10 STAMP=806494720
RMAN> catalog backuppiece '/appl/rman_backup/3feb2012_backup/ERPTEST_DB_05o11qhe_5_1';
cataloged backup piece
backup piece handle=/appl/rman_backup/3feb2012_backup/ERPTEST_DB_05o11qhe_5_1 RECID=11 STAMP=806494728
RMAN> catalog backuppiece '/appl/rman_backup/3feb2012_backup/db_806418437_7.bkp';
cataloged backup piece
backup piece handle=/appl/rman_backup/3feb2012_backup/db_806418437_7.bkp RECID=12 STAMP=806498596
RMAN> catalog backuppiece '/appl/rman_backup/3feb2012_backup/db_806419062_9.bkp';
cataloged backup piece
backup piece handle=/appl/rman_backup/3feb2012_backup/db_806419062_9.bkp RECID=13 STAMP=806498610
- Prepare script for rman restore and run script (If target location is same "ste newname" not required)
bash-3.00$ cat rman_restore.sql
run {
set newname for datafile 1 to '/appl/ERP_CLONE/dbclone/clone_data/system01.dbf';
set newname for datafile 2 to '/appl/ERP_CLONE/dbclone/clone_data/system02.dbf';
set newname for datafile 3 to '/appl/ERP_CLONE/dbclone/clone_data/system03.dbf';
set newname for datafile 4 to '/appl/ERP_CLONE/dbclone/clone_data/system04.dbf';
set newname for datafile 5 to '/appl/ERP_CLONE/dbclone/clone_data/system05.dbf';
set newname for datafile 6 to '/appl/ERP_CLONE/dbclone/clone_data/system06.dbf';
set newname for datafile 7 to '/appl/ERP_CLONE/dbclone/clone_data/system07.dbf';
set newname for datafile 8 to '/appl/ERP_CLONE/dbclone/clone_data/system08.dbf';
set newname for datafile 9 to '/appl/ERP_CLONE/dbclone/clone_data/system09.dbf';
set newname for datafile 10 to '/appl/ERP_CLONE/dbclone/clone_data/system10.dbf';
set newname for datafile 11 to '/appl/ERP_CLONE/dbclone/clone_data/system11.dbf';
set newname for datafile 12 to '/appl/ERP_CLONE/dbclone/clone_data/undo01.dbf';
set newname for datafile 13 to '/appl/ERP_CLONE/dbclone/clone_data/a_archive01.dbf';
set newname for datafile 14 to '/appl/ERP_CLONE/dbclone/clone_data/a_int01.dbf';
set newname for datafile 15 to '/appl/ERP_CLONE/dbclone/clone_data/a_media01.dbf';
set newname for datafile 16 to '/appl/ERP_CLONE/dbclone/clone_data/a_nolog01.dbf';
set newname for datafile 17 to '/appl/ERP_CLONE/dbclone/clone_data/a_queue01.dbf';
set newname for datafile 18 to '/appl/ERP_CLONE/dbclone/clone_data/a_queue02.dbf';
set newname for datafile 19 to '/appl/ERP_CLONE/dbclone/clone_data/a_ref01.dbf';
set newname for datafile 20 to '/appl/ERP_CLONE/dbclone/clone_data/a_ref02.dbf';
set newname for datafile 21 to '/appl/ERP_CLONE/dbclone/clone_data/a_summ01.dbf';
set newname for datafile 22 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_data101.dbf';
set newname for datafile 23 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_data102.dbf';
set newname for datafile 24 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_data103.dbf';
set newname for datafile 25 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind01.dbf';
set newname for datafile 26 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind02.dbf';
set newname for datafile 27 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind03.dbf';
set newname for datafile 28 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind04.dbf';
set newname for datafile 29 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind05.dbf';
set newname for datafile 30 to '/appl/ERP_CLONE/dbclone/clone_data/ctxd01.dbf';
set newname for datafile 31 to '/appl/ERP_CLONE/dbclone/clone_data/odm.dbf';
set newname for datafile 32 to '/appl/ERP_CLONE/dbclone/clone_data/olap.dbf';
set newname for datafile 33 to '/appl/ERP_CLONE/dbclone/clone_data/owad01.dbf';
set newname for datafile 34 to '/appl/ERP_CLONE/dbclone/clone_data/portal01.dbf';
set newname for datafile 35 to '/appl/ERP_CLONE/dbclone/clone_data/sysaux01.dbf';
set newname for datafile 36 to '/appl/ERP_CLONE/dbclone/clone_data/apps_ts_tools01.dbf';
set newname for datafile 37 to '/appl/ERP_CLONE/dbclone/clone_data/interim.dbf';
set newname for datafile 38 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_data14.dbf';
restore database;
switch datafile all; }
bash-3.00$ pwd
/export/home/oraclone
RMAN> @/export/home/oraclone/rman_restore.sql
RMAN> run {
2> set newname for datafile 1 to '/appl/ERP_CLONE/dbclone/clone_data/system01.dbf';
3> set newname for datafile 2 to '/appl/ERP_CLONE/dbclone/clone_data/system02.dbf';
4> set newname for datafile 3 to '/appl/ERP_CLONE/dbclone/clone_data/system03.dbf';
5> set newname for datafile 4 to '/appl/ERP_CLONE/dbclone/clone_data/system04.dbf';
6> set newname for datafile 5 to '/appl/ERP_CLONE/dbclone/clone_data/system05.dbf';
7> set newname for datafile 6 to '/appl/ERP_CLONE/dbclone/clone_data/system06.dbf';
8> set newname for datafile 7 to '/appl/ERP_CLONE/dbclone/clone_data/system07.dbf';
9> set newname for datafile 8 to '/appl/ERP_CLONE/dbclone/clone_data/system08.dbf';
10> set newname for datafile 9 to '/appl/ERP_CLONE/dbclone/clone_data/system09.dbf';
11> set newname for datafile 10 to '/appl/ERP_CLONE/dbclone/clone_data/system10.dbf';
12> set newname for datafile 11 to '/appl/ERP_CLONE/dbclone/clone_data/system11.dbf';
13> set newname for datafile 12 to '/appl/ERP_CLONE/dbclone/clone_data/undo01.dbf';
14> set newname for datafile 13 to '/appl/ERP_CLONE/dbclone/clone_data/a_archive01.dbf';
15> set newname for datafile 14 to '/appl/ERP_CLONE/dbclone/clone_data/a_int01.dbf';
16> set newname for datafile 15 to '/appl/ERP_CLONE/dbclone/clone_data/a_media01.dbf';
17> set newname for datafile 16 to '/appl/ERP_CLONE/dbclone/clone_data/a_nolog01.dbf';
18> set newname for datafile 17 to '/appl/ERP_CLONE/dbclone/clone_data/a_queue01.dbf';
19> set newname for datafile 18 to '/appl/ERP_CLONE/dbclone/clone_data/a_queue02.dbf';
20> set newname for datafile 19 to '/appl/ERP_CLONE/dbclone/clone_data/a_ref01.dbf';
21> set newname for datafile 20 to '/appl/ERP_CLONE/dbclone/clone_data/a_ref02.dbf';
22> set newname for datafile 21 to '/appl/ERP_CLONE/dbclone/clone_data/a_summ01.dbf';
23> set newname for datafile 22 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_data101.dbf';
24> set newname for datafile 23 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_data102.dbf';
25> set newname for datafile 24 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_data103.dbf';
26> set newname for datafile 25 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind01.dbf';
27> set newname for datafile 26 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind02.dbf';
28> set newname for datafile 27 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind03.dbf';
29> set newname for datafile 28 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind04.dbf';
30> set newname for datafile 29 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind05.dbf';
31> set newname for datafile 30 to '/appl/ERP_CLONE/dbclone/clone_data/ctxd01.dbf';
32> set newname for datafile 31 to '/appl/ERP_CLONE/dbclone/clone_data/odm.dbf';
33> set newname for datafile 32 to '/appl/ERP_CLONE/dbclone/clone_data/olap.dbf';
34> set newname for datafile 33 to '/appl/ERP_CLONE/dbclone/clone_data/owad01.dbf';
35> set newname for datafile 34 to '/appl/ERP_CLONE/dbclone/clone_data/portal01.dbf';
36> set newname for datafile 35 to '/appl/ERP_CLONE/dbclone/clone_data/sysaux01.dbf';
37> set newname for datafile 36 to '/appl/ERP_CLONE/dbclone/clone_data/apps_ts_tools01.dbf';
38> set newname for datafile 37 to '/appl/ERP_CLONE/dbclone/clone_data/interim.dbf';
39> set newname for datafile 38 to '/appl/ERP_CLONE/dbclone/clone_data/a_txn_data14.dbf';
40> restore database;
41> switch datafile all; }
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 04-FEB-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=381 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /appl/ERP_CLONE/dbclone/clone_data/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /appl/ERP_CLONE/dbclone/clone_data/system02.dbf
channel ORA_DISK_1: restoring datafile 00003 to /appl/ERP_CLONE/dbclone/clone_data/system03.dbf
channel ORA_DISK_1: restoring datafile 00004 to /appl/ERP_CLONE/dbclone/clone_data/system04.dbf
channel ORA_DISK_1: restoring datafile 00005 to /appl/ERP_CLONE/dbclone/clone_data/system05.dbf
channel ORA_DISK_1: restoring datafile 00006 to /appl/ERP_CLONE/dbclone/clone_data/system06.dbf
channel ORA_DISK_1: restoring datafile 00007 to /appl/ERP_CLONE/dbclone/clone_data/system07.dbf
channel ORA_DISK_1: restoring datafile 00008 to /appl/ERP_CLONE/dbclone/clone_data/system08.dbf
channel ORA_DISK_1: restoring datafile 00009 to /appl/ERP_CLONE/dbclone/clone_data/system09.dbf
channel ORA_DISK_1: restoring datafile 00010 to /appl/ERP_CLONE/dbclone/clone_data/system10.dbf
channel ORA_DISK_1: restoring datafile 00011 to /appl/ERP_CLONE/dbclone/clone_data/system11.dbf
channel ORA_DISK_1: restoring datafile 00012 to /appl/ERP_CLONE/dbclone/clone_data/undo01.dbf
channel ORA_DISK_1: restoring datafile 00013 to /appl/ERP_CLONE/dbclone/clone_data/a_archive01.dbf
channel ORA_DISK_1: restoring datafile 00014 to /appl/ERP_CLONE/dbclone/clone_data/a_int01.dbf
channel ORA_DISK_1: restoring datafile 00015 to /appl/ERP_CLONE/dbclone/clone_data/a_media01.dbf
channel ORA_DISK_1: restoring datafile 00016 to /appl/ERP_CLONE/dbclone/clone_data/a_nolog01.dbf
channel ORA_DISK_1: restoring datafile 00017 to /appl/ERP_CLONE/dbclone/clone_data/a_queue01.dbf
channel ORA_DISK_1: restoring datafile 00018 to /appl/ERP_CLONE/dbclone/clone_data/a_queue02.dbf
channel ORA_DISK_1: restoring datafile 00019 to /appl/ERP_CLONE/dbclone/clone_data/a_ref01.dbf
channel ORA_DISK_1: restoring datafile 00020 to /appl/ERP_CLONE/dbclone/clone_data/a_ref02.dbf
channel ORA_DISK_1: restoring datafile 00021 to /appl/ERP_CLONE/dbclone/clone_data/a_summ01.dbf
channel ORA_DISK_1: restoring datafile 00022 to /appl/ERP_CLONE/dbclone/clone_data/a_txn_data101.dbf
channel ORA_DISK_1: restoring datafile 00023 to /appl/ERP_CLONE/dbclone/clone_data/a_txn_data102.dbf
channel ORA_DISK_1: restoring datafile 00024 to /appl/ERP_CLONE/dbclone/clone_data/a_txn_data103.dbf
channel ORA_DISK_1: restoring datafile 00025 to /appl/ERP_CLONE/dbclone/clone_data/a_txn_ind01.dbf
channel ORA_DISK_1: restoring datafile 00026 to /appl/ERP_CLONE/dbclone/clone_data/a_txn_ind02.dbf
channel ORA_DISK_1: restoring datafile 00027 to /appl/ERP_CLONE/dbclone/clone_data/a_txn_ind03.dbf
channel ORA_DISK_1: restoring datafile 00028 to /appl/ERP_CLONE/dbclone/clone_data/a_txn_ind04.dbf
channel ORA_DISK_1: restoring datafile 00029 to /appl/ERP_CLONE/dbclone/clone_data/a_txn_ind05.dbf
channel ORA_DISK_1: restoring datafile 00030 to /appl/ERP_CLONE/dbclone/clone_data/ctxd01.dbf
channel ORA_DISK_1: restoring datafile 00031 to /appl/ERP_CLONE/dbclone/clone_data/odm.dbf
channel ORA_DISK_1: restoring datafile 00032 to /appl/ERP_CLONE/dbclone/clone_data/olap.dbf
channel ORA_DISK_1: restoring datafile 00033 to /appl/ERP_CLONE/dbclone/clone_data/owad01.dbf
channel ORA_DISK_1: restoring datafile 00034 to /appl/ERP_CLONE/dbclone/clone_data/portal01.dbf
channel ORA_DISK_1: restoring datafile 00035 to /appl/ERP_CLONE/dbclone/clone_data/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00036 to /appl/ERP_CLONE/dbclone/clone_data/apps_ts_tools01.dbf
channel ORA_DISK_1: restoring datafile 00037 to /appl/ERP_CLONE/dbclone/clone_data/interim.dbf
channel ORA_DISK_1: restoring datafile 00038 to /appl/ERP_CLONE/dbclone/clone_data/a_txn_data14.dbf
channel ORA_DISK_1: reading from backup piece /data/R12_ERP/rman_backup/3feb2012_backup/ERPTEST_DB_05o11qhe_5_1
channel ORA_DISK_1: errors found reading piece handle=/data/R12_ERP/rman_backup/3feb2012_backup/ERPTEST_DB_05o11qhe_5_1
channel ORA_DISK_1: failover to piece handle=/appl/rman_backup/3feb2012_backup/ERPTEST_DB_05o11qhe_5_1 tag=TAG20130203T120813
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:12:21
Finished restore at 04-FEB-13
datafile 1 switched to datafile copy
input datafile copy RECID=39 STAMP=806496604 file name=/appl/ERP_CLONE/dbclone/clone_data/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=40 STAMP=806496605 file name=/appl/ERP_CLONE/dbclone/clone_data/system02.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=41 STAMP=806496605 file name=/appl/ERP_CLONE/dbclone/clone_data/system03.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=42 STAMP=806496606 file name=/appl/ERP_CLONE/dbclone/clone_data/system04.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=43 STAMP=806496606 file name=/appl/ERP_CLONE/dbclone/clone_data/system05.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=44 STAMP=806496607 file name=/appl/ERP_CLONE/dbclone/clone_data/system06.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=45 STAMP=806496607 file name=/appl/ERP_CLONE/dbclone/clone_data/system07.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=46 STAMP=806496608 file name=/appl/ERP_CLONE/dbclone/clone_data/system08.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=47 STAMP=806496609 file name=/appl/ERP_CLONE/dbclone/clone_data/system09.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=48 STAMP=806496609 file name=/appl/ERP_CLONE/dbclone/clone_data/system10.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=49 STAMP=806496610 file name=/appl/ERP_CLONE/dbclone/clone_data/system11.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=50 STAMP=806496611 file name=/appl/ERP_CLONE/dbclone/clone_data/undo01.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=51 STAMP=806496612 file name=/appl/ERP_CLONE/dbclone/clone_data/a_archive01.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=52 STAMP=806496612 file name=/appl/ERP_CLONE/dbclone/clone_data/a_int01.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=53 STAMP=806496613 file name=/appl/ERP_CLONE/dbclone/clone_data/a_media01.dbf
datafile 16 switched to datafile copy
input datafile copy RECID=54 STAMP=806496613 file name=/appl/ERP_CLONE/dbclone/clone_data/a_nolog01.dbf
datafile 17 switched to datafile copy
input datafile copy RECID=55 STAMP=806496614 file name=/appl/ERP_CLONE/dbclone/clone_data/a_queue01.dbf
datafile 18 switched to datafile copy
input datafile copy RECID=56 STAMP=806496614 file name=/appl/ERP_CLONE/dbclone/clone_data/a_queue02.dbf
datafile 19 switched to datafile copy
input datafile copy RECID=57 STAMP=806496615 file name=/appl/ERP_CLONE/dbclone/clone_data/a_ref01.dbf
datafile 20 switched to datafile copy
input datafile copy RECID=58 STAMP=806496615 file name=/appl/ERP_CLONE/dbclone/clone_data/a_ref02.dbf
datafile 21 switched to datafile copy
input datafile copy RECID=59 STAMP=806496616 file name=/appl/ERP_CLONE/dbclone/clone_data/a_summ01.dbf
datafile 22 switched to datafile copy
input datafile copy RECID=60 STAMP=806496617 file name=/appl/ERP_CLONE/dbclone/clone_data/a_txn_data101.dbf
datafile 23 switched to datafile copy
input datafile copy RECID=61 STAMP=806496618 file name=/appl/ERP_CLONE/dbclone/clone_data/a_txn_data102.dbf
datafile 24 switched to datafile copy
input datafile copy RECID=62 STAMP=806496619 file name=/appl/ERP_CLONE/dbclone/clone_data/a_txn_data103.dbf
datafile 25 switched to datafile copy
input datafile copy RECID=63 STAMP=806496619 file name=/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind01.dbf
datafile 26 switched to datafile copy
input datafile copy RECID=64 STAMP=806496620 file name=/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind02.dbf
datafile 27 switched to datafile copy
input datafile copy RECID=65 STAMP=806496620 file name=/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind03.dbf
datafile 28 switched to datafile copy
input datafile copy RECID=66 STAMP=806496621 file name=/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind04.dbf
datafile 29 switched to datafile copy
input datafile copy RECID=67 STAMP=806496621 file name=/appl/ERP_CLONE/dbclone/clone_data/a_txn_ind05.dbf
datafile 30 switched to datafile copy
input datafile copy RECID=68 STAMP=806496622 file name=/appl/ERP_CLONE/dbclone/clone_data/ctxd01.dbf
datafile 31 switched to datafile copy
input datafile copy RECID=69 STAMP=806496622 file name=/appl/ERP_CLONE/dbclone/clone_data/odm.dbf
datafile 32 switched to datafile copy
input datafile copy RECID=70 STAMP=806496623 file name=/appl/ERP_CLONE/dbclone/clone_data/olap.dbf
datafile 33 switched to datafile copy
input datafile copy RECID=71 STAMP=806496623 file name=/appl/ERP_CLONE/dbclone/clone_data/owad01.dbf
datafile 34 switched to datafile copy
input datafile copy RECID=72 STAMP=806496624 file name=/appl/ERP_CLONE/dbclone/clone_data/portal01.dbf
datafile 35 switched to datafile copy
input datafile copy RECID=73 STAMP=806496624 file name=/appl/ERP_CLONE/dbclone/clone_data/sysaux01.dbf
datafile 36 switched to datafile copy
input datafile copy RECID=74 STAMP=806496625 file name=/appl/ERP_CLONE/dbclone/clone_data/apps_ts_tools01.dbf
datafile 37 switched to datafile copy
input datafile copy RECID=75 STAMP=806496625 file name=/appl/ERP_CLONE/dbclone/clone_data/interim.dbf
datafile 38 switched to datafile copy
input datafile copy RECID=76 STAMP=806496626 file name=/appl/ERP_CLONE/dbclone/clone_data/a_txn_data14.dbf
RMAN> **end-of-file**
RMAN>
- List backup of archive logs and recover database until last available seq
RMAN> list backup of archivelog all;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1 822.21M DISK 00:00:11 21-JAN-13
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20130121T092549
Piece Name: /data/R12_ERP/rman_backup/ERPTEST_DB_01nvv84u_1_1
List of Archived Logs in backup set 1
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 22 77784979 20-JAN-13 77924429 21-JAN-13
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
4 103.00K DISK 00:00:00 21-JAN-13
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20130121T093606
Piece Name: /data/R12_ERP/rman_backup/ERPTEST_DB_04nvv8o6_4_1
List of Archived Logs in backup set 4
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 23 77924429 21-JAN-13 77924713 21-JAN-13
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
7 1.20G DISK 00:00:22 03-FEB-13
BP Key: 7 Status: AVAILABLE Compressed: NO Tag: FULL_DB
Piece Name: /data/R12_ERP/rman_backup/3feb2013_Bkp/db_806418437_7.bkp
List of Archived Logs in backup set 7
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 22 77784979 20-JAN-13 77924429 21-JAN-13
1 23 77924429 21-JAN-13 77924713 21-JAN-13
1 24 77924713 21-JAN-13 78223108 03-FEB-13
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
9 226.00K DISK 00:00:00 03-FEB-13
BP Key: 9 Status: AVAILABLE Compressed: NO Tag: FULL_DB
Piece Name: /data/R12_ERP/rman_backup/3feb2013_Bkp/db_806419062_9.bkp
List of Archived Logs in backup set 9
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 25 78223108 03-FEB-13 78223850 03-FEB-13
RMAN> RUN {
2> set until sequence 26 thread 1;
3> recover database;
4> }
executing command: SET until clause
Starting recover at 04-FEB-13
using channel ORA_DISK_1
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=24
channel ORA_DISK_1: reading from backup piece /data/R12_ERP/rman_backup/3feb2013_Bkp/db_806418437_7.bkp
channel ORA_DISK_1: errors found reading piece handle=/data/R12_ERP/rman_backup/3feb2013_Bkp/db_806418437_7.bkp
channel ORA_DISK_1: failover to piece handle=/appl/rman_backup/3feb2012_backup/db_806418437_7.bkp tag=FULL_DB
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
archived log file name=/appl/ERP_CLONE/dbclone/clone_data/archive/1_24_805117931.dbf thread=1 sequence=24
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=25
channel ORA_DISK_1: reading from backup piece /data/R12_ERP/rman_backup/3feb2013_Bkp/db_806419062_9.bkp
channel ORA_DISK_1: errors found reading piece handle=/data/R12_ERP/rman_backup/3feb2013_Bkp/db_806419062_9.bkp
channel ORA_DISK_1: failover to piece handle=/appl/rman_backup/3feb2012_backup/db_806419062_9.bkp tag=FULL_DB
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/appl/ERP_CLONE/dbclone/clone_data/archive/1_25_805117931.dbf thread=1 sequence=25
media recovery complete, elapsed time: 00:00:01
Finished recover at 04-FEB-13
RMAN>
- Rename online LOGFILES:
bash-3.00$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Mon Feb 4 13:36:24 2013
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/data/R12_ERP/db/apps_st/data/log02a.dbf
/data/R12_ERP/db/apps_st/data/log02b.dbf
/data/R12_ERP/db/apps_st/data/log01a.dbf
/data/R12_ERP/db/apps_st/data/log01b.dbf
SQL> alter database rename file '/data/R12_ERP/db/apps_st/data/log02a.dbf' to '/appl/ERP_CLONE/dbclone/clone_data/log02a.dbf';
Database altered.
SQL> alter database rename file '/data/R12_ERP/db/apps_st/data/log02b.dbf' to '/appl/ERP_CLONE/dbclone/clone_data/log02b.dbf'
2 ;
Database altered.
SQL> alter database rename file '/data/R12_ERP/db/apps_st/data/log01a.dbf' to '/appl/ERP_CLONE/dbclone/clone_data/log01a.dbf';
Database altered.
SQL> alter database rename file '/data/R12_ERP/db/apps_st/data/log01b.dbf' to '/appl/ERP_CLONE/dbclone/clone_data/log01b.dbf';
Database altered.
SQL>
- Open database using resetlogs:
SQL> alter database open resetlogs;
Database altered.
SQL>
- Create and drop TEMP tablspace
SQL> create TEMPORARY TABLESPACE TEMP3 TEMPFILE '/appl/ERP_CLONE/dbclone/clone_data/temp003.dbf' size 2048M;
Tablespace created.
SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp3;
Database altered.
SQL> drop tablespace temp1 including contents and datafiles;
Tablespace dropped.
SQL> drop tablespace temp2 including contents and datafiles;
Tablespace dropped.
SQL>
- Change database name using "nid" command
bash-3.00$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Mon Feb 4 13:59:47 2013
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1069252608 bytes
Fixed Size 2109352 bytes
Variable Size 427823192 bytes
Database Buffers 624951296 bytes
Redo Buffers 14368768 bytes
Database mounted.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
bash-3.00$ nid TARGET=SYS/oracle DBNAME=CLONE
DBNEWID: Release 11.1.0.7.0 - Production on Mon Feb 4 14:02:31 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to database ERPTEST (DBID=1262470248)
Connected to server version 11.1.0
Control Files in database:
/appl/ERP_CLONE/dbclone/clone_data/cntrl01.dbf
Change database ID and database name ERPTEST to CLONE? (Y/[N]) => Y
Proceeding with operation
Changing database ID from 1262470248 to 1005337143
Changing database name from ERPTEST to CLONE
Control File /appl/ERP_CLONE/dbclone/clone_data/cntrl01.dbf - modified
Datafile /appl/ERP_CLONE/dbclone/clone_data/system01.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/system02.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/system03.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/system04.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/system05.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/system06.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/system07.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/system08.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/system09.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/system10.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/system11.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/undo01.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/a_archive01.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/a_int01.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/a_media01.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/a_nolog01.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/a_queue01.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/a_queue02.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/a_ref01.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/a_ref02.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/a_summ01.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/a_txn_data101.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/a_txn_data102.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/a_txn_data103.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/a_txn_ind01.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/a_txn_ind02.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/a_txn_ind03.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/a_txn_ind04.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/a_txn_ind05.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/ctxd01.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/odm.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/olap.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/owad01.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/portal01.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/sysaux01.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/apps_ts_tools01.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/interim.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/a_txn_data14.db - dbid changed, wrote new name
Datafile /appl/ERP_CLONE/dbclone/clone_data/temp003.db - dbid changed, wrote new name
Control File /appl/ERP_CLONE/dbclone/clone_data/cntrl01.dbf - dbid changed, wrote new name
Instance shut down
Database name changed to CLONE.
Modify parameter file and generate a new password file before restarting.
Database ID for database CLONE changed to 1005337143.
All previous backups and archived redo logs for this database are unusable.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID - Completed succesfully.
bash-3.00$
- Change ORACLE_SID in environment file and start database with reset logs:
bash-3.00$ grep ORACLE_SID CLONE_testappl.env
ORACLE_SID="CLONE"
export ORACLE_SID
bash-3.00$ pwd
/appl/ERP_CLONE/dbclone/tech_st/11.1.0
bash-3.00$ echo $ORACLE_SID
CLONE
bash-3.00$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Mon Feb 4 14:12:56 2013
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1069252608 bytes
Fixed Size 2109352 bytes
Variable Size 427823192 bytes
Database Buffers 624951296 bytes
Redo Buffers 14368768 bytes
Database mounted.
SQL> alter database open resetlogs;
Database altered.
SQL> select open_mode, name from v$database;
OPEN_MODE NAME
---------- ---------
READ WRITE CLONE
SQL>
- Run autoconfig on database Tier:
bash-3.00$ adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/log/CLONE_testappl/02041433/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /appl/ERP_CLONE/dbclone/tech_st/11.1.0
Classpath : :/appl/ERP_CLONE/dbclone/tech_st/11.1.0/jdbc/lib/ojdbc6.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/java/xmlparserv2.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/java:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/jlib/netcfg.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/jlib/ldapjclnt11.jar
Using Context file : /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/CLONE_testappl.xml
Context Value Management will now update the Context file
UnsatisfiedLinkError exception loading native library: njni11
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Updating rdbms version in Context file to db111
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed successfully.
- Run clone Configuration script on application Tier (testappl):
bash-3.00$ pwd
/data/appclone/R12_ERP/apps/apps_st/comn/clone/bin
bash-3.00$ export PATH=/usr/ccs/bin:/usr/bin:/usr/ucb:/etc:.
bash-3.00$ 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.8
Enter the APPS password :
Running:
/data/appclone/R12_ERP/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -cp /data/appclone/R12_ERP/apps/apps_st/comn/clone/jlib/java:/data/appclone/R12_ERP/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/data/appclone/R12_ERP/apps/apps_st/comn/clone/jlib/ojdbc14.jar oracle.apps.ad.context.CloneContext -e /data/appclone/R12_ERP/apps/apps_st/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_26828.lst -stage /data/appclone/R12_ERP/apps/apps_st/comn/clone 2> /tmp/adcfgclone_26828.err; echo $? > /tmp/adcfgclone_26828.res
Log file located at /data/appclone/R12_ERP/apps/apps_st/comn/clone/bin/CloneContext_0205121512.log
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [testappl] :
Target System Database SID : CLONE
Target System Database Server Node [testappl] :
Target System Database Domain Name [orasol.com] :
Target System Base Directory : /data/appclone/R12_ERP
Target System Tools ORACLE_HOME Directory [/data/appclone/R12_ERP/apps/tech_st/10.1.2] :
Target System Web ORACLE_HOME Directory [/data/appclone/R12_ERP/apps/tech_st/10.1.3] :
Target System APPL_TOP Directory [/data/appclone/R12_ERP/apps/apps_st/appl] :
Target System COMMON_TOP Directory [/data/appclone/R12_ERP/apps/apps_st/comn] :
Target System Instance Home Directory [/data/appclone/R12_ERP/inst] :
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 [disabled] :
Do you want to preserve the Display [devappl:0.0] (y/n) : n
Target System Display [testappl:0.0] :
RC-00217: Warning: Configuration home directory (s_config_home) evaluates to /data/appclone/R12_ERP/inst/apps/CLONE_testappl. A directory with this name already exists and is not empty.
Do you want to continue (y/n) : y
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] : 22
Checking the port pool 22
done: Port Pool 22 is free
Report file located at /data/appclone/R12_ERP/inst/apps/CLONE_testappl/temp/portpool.lst
Complete port information available at /data/appclone/R12_ERP/inst/apps/CLONE_testappl/temp/portpool.lst
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /usr/tmp
3. /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/outbound/CLONE_testappl
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] :
Backing up /data/appclone/R12_ERP/inst/apps/CLONE_testappl/appl/admin/CLONE_testappl.xml to /data/appclone/R12_ERP/inst/apps/CLONE_testappl/appl/admin/CLONE_testappl.xml0.bak
Creating the new APPL_TOP Context file from :
/data/appclone/R12_ERP/apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmp
The new APPL_TOP context file has been created :
/data/appclone/R12_ERP/inst/apps/CLONE_testappl/appl/admin/CLONE_testappl.xml
Log file located at /data/appclone/R12_ERP/apps/apps_st/comn/clone/bin/CloneContext_0205121512.log
Check Clone Context logfile /data/appclone/R12_ERP/apps/apps_st/comn/clone/bin/CloneContext_0205121512.log for details.
Running Rapid Clone with command:
perl /data/appclone/R12_ERP/apps/apps_st/comn/clone/bin/adclone.pl java=/data/appclone/R12_ERP/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/data/appclone/R12_ERP/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/data/appclone/R12_ERP/inst/apps/CLONE_testappl/appl/admin/CLONE_testappl.xml showProgress contextValidated=true
Running:
perl /data/appclone/R12_ERP/apps/apps_st/comn/clone/bin/adclone.pl java=/data/appclone/R12_ERP/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/data/appclone/R12_ERP/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/data/appclone/R12_ERP/inst/apps/CLONE_testappl/appl/admin/CLONE_testappl.xml showProgress contextValidated=true
APPS Password :
Beginning application tier Apply - Tue Feb 5 12:15:57 2013
/data/appclone/R12_ERP/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /data/appclone/R12_ERP/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/data/appclone/R12_ERP/apps/apps_st/comn/clone/jlib/ojdbc14.jar:/data/appclone/R12_ERP/apps/apps_st/comn/clone/jlib/java:/data/appclone/R12_ERP/apps/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/data/appclone/R12_ERP/apps/apps_st/comn/clone/jlib/oui/ewt3.jar:/data/appclone/R12_ERP/apps/apps_st/comn/clone/jlib/oui/share.jar:/data/appclone/R12_ERP/apps/apps_st/comn/clone/jlib/oui/srvm.jar:/data/appclone/R12_ERP/apps/apps_st/comn/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyAppsTier -e /data/appclone/R12_ERP/inst/apps/CLONE_testappl/appl/admin/CLONE_testappl.xml -stage /data/appclone/R12_ERP/apps/apps_st/comn/clone -showProgress
APPS Password : Log file located at /data/appclone/R12_ERP/inst/apps/CLONE_testappl/admin/log/ApplyAppsTier_02051215.log
/ 89% completed
Completed Apply...
Tue Feb 5 12:20:51 2013
Do you want to startup the Application Services for CLONE? (y/n) [y] :
Starting application Services for CLONE:
Running:
/data/appclone/R12_ERP/inst/apps/CLONE_testappl/admin/scripts/adstrtal.sh -nopromptmsg
You are running adstrtal.sh version 120.15.12010000.3
The logfile for this session is located at /data/appclone/R12_ERP/inst/apps/CLONE_testappl/logs/appl/admin/log/adstrtal.log
Executing service control script:
/data/appclone/R12_ERP/inst/apps/CLONE_testappl/admin/scripts/adopmnctl.sh start
script returned:
****************************************************
You are running adopmnctl.sh version 120.6.12010000.4
Starting Oracle Process Manager (OPMN) ...
adopmnctl.sh: exiting with status 0
adopmnctl.sh: check the logfile /data/appclone/R12_ERP/inst/apps/CLONE_testappl/logs/appl/admin/log/adopmnctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/data/appclone/R12_ERP/inst/apps/CLONE_testappl/admin/scripts/adalnctl.sh start
script returned:
****************************************************
adalnctl.sh version 120.3
Checking for FNDFS executable.
Starting listener process APPS_CLONE.
adalnctl.sh: exiting with status 0
adalnctl.sh: check the logfile /data/appclone/R12_ERP/inst/apps/CLONE_testappl/logs/appl/admin/log/adalnctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/data/appclone/R12_ERP/inst/apps/CLONE_testappl/admin/scripts/adapcctl.sh start
script returned:
****************************************************
You are running adapcctl.sh version 120.7.12010000.2
Starting OPMN managed Oracle HTTP Server (OHS) instance ...
adapcctl.sh: exiting with status 0
adapcctl.sh: check the logfile /data/appclone/R12_ERP/inst/apps/CLONE_testappl/logs/appl/admin/log/adapcctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/data/appclone/R12_ERP/inst/apps/CLONE_testappl/admin/scripts/adoacorectl.sh start
script returned:
****************************************************
You are running adoacorectl.sh version 120.13
Starting OPMN managed OACORE OC4J instance ...
adoacorectl.sh: exiting with status 0
adoacorectl.sh: check the logfile /data/appclone/R12_ERP/inst/apps/CLONE_testappl/logs/appl/admin/log/adoacorectl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/data/appclone/R12_ERP/inst/apps/CLONE_testappl/admin/scripts/adformsctl.sh start
script returned:
****************************************************
You are running adformsctl.sh version 120.16.12010000.3
Starting OPMN managed FORMS OC4J instance ...
Calling txkChkFormsDeployment.pl to check whether latest FORMSAPP.EAR is deployed...
Program : /data/appclone/R12_ERP/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl started @ Tue Feb 5 12:40:02 2013
*** Log File = /data/appclone/R12_ERP/inst/apps/CLONE_testappl/logs/appl/rgf/TXK/txkChkFormsDeployment_Tue_Feb_5_12_40_00_2013/txkChkFormsDeployment_Tue_Feb_5_12_40_00_2013.log
File "/data/appclone/R12_ERP/apps/tech_st/10.1.3/j2ee/forms/applications/forms/formsweb/WEB-INF/lib/frmsrv.jar" exists. Proceeding to check the size...
=============================================
*** Latest formsapp.ear has been deployed ***
=============================================
Program : /data/appclone/R12_ERP/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl completed @ Tue Feb 5 12:40:03 2013
Perl script txkChkFormsDeployment.pl got executed successfully
adformsctl.sh: exiting with status 0
adformsctl.sh: check the logfile /data/appclone/R12_ERP/inst/apps/CLONE_testappl/logs/appl/admin/log/adformsctl.txt for more information ...
.end std out.
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** Log File = /data/appclone/R12_ERP/inst/apps/CLONE_testappl/logs/appl/rgf/TXK/txkChkFormsDeployment_Tue_Feb_5_12_40_00_2013/txkChkFormsDeployment_Tue_Feb_5_12_40_00_2013.log
.end err out.
****************************************************
Executing service control script:
/data/appclone/R12_ERP/inst/apps/CLONE_testappl/admin/scripts/adoafmctl.sh start
script returned:
****************************************************
You are running adoafmctl.sh version 120.8
Starting OPMN managed OAFM OC4J instance ...
adoafmctl.sh: exiting with status 0
adoafmctl.sh: check the logfile /data/appclone/R12_ERP/inst/apps/CLONE_testappl/logs/appl/admin/log/adoafmctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/data/appclone/R12_ERP/inst/apps/CLONE_testappl/admin/scripts/adcmctl.sh start
script returned:
****************************************************
You are running adcmctl.sh version 120.17.12010000.5
Starting concurrent manager for CLONE ...
Starting CLONE_0205@CLONE Internal Concurrent Manager
Default printer is noprint
adcmctl.sh: exiting with status 0
adcmctl.sh: check the logfile /data/appclone/R12_ERP/inst/apps/CLONE_testappl/logs/appl/admin/log/adcmctl.txt for more information ...
.end std out.
.end err out.
****************************************************
Executing service control script:
/data/appclone/R12_ERP/inst/apps/CLONE_testappl/admin/scripts/jtffmctl.sh start
script returned:
****************************************************
You are running jtffmctl.sh version 120.3
Validating Fulfillment patch level via /data/appclone/R12_ERP/apps/apps_st/comn/java/classes
Fulfillment patch level validated.
Starting Fulfillment Server for CLONE on port 9322 ...
jtffmctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************
All enabled services for this node are started.
adstrtal.sh: Exiting with status 0
adstrtal.sh: check the logfile /data/appclone/R12_ERP/inst/apps/CLONE_testappl/logs/appl/admin/log/adstrtal.log for more information ...
bash-3.00$
- Perform post clone steps:
• Run FND conc clean procedure
• change apps, sys, system, password
• change site NAME
• change SGA size as required (deault 1GB will be configured)
• Reduce concurrent managers as required depending on the resources
- Run FND conc. clean, change apps, sys, system, password and run autoconfig
- On AppsTier
bash-3.00$ FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS appsclone
- On DB Tier
SQL> select NODE_NAME from fnd_nodes;
NODE_NAME
------------------------------
AUTHENTICATION
DEVAPPL
DEVDB
TESTAPPL
SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
bash-3.00$ cd CLONE_testappl/
bash-3.00$ ls
adautocfg.sh adchknls.pl addbctl.sh addlnctl.sh adexecsql.pl adlsnodes.sh adpreclone.pl adstopdb.sql adstrtdb.sql
bash-3.00$ adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/log/CLONE_testappl/02051300/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /appl/ERP_CLONE/dbclone/tech_st/11.1.0
Classpath : :/appl/ERP_CLONE/dbclone/tech_st/11.1.0/jdbc/lib/ojdbc6.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/java/xmlparserv2.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/java:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/jlib/netcfg.jar:/appl/ERP_CLONE/dbclone/tech_st/11.1.0/jlib/ldapjclnt11.jar
Using Context file : /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/CLONE_testappl.xml
Context Value Management will now update the Context file
UnsatisfiedLinkError exception loading native library: njni11
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Updating rdbms version in Context file to db111
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed successfully.
bash-3.00$
- Running autoconfig on application Tier:
bash-3.00$ cd /appl/ERP_CLONE/dbclone/tech_st/11.1.0/appsutil/scripts/CLONE_testappl
bash-3.00$ adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /data/appclone/R12_ERP/inst/apps/CLONE_testappl/admin/log/02051301/adconfig.log
AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /data/appclone/R12_ERP/inst/apps/CLONE_testappl
Classpath : /data/appclone/R12_ERP/apps/apps_st/comn/java/lib/appsborg2.zip:/data/appclone/R12_ERP/apps/apps_st/comn/java/classes
Using Context file : /data/appclone/R12_ERP/inst/apps/CLONE_testappl/appl/admin/CLONE_testappl.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring MSC_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring IGS_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED
AutoConfig completed successfully.
bash-3.00$
- Oracle Application Dashboard for clone:
I Believe this post will be helpful for those who are looking for some document for performing Oracle E-Business suite cloning online(hot backup).
If any one has any queries/suggestions then please comment.
Thursday 19 April 2018
Clone Steps Rman
1.
Run adpreclone.pl in db Tier
No Need to down server:
cd $ORACLE_HOME/appsutil/scripts/$SID/
perl adpreclone.pl dbTier
take Oracle_Home as tar:
tar -cvf db.tar 11.1.0/
scp -r db.tar root@192.168.1.4:/u01/db/
2.
Run adpreclone.pl in apps Tier
cd /u01/applprod/apps/inst/apps/PROD_tos01/admin/scripts
or $ADMIN_SCRIPTS_HOME
No Need to down server:
perl adpreclone.pl appsTier
take only apps and comn tar , not required inst.
under apps - apps_st and Tech_st .
tar -cvf apps.tar apps/
scp -r apps.tar root@192.168.1.4:/u01/apps/
3.
Create apps and db user
useradd -g dba -G oinstall applprod
useradd -g dba -G oinstall oraprod
passwd applprod
passwd oraprod
4.Create Folder structure.
mkdir -p /u01/oraprod/db/tech_st/
chown -R oraprod:dba /u01/oraprod/db/tech_st/
chmod -R 775 /u01/oraprod/db/tech_st/
mkdir -p /u01/oraprod/db/apps_st/data
chown -R oraprod:dba /u01/oraprod/db/apps_st/data
chmod -R 775 /u01/oraprod/db/apps_st/data
mkdir -p rman archive
chown -R oraprod:dba rman archive
chmod -R 775 rman archive
5.
Extract db.tar to /u01/oraprod/db/tech_st/
mv db.tar /u01/oraprod/db/tech_st/
oraprod$ tar -xvf db.tar
6.send all rman file to server.
Extarct rman.tar to /u01/oraprod/rman
Extarct archive.tar to /u01/oraprod/archive
Note:How to replace string in vi Editor.
7.Extract apps.tar to respective directory.
mkdir -p /u01/applprod/
chown -R applprod:dba /u01/applprod/
chmod -R 775 /u01/applprod/
cd /u01/applprod/
apps$]tar -xvf apps.tar
#tar -xvf apps.tar
chown -R applprd:dba apps
chmod -R 775 apps
8.
Take Full Rman backup with archivelog.
rman target /
RMAN> RUN {
configure controlfile autobackup format for device type diks to '/u01/orauat/rman_backup/3feb2013_Bkp/%F';
configure controlfile autobackup on;
allocate channel d1 type disk;
backup tag FULL_DB database plus archivelog format '/u01/orauat/rman_backup/3feb2013_Bkp/db_%t_%s.bkp';
release channel d1;
}
take this backup and send to destination server:
cd /u01/orauat/
tar -cvf rman.tar rman/
scp -r rman.tar root@192.168.1.4:/u01/oraprod/rman/
9.Restore backup of database and application on Target Node:
RDBMS Oracle Home Configuration:
After extracting , RDBMS_Software , go to,
Oracle_Home/appsutil/clone/bin
perl adcfgclone.pl dbTechStack
Provide the values required for creation of the new Database Context file.
Target System Hostname (virtual or normal) [tos01] :
Target Instance is RAC (y/n) [n] : n
Target System Database SID : PROD (Source was UAT)
Target System Base Directory : /u01/oraprod/db/
Target System utl_file_dir Directory List : /usr/tmp
Number of DATA_TOP's on the Target System [1] :
Target System DATA_TOP Directory 1 [/u01/app/orauat/db/apps_st/data] : /u01/oraprod/db/apps_st/data
Target System RDBMS ORACLE_HOME Directory [/u01/oraprod/db/db/tech_st/11.1.0] : /u01/oraprod/db/tech_st/11.1.0
Do you want to preserve the Display [null] (y/n) ? : n
Target System Display [tos01: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] : 80
10.
Step 1> set in .bash_profile,
ORACLE_SID=UAT
export $ORACLE_SID
#Original Value is PROD, replaced for restore and recover of rman db
>• copy initPROD.ora to initUAT.ora
vi initUAT.ora
db_name = UAT(Changed from PROD to UAT)
control_files = /u01/oraprod/db/apps_st/data/cntrl01.dbf
Go to $ORACLE_HOME
Take env file name as PROD_tos01.env,put into .bash_profile.
11.start db,
> startup nomount pfile='/u01/oraprod/db/tech_st/11.1.0/dbs/initUAT.ora';
Total System Global Area 1068937216 bytes
Fixed Size 2166536 bytes
Variable Size 427819256 bytes
Database Buffers 624951296 bytes
Redo Buffers 14000128 bytes
>rman target / nocatalog
connected to target database: UAT (not mounted)
go to rman and check controlfile .
RMAN> restore controlfile from '/u01/oraprod/rman/rman/UAT_Control_File973790400_458_1';
RMAN> alter database mount;
cd /u01/oraprod/rman/rman
12.Catalog all rman and archiver files.
rman]$ rman target / nocatalog
catalog backuppiece '/u01/oraprod/rman/rman/UAT_973788948_448_1';
catalog backuppiece '/u01/oraprod/rman/rman/UAT_973788948_449_1';
catalog backuppiece '/u01/oraprod/rman/rman/UAT_973788949_450_1';
catalog backuppiece '/u01/oraprod/rman/rman/UAT_973788949_451_1';
catalog backuppiece '/u01/oraprod/rman/rman/UAT_973790110_452_1';
catalog backuppiece '/u01/oraprod/rman/rman/UAT_973790121_453_1';
catalog backuppiece '/u01/oraprod/rman/rman/UAT_Arch_Log973790373_454_1';
catalog backuppiece '/u01/oraprod/rman/rman/UAT_Arch_Log973790373_455_1';
catalog backuppiece '/u01/oraprod/rman/rman/UAT_Arch_Log973790374_456_1';
catalog backuppiece '/u01/oraprod/rman/rman/UAT_Arch_Log973790374_457_1';
catalog backuppiece '/u01/oraprod/rman/rman/egt0njpq_1_1';
catalog backuppiece '/u01/oraprod/rman/rman/eht0njqu_1_1';
catalog backuppiece '/u01/oraprod/rman/rman/i8t0nm1k_1_1';
catalog backuppiece '/u01/oraprod/rman/rman/i9t0nm1r_1_1';
13.Prepare script for restoration purpose.
take this script help wise and assemble all datafile in one location
with new rman loction name:
Run On Source:
(select 'set newname for datafile '||FILE_ID||' to '''||file_name||''';'from dba_data_files);
You Will Get,
restore_rman.sql
run {
set newname for datafile 13 to '/u01/oraprod/db/apps_st/data/system12.dbf';
set newname for datafile 354 to '/u01/oraprod/db/apps_st/data/system11.dbf';
set newname for datafile 288 to '/u01/oraprod/db/apps_st/data/system10.dbf';
set newname for datafile 1 to '/u01/oraprod/db/apps_st/data/system01.dbf';
set newname for datafile 2 to '/u01/oraprod/db/apps_st/data/system02.dbf';
set newname for datafile 3 to '/u01/oraprod/db/apps_st/data/system03.dbf';
set newname for datafile 4 to '/u01/oraprod/db/apps_st/data/system04.dbf';
set newname for datafile 5 to '/u01/oraprod/db/apps_st/data/system05.dbf';
set newname for datafile 295 to '/u01/oraprod/db/apps_st/data/system06.dbf';
set newname for datafile 351 to '/u01/oraprod/db/apps_st/data/system07.dbf';
set newname for datafile 353 to '/u01/oraprod/db/apps_st/data/system08.dbf';
set newname for datafile 352 to '/u01/oraprod/db/apps_st/data/system09.dbf';
set newname for datafile 6 to '/u01/oraprod/db/apps_st/data/ctxd01.dbf';
set newname for datafile 7 to '/u01/oraprod/db/apps_st/data/owad01.dbf';
set newname for datafile 8 to '/u01/oraprod/db/apps_st/data/a_queue02.dbf';
set newname for datafile 9 to '/u01/oraprod/db/apps_st/data/odm.dbf';
set newname for datafile 10 to '/u01/oraprod/db/apps_st/data/olap.dbf';
set newname for datafile 11 to '/u01/oraprod/db/apps_st/data/sysaux01.dbf';
set newname for datafile 12 to '/u01/oraprod/db/apps_st/data/apps_ts_tools01.dbf';
set newname for datafile 14 to '/u01/oraprod/db/apps_st/data/a_txn_data04.dbf';
set newname for datafile 15 to '/u01/oraprod/db/apps_st/data/a_txn_ind06.dbf';
set newname for datafile 16 to '/u01/oraprod/db/apps_st/data/a_ref03.dbf';
set newname for datafile 17 to '/u01/oraprod/db/apps_st/data/a_int02.dbf';
set newname for datafile 18 to '/u01/oraprod/db/apps_st/data/sysaux02.dbf';
set newname for datafile 314 to '/u01/oraprod/db/apps_st/data/portal01.dbf';
set newname for datafile 379 to '/u01/oraprod/db/apps_st/data/undo01.dbf';
set newname for datafile 392 to '/u01/oraprod/db/apps_st/data/a_txn_data01.dbf';
set newname for datafile 393 to '/u01/oraprod/db/apps_st/data/a_txn_ind01.dbf';
set newname for datafile 394 to '/u01/oraprod/db/apps_st/data/a_ref01.dbf';
set newname for datafile 395 to '/u01/oraprod/db/apps_st/data/a_int01.dbf';
set newname for datafile 396 to '/u01/oraprod/db/apps_st/data/a_summ01.dbf';
set newname for datafile 397 to '/u01/oraprod/db/apps_st/data/a_nolog01.dbf';
set newname for datafile 398 to '/u01/oraprod/db/apps_st/data/a_archive01.dbf';
set newname for datafile 399 to '/u01/oraprod/db/apps_st/data/a_queue01.dbf';
set newname for datafile 400 to '/u01/oraprod/db/apps_st/data/a_media01.dbf';
set newname for datafile 401 to '/u01/oraprod/db/apps_st/data/a_txn_data02.dbf';
set newname for datafile 402 to '/u01/oraprod/db/apps_st/data/a_txn_data03.dbf';
set newname for datafile 403 to '/u01/oraprod/db/apps_st/data/a_txn_ind02.dbf';
set newname for datafile 404 to '/u01/oraprod/db/apps_st/data/a_txn_ind03.dbf';
set newname for datafile 405 to '/u01/oraprod/db/apps_st/data/a_txn_ind04.dbf';
set newname for datafile 406 to '/u01/oraprod/db/apps_st/data/a_txn_ind05.dbf';
set newname for datafile 407 to '/u01/oraprod/db/apps_st/data/a_ref02.dbf';
restore database;
switch datafile all;
}
14.
RMAN>list backup of archivelog all;
Thrd Seq
1 13
RUN {
set until sequence 14 thread 1;
recover database;
}
15.
>- Rename online LOGFILES:
sqlplus / as sysdba
select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/u01/app/orauat/db/apps_st/data/log02a.dbf
/u01/app/orauat/db/apps_st/data/log02b.dbf
/u01/app/orauat/db/apps_st/data/log01a.dbf
/u01/app/orauat/db/apps_st/data/log01b.dbf
alter database rename file '/u01/app/orauat/db/apps_st/data/log02a.dbf' to '/u01/oraprod/db/apps_st/data/log02a.dbf';
alter database rename file '/u01/app/orauat/db/apps_st/data/log02b.dbf' to '/u01/oraprod/db/apps_st/data/log02b.dbf';
alter database rename file '/u01/app/orauat/db/apps_st/data/log01a.dbf' to '/u01/oraprod/db/apps_st/data/log01a.dbf';
alter database rename file '/u01/app/orauat/db/apps_st/data/log01b.dbf' to '/u01/oraprod/db/apps_st/data/log01b.dbf';
>- Open database using resetlogs:
SQL> alter database open resetlogs;
>- Create and drop TEMP tablspace
select name from v$tempfile;
/u01/app/orauat/db/apps_st/data/temp01.dbf
/u01/app/orauat/db/apps_st/data/temp02.dbf
create TEMPORARY TABLESPACE TEMP3 TEMPFILE '/u01/oraprod/db/apps_st/data/temp003.dbf' size 4000M;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp3;
drop tablespace temp1 including contents and datafiles;
drop tablespace temp2 including contents and datafiles;
16.
>- Change database name using "nid" command
SQL> shut immediate
SQL> startup nomount pfile='/u01/oraprod/db/tech_st/11.1.0/dbs/initUAT.ora';
SQL> alter database mount;
SQL> select open_mode, name from v$database;
OPEN_MODE NAME
---------- ---------
MOUNTED UAT
$ nid TARGET=sys DBNAME=PROD
Password: as sysdba
Connected to database UAT (DBID=2998215867)
Change database ID and database name UAT to PROD? (Y/[N]) => Y
Database ID for database PROD changed to 385712722.
All previous backups and archived redo logs for this database are unusable.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID - Completed succesfully.
Instance shutdown complete
17.- Change ORACLE_SID in environment file and start database with reset logs:
Oracle Home:/u01/oraprod/db/tech_st/11.1.0
PROD_tos01.env
$grep ORACLE_SID PROD_tos01.env
ORACLE_SID="PROD"
export ORACLE_SID
[oraprod@tos01 dbs]$ vi initUAT.ora
(changed from UAT TO PROD)
db_name = PROD
[oraprod@tos01 dbs]$ mv initUAT.ora initPROD.ora
Now start with pfile initPROD.ora
SQL> startup nomount pfile='/u01/oraprod/db/tech_st/11.1.0/dbs/initPROD.ora';
SQL> alter database mount;
alter database open resetlogs;
SQL> select open_mode, name from v$database;
OPEN_MODE NAME
---------- ---------
READ WRITE PROD
18.
>- Run autoconfig on database Tier:
cd $ORACLE_HOME/appsutil/scripts/PROD_tos01
/u01/oraprod/db/tech_st/11.1.0/appsutil/scripts/PROD_tos01
sh adautocfg.sh
AutoConfig completed successfully.
>Run clone Configuration script on application Tier(applprod)
/u01/applprod/apps/apps_st/comn/clone/bin
perl adcfgclone.pl appsTier
Target System Hostname (virtual or normal) [tos01] :
Target System Database SID : PROD
Target System Database Server Node [tos01] :
Target System Base Directory : /u01/applprod/apps
Target System Tools ORACLE_HOME Directory [/u01/applprod/apps/apps/tech_st/10.1.2] : /u01/applprod/apps/tech_st/10.1.2
Target System Web ORACLE_HOME Directory [/u01/applprod/apps/apps/tech_st/10.1.3] : /u01/applprod/apps/tech_st/10.1.3
Target System APPL_TOP Directory [/u01/applprod/apps/apps/apps_st/appl] : /u01/applprod/apps/apps_st/appl
Target System COMMON_TOP Directory [/u01/applprod/apps/apps/apps_st/comn] : /u01/applprod/apps/apps_st/comn
Target System Instance Home Directory [/u01/applprod/apps/inst] : /u01/applprod/apps/inst
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 [disabled] :
Do you want to preserve the Display [tos02:0.0] (y/n) ? : n
Target System Display [tos01: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] : 80
19.Entry in bash profile.
APPS:
ADD ENTRY TO .bash profile:
. /u01/applprod/apps/apps_st/appl/APPSPROD_tos01.env
http://192.168.1.4:8080
DB:
. /u01/oraprod/db/tech_st/11.1.0/PROD_tos01.env
REMOVE ALL UNWANTED PARAMETER FILE FROM OH/DBS LOCATION , FOR AVOIDING CONFLICTING.
CREATE spfile from pfile.And Use spfile,Renamed pfile also.
PROFILE OPTION:
Java%
Site Name
SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;
commit;
- Running autoconfig on database Tier:
/u01/oraprod/db/tech_st/11.1.0/appsutil/scripts/PROD_tos01/
sh adautocfg.sh
- Running autoconfig on application Tier:
/u01/applprod/apps/inst/apps/PROD_tos01/admin/scripts
sh adautocfg.sh
WF:
select TEXT_VALUE from WF_NOTIFICATION_ATTRIBUTES ;
select TEXT_VALUE from WF_ITEM_ATTRIBUTE_VALUES;
select GUID from WF_SYSTEMS;
select NAME from WF_SYSTEMS;
select ADDRESS from WF_AGENTS;
select WEB_HOST_NAME from FND_FORM_FUNCTIONS;
select WEB_AGENT_NAME from FND_FORM_FUNCTIONS;
select LOGFILE_NAME from FND_CONCURRENT_REQUESTS;
select OUTFILE_NAME from FND_CONCURRENT_REQUESTS;
4. Verify the APPLCSF variable setting
s_applcsf variable in the context file and then run AutoConfig.
5.
5. Update the SESSION_COOKIE_DOMAIN value in ICX_PARAMETERS
select SESSION_COOKIE_DOMAIN from ICX_PARAMETERS;
select home_url from ICX_PARAMETERS;
Run adpreclone.pl in db Tier
No Need to down server:
cd $ORACLE_HOME/appsutil/scripts/$SID/
perl adpreclone.pl dbTier
take Oracle_Home as tar:
tar -cvf db.tar 11.1.0/
scp -r db.tar root@192.168.1.4:/u01/db/
2.
Run adpreclone.pl in apps Tier
cd /u01/applprod/apps/inst/apps/PROD_tos01/admin/scripts
or $ADMIN_SCRIPTS_HOME
No Need to down server:
perl adpreclone.pl appsTier
take only apps and comn tar , not required inst.
under apps - apps_st and Tech_st .
tar -cvf apps.tar apps/
scp -r apps.tar root@192.168.1.4:/u01/apps/
3.
Create apps and db user
useradd -g dba -G oinstall applprod
useradd -g dba -G oinstall oraprod
passwd applprod
passwd oraprod
4.Create Folder structure.
mkdir -p /u01/oraprod/db/tech_st/
chown -R oraprod:dba /u01/oraprod/db/tech_st/
chmod -R 775 /u01/oraprod/db/tech_st/
mkdir -p /u01/oraprod/db/apps_st/data
chown -R oraprod:dba /u01/oraprod/db/apps_st/data
chmod -R 775 /u01/oraprod/db/apps_st/data
mkdir -p rman archive
chown -R oraprod:dba rman archive
chmod -R 775 rman archive
5.
Extract db.tar to /u01/oraprod/db/tech_st/
mv db.tar /u01/oraprod/db/tech_st/
oraprod$ tar -xvf db.tar
6.send all rman file to server.
Extarct rman.tar to /u01/oraprod/rman
Extarct archive.tar to /u01/oraprod/archive
Note:How to replace string in vi Editor.
7.Extract apps.tar to respective directory.
mkdir -p /u01/applprod/
chown -R applprod:dba /u01/applprod/
chmod -R 775 /u01/applprod/
cd /u01/applprod/
apps$]tar -xvf apps.tar
#tar -xvf apps.tar
chown -R applprd:dba apps
chmod -R 775 apps
8.
Take Full Rman backup with archivelog.
rman target /
RMAN> RUN {
configure controlfile autobackup format for device type diks to '/u01/orauat/rman_backup/3feb2013_Bkp/%F';
configure controlfile autobackup on;
allocate channel d1 type disk;
backup tag FULL_DB database plus archivelog format '/u01/orauat/rman_backup/3feb2013_Bkp/db_%t_%s.bkp';
release channel d1;
}
take this backup and send to destination server:
cd /u01/orauat/
tar -cvf rman.tar rman/
scp -r rman.tar root@192.168.1.4:/u01/oraprod/rman/
9.Restore backup of database and application on Target Node:
RDBMS Oracle Home Configuration:
After extracting , RDBMS_Software , go to,
Oracle_Home/appsutil/clone/bin
perl adcfgclone.pl dbTechStack
Provide the values required for creation of the new Database Context file.
Target System Hostname (virtual or normal) [tos01] :
Target Instance is RAC (y/n) [n] : n
Target System Database SID : PROD (Source was UAT)
Target System Base Directory : /u01/oraprod/db/
Target System utl_file_dir Directory List : /usr/tmp
Number of DATA_TOP's on the Target System [1] :
Target System DATA_TOP Directory 1 [/u01/app/orauat/db/apps_st/data] : /u01/oraprod/db/apps_st/data
Target System RDBMS ORACLE_HOME Directory [/u01/oraprod/db/db/tech_st/11.1.0] : /u01/oraprod/db/tech_st/11.1.0
Do you want to preserve the Display [null] (y/n) ? : n
Target System Display [tos01: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] : 80
10.
Step 1> set in .bash_profile,
ORACLE_SID=UAT
export $ORACLE_SID
#Original Value is PROD, replaced for restore and recover of rman db
>• copy initPROD.ora to initUAT.ora
vi initUAT.ora
db_name = UAT(Changed from PROD to UAT)
control_files = /u01/oraprod/db/apps_st/data/cntrl01.dbf
Go to $ORACLE_HOME
Take env file name as PROD_tos01.env,put into .bash_profile.
11.start db,
> startup nomount pfile='/u01/oraprod/db/tech_st/11.1.0/dbs/initUAT.ora';
Total System Global Area 1068937216 bytes
Fixed Size 2166536 bytes
Variable Size 427819256 bytes
Database Buffers 624951296 bytes
Redo Buffers 14000128 bytes
>rman target / nocatalog
connected to target database: UAT (not mounted)
go to rman and check controlfile .
RMAN> restore controlfile from '/u01/oraprod/rman/rman/UAT_Control_File973790400_458_1';
RMAN> alter database mount;
cd /u01/oraprod/rman/rman
12.Catalog all rman and archiver files.
rman]$ rman target / nocatalog
catalog backuppiece '/u01/oraprod/rman/rman/UAT_973788948_448_1';
catalog backuppiece '/u01/oraprod/rman/rman/UAT_973788948_449_1';
catalog backuppiece '/u01/oraprod/rman/rman/UAT_973788949_450_1';
catalog backuppiece '/u01/oraprod/rman/rman/UAT_973788949_451_1';
catalog backuppiece '/u01/oraprod/rman/rman/UAT_973790110_452_1';
catalog backuppiece '/u01/oraprod/rman/rman/UAT_973790121_453_1';
catalog backuppiece '/u01/oraprod/rman/rman/UAT_Arch_Log973790373_454_1';
catalog backuppiece '/u01/oraprod/rman/rman/UAT_Arch_Log973790373_455_1';
catalog backuppiece '/u01/oraprod/rman/rman/UAT_Arch_Log973790374_456_1';
catalog backuppiece '/u01/oraprod/rman/rman/UAT_Arch_Log973790374_457_1';
catalog backuppiece '/u01/oraprod/rman/rman/egt0njpq_1_1';
catalog backuppiece '/u01/oraprod/rman/rman/eht0njqu_1_1';
catalog backuppiece '/u01/oraprod/rman/rman/i8t0nm1k_1_1';
catalog backuppiece '/u01/oraprod/rman/rman/i9t0nm1r_1_1';
13.Prepare script for restoration purpose.
take this script help wise and assemble all datafile in one location
with new rman loction name:
Run On Source:
(select 'set newname for datafile '||FILE_ID||' to '''||file_name||''';'from dba_data_files);
You Will Get,
restore_rman.sql
run {
set newname for datafile 13 to '/u01/oraprod/db/apps_st/data/system12.dbf';
set newname for datafile 354 to '/u01/oraprod/db/apps_st/data/system11.dbf';
set newname for datafile 288 to '/u01/oraprod/db/apps_st/data/system10.dbf';
set newname for datafile 1 to '/u01/oraprod/db/apps_st/data/system01.dbf';
set newname for datafile 2 to '/u01/oraprod/db/apps_st/data/system02.dbf';
set newname for datafile 3 to '/u01/oraprod/db/apps_st/data/system03.dbf';
set newname for datafile 4 to '/u01/oraprod/db/apps_st/data/system04.dbf';
set newname for datafile 5 to '/u01/oraprod/db/apps_st/data/system05.dbf';
set newname for datafile 295 to '/u01/oraprod/db/apps_st/data/system06.dbf';
set newname for datafile 351 to '/u01/oraprod/db/apps_st/data/system07.dbf';
set newname for datafile 353 to '/u01/oraprod/db/apps_st/data/system08.dbf';
set newname for datafile 352 to '/u01/oraprod/db/apps_st/data/system09.dbf';
set newname for datafile 6 to '/u01/oraprod/db/apps_st/data/ctxd01.dbf';
set newname for datafile 7 to '/u01/oraprod/db/apps_st/data/owad01.dbf';
set newname for datafile 8 to '/u01/oraprod/db/apps_st/data/a_queue02.dbf';
set newname for datafile 9 to '/u01/oraprod/db/apps_st/data/odm.dbf';
set newname for datafile 10 to '/u01/oraprod/db/apps_st/data/olap.dbf';
set newname for datafile 11 to '/u01/oraprod/db/apps_st/data/sysaux01.dbf';
set newname for datafile 12 to '/u01/oraprod/db/apps_st/data/apps_ts_tools01.dbf';
set newname for datafile 14 to '/u01/oraprod/db/apps_st/data/a_txn_data04.dbf';
set newname for datafile 15 to '/u01/oraprod/db/apps_st/data/a_txn_ind06.dbf';
set newname for datafile 16 to '/u01/oraprod/db/apps_st/data/a_ref03.dbf';
set newname for datafile 17 to '/u01/oraprod/db/apps_st/data/a_int02.dbf';
set newname for datafile 18 to '/u01/oraprod/db/apps_st/data/sysaux02.dbf';
set newname for datafile 314 to '/u01/oraprod/db/apps_st/data/portal01.dbf';
set newname for datafile 379 to '/u01/oraprod/db/apps_st/data/undo01.dbf';
set newname for datafile 392 to '/u01/oraprod/db/apps_st/data/a_txn_data01.dbf';
set newname for datafile 393 to '/u01/oraprod/db/apps_st/data/a_txn_ind01.dbf';
set newname for datafile 394 to '/u01/oraprod/db/apps_st/data/a_ref01.dbf';
set newname for datafile 395 to '/u01/oraprod/db/apps_st/data/a_int01.dbf';
set newname for datafile 396 to '/u01/oraprod/db/apps_st/data/a_summ01.dbf';
set newname for datafile 397 to '/u01/oraprod/db/apps_st/data/a_nolog01.dbf';
set newname for datafile 398 to '/u01/oraprod/db/apps_st/data/a_archive01.dbf';
set newname for datafile 399 to '/u01/oraprod/db/apps_st/data/a_queue01.dbf';
set newname for datafile 400 to '/u01/oraprod/db/apps_st/data/a_media01.dbf';
set newname for datafile 401 to '/u01/oraprod/db/apps_st/data/a_txn_data02.dbf';
set newname for datafile 402 to '/u01/oraprod/db/apps_st/data/a_txn_data03.dbf';
set newname for datafile 403 to '/u01/oraprod/db/apps_st/data/a_txn_ind02.dbf';
set newname for datafile 404 to '/u01/oraprod/db/apps_st/data/a_txn_ind03.dbf';
set newname for datafile 405 to '/u01/oraprod/db/apps_st/data/a_txn_ind04.dbf';
set newname for datafile 406 to '/u01/oraprod/db/apps_st/data/a_txn_ind05.dbf';
set newname for datafile 407 to '/u01/oraprod/db/apps_st/data/a_ref02.dbf';
restore database;
switch datafile all;
}
14.
RMAN>list backup of archivelog all;
Thrd Seq
1 13
RUN {
set until sequence 14 thread 1;
recover database;
}
15.
>- Rename online LOGFILES:
sqlplus / as sysdba
select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/u01/app/orauat/db/apps_st/data/log02a.dbf
/u01/app/orauat/db/apps_st/data/log02b.dbf
/u01/app/orauat/db/apps_st/data/log01a.dbf
/u01/app/orauat/db/apps_st/data/log01b.dbf
alter database rename file '/u01/app/orauat/db/apps_st/data/log02a.dbf' to '/u01/oraprod/db/apps_st/data/log02a.dbf';
alter database rename file '/u01/app/orauat/db/apps_st/data/log02b.dbf' to '/u01/oraprod/db/apps_st/data/log02b.dbf';
alter database rename file '/u01/app/orauat/db/apps_st/data/log01a.dbf' to '/u01/oraprod/db/apps_st/data/log01a.dbf';
alter database rename file '/u01/app/orauat/db/apps_st/data/log01b.dbf' to '/u01/oraprod/db/apps_st/data/log01b.dbf';
>- Open database using resetlogs:
SQL> alter database open resetlogs;
>- Create and drop TEMP tablspace
select name from v$tempfile;
/u01/app/orauat/db/apps_st/data/temp01.dbf
/u01/app/orauat/db/apps_st/data/temp02.dbf
create TEMPORARY TABLESPACE TEMP3 TEMPFILE '/u01/oraprod/db/apps_st/data/temp003.dbf' size 4000M;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp3;
drop tablespace temp1 including contents and datafiles;
drop tablespace temp2 including contents and datafiles;
16.
>- Change database name using "nid" command
SQL> shut immediate
SQL> startup nomount pfile='/u01/oraprod/db/tech_st/11.1.0/dbs/initUAT.ora';
SQL> alter database mount;
SQL> select open_mode, name from v$database;
OPEN_MODE NAME
---------- ---------
MOUNTED UAT
$ nid TARGET=sys DBNAME=PROD
Password: as sysdba
Connected to database UAT (DBID=2998215867)
Change database ID and database name UAT to PROD? (Y/[N]) => Y
Database ID for database PROD changed to 385712722.
All previous backups and archived redo logs for this database are unusable.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID - Completed succesfully.
Instance shutdown complete
17.- Change ORACLE_SID in environment file and start database with reset logs:
Oracle Home:/u01/oraprod/db/tech_st/11.1.0
PROD_tos01.env
$grep ORACLE_SID PROD_tos01.env
ORACLE_SID="PROD"
export ORACLE_SID
[oraprod@tos01 dbs]$ vi initUAT.ora
(changed from UAT TO PROD)
db_name = PROD
[oraprod@tos01 dbs]$ mv initUAT.ora initPROD.ora
Now start with pfile initPROD.ora
SQL> startup nomount pfile='/u01/oraprod/db/tech_st/11.1.0/dbs/initPROD.ora';
SQL> alter database mount;
alter database open resetlogs;
SQL> select open_mode, name from v$database;
OPEN_MODE NAME
---------- ---------
READ WRITE PROD
18.
>- Run autoconfig on database Tier:
cd $ORACLE_HOME/appsutil/scripts/PROD_tos01
/u01/oraprod/db/tech_st/11.1.0/appsutil/scripts/PROD_tos01
sh adautocfg.sh
AutoConfig completed successfully.
>Run clone Configuration script on application Tier(applprod)
/u01/applprod/apps/apps_st/comn/clone/bin
perl adcfgclone.pl appsTier
Target System Hostname (virtual or normal) [tos01] :
Target System Database SID : PROD
Target System Database Server Node [tos01] :
Target System Base Directory : /u01/applprod/apps
Target System Tools ORACLE_HOME Directory [/u01/applprod/apps/apps/tech_st/10.1.2] : /u01/applprod/apps/tech_st/10.1.2
Target System Web ORACLE_HOME Directory [/u01/applprod/apps/apps/tech_st/10.1.3] : /u01/applprod/apps/tech_st/10.1.3
Target System APPL_TOP Directory [/u01/applprod/apps/apps/apps_st/appl] : /u01/applprod/apps/apps_st/appl
Target System COMMON_TOP Directory [/u01/applprod/apps/apps/apps_st/comn] : /u01/applprod/apps/apps_st/comn
Target System Instance Home Directory [/u01/applprod/apps/inst] : /u01/applprod/apps/inst
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 [disabled] :
Do you want to preserve the Display [tos02:0.0] (y/n) ? : n
Target System Display [tos01: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] : 80
19.Entry in bash profile.
APPS:
ADD ENTRY TO .bash profile:
. /u01/applprod/apps/apps_st/appl/APPSPROD_tos01.env
http://192.168.1.4:8080
DB:
. /u01/oraprod/db/tech_st/11.1.0/PROD_tos01.env
REMOVE ALL UNWANTED PARAMETER FILE FROM OH/DBS LOCATION , FOR AVOIDING CONFLICTING.
CREATE spfile from pfile.And Use spfile,Renamed pfile also.
PROFILE OPTION:
Java%
Site Name
SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;
commit;
- Running autoconfig on database Tier:
/u01/oraprod/db/tech_st/11.1.0/appsutil/scripts/PROD_tos01/
sh adautocfg.sh
- Running autoconfig on application Tier:
/u01/applprod/apps/inst/apps/PROD_tos01/admin/scripts
sh adautocfg.sh
WF:
select TEXT_VALUE from WF_NOTIFICATION_ATTRIBUTES ;
select TEXT_VALUE from WF_ITEM_ATTRIBUTE_VALUES;
select GUID from WF_SYSTEMS;
select NAME from WF_SYSTEMS;
select ADDRESS from WF_AGENTS;
select WEB_HOST_NAME from FND_FORM_FUNCTIONS;
select WEB_AGENT_NAME from FND_FORM_FUNCTIONS;
select LOGFILE_NAME from FND_CONCURRENT_REQUESTS;
select OUTFILE_NAME from FND_CONCURRENT_REQUESTS;
4. Verify the APPLCSF variable setting
s_applcsf variable in the context file and then run AutoConfig.
5.
5. Update the SESSION_COOKIE_DOMAIN value in ICX_PARAMETERS
select SESSION_COOKIE_DOMAIN from ICX_PARAMETERS;
select home_url from ICX_PARAMETERS;
Subscribe to:
Posts (Atom)