Share the content if you found it is useful (You can share using 300 community websites) click "share" at the end of the post.

You are encouraged to leave a comment.








Wednesday, December 10, 2008

Hot Backup Cloning of Oracle Applications.

HOT BACKUP CLONING
Balaji R S 25.11.2008

Source System (SAM1):
(a)P4 3.0 GHz System with 2GB RAM and 200 GB HDD (Redhat Linux AS 4)
/d01 ——40GB (Application Tier Files)
/d02 ——10GB (10g Oracle Home)
/d03 ——80GB (Data Files)
/backup —100GB (NFS mount point Shared on TEST Server)

Hostname: sam1server
Application Version: 11.5.10.2
Database Version: 10.2.0.2 Target System (TEST):
(b) P4 2.6 GHz system with 1.5 GB RAM with 300 GB HDD (Redhat Linux AS4)
/d01 ——40GB (Application Tier Files)
/d02 ——10GB (10g Oracle Home)
/d03 ——80GB (Data Files)
/backup —100GB(NFS Share Directory)

Hostname: testserver
Application Version: 11.5.10.2
Database Version: 10.2.0.2

Note: This target System was previously cloned with cold backup. This is second time

cloning with Hot Backup from SAMSERVER.

Stage1: Prerequisites:
========> Apply OUI22 Patch, 5035661 to every IAS Oracle Home and RDBMS Oracle Home to be cloned.
If you are having 10g Oracle Home, there is no need of applying this patch.
You need to apply this patch on IAS Oracle Home (if Database is not 10g)
________________________________________________________________
A. Applying the patch on the iAS $ORACLE_HOME:
________________________________________________________________

(a) Unzip the patch into the
$unzip od /d01/sam1ora/iAS p5035661_11i_LINUX.zip
(b) Source the Apps environment file :
$. $APPL_TOP/APPSORA.env
(c) Change directory to the
$cd $IAS_ORACLE_HOME/appsoui/setup
(d) Execute the perl script OUIsetup.pl:
$perl OUIsetup.pl


NOTE: In the case of a MultiNode instance, the above process should be repeated on the other nodes also.


(B) Applying the patch on the RDBMS $ORACLE_HOME:
(This step is not required for my current setup, because my database version is 10g R2)
(a) Unzip the patch into the
$unzip od
/u01/sam1db/9.2.0 p5035661_11i_LINUX.zip
(b) Source the DB environment file :
$. $ORACLE_HOME/SAM1_sam1server.env
(c) Change directory to the
$cd $ORACLE_HOME/appsoui/setup
(d) Execute the perl script OUIsetup.pl:
$perl OUIsetup.pl

======> Check all other Requirements as Perl, JRE, JDK, ZIP utilities
on Source and Target Nodes as per document
Cloning Oracle Applications Release 11i with Rapid Clone”

=======> Apply the Latest AD Minipack on Application Tier (AD.I.6)
=======รจ Apply the Latest Autoconfig Template Patch and Latest Rapidclone Patches to Application Tier (Check Metalink for These Patches)

Stage2: Prepare the Source System (SAM1SERVER)

(a) Login into Database Tier as ORACLE user and run the preclone

$cd $ORACLE_HOME/appsutil/scripts/SAM1_sam1server
$perl adpreclone.pl dbTier

(b) Login into the Application Tier as APPLMGR User and run the preclone

$cd $COMMON_TOP/admin/scripts/SAM1_sam1server
$perl adpreclone.pl appsTier

Stage3: Put the Database in Begin Backup Mode and copy the Database

Files
(a) Login into database as sysdba user
$sqlplus “/as sysdba”
Sql> alter database begin backup;
(b) Copy Archive log files created during hot backup to /
backup directory.
(c) Copy the All Data files to /backup directory.
(d) Backup the control file to trace.
Sql> alter database backup control file to trace;
Copy this trace file to /backup directory
(e) Copy the current init.ora file to /backup directory
(f) End the Begin Backup Mode.
Sql> alter database end backup

Stage4: Copy the Application Tier File System Files

(a)Login into the Application Tier as APPLMGR user and copy the APPL_TOP, COMMON_TOP,
IAS ORACLE HOME and 8.0.6 Oracle Home to /backup directory

Stage5: Copy the Source Database files and Application Files to Target server
Copy the parameter file, backup control file and archive log files from /backup directory to /d01, /d02 and /d03 in target server.

Stage 6: Configure the Target Database (TESTSERVER)
Log on to the target system as the ORACLE user
(1) Configure the
cd
perl adcfgclone.pl dbTechStack
(2) Create the target database control file manually.
Open the backed up control file
a. remove all lines before the startup nomount statement
b. Modify the REUSE to SET
c. Modify Source DB SID to Target SID (Here SAM1 to TEST)
d. Modify NORESETLOGS TO RESETLOGS
e. delete all lines after the CHARACTER SET statement
————————————
CREATE CONTROLFILE SET DATABASE “TEST”
NORESETLOGS ARCHIVELOG…
LOGFILEGROUP 1
/d03/log01.log’ SIZE 50M,

DATAFILE
/d03/system01.dbf’,
/d03/undotbs01.dbf’,

CHARACTER SET UTF8;
__________________________________________________________________________________________
On the target system, modify the init.ora to have the target SID and location of the control file and also make sure that init.ora parameters are set for archive log mode On the target system,starup the database in nomount stage.
sql> startup nomount pfile=<>
sql> @clone.ctl ( here clone.ctl is the control file which we have modified above)
Once control file is created, database will be in mount stage
execute recover command using backup control file after the database is
mounted
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
After the last archive log has been applied, issue the following command
SQL> alter database open resetlogs;
After opening the database, add temp files to target database
(3) Run the library update script against the database
cd

sqlplus “/ as sysdba” @adupdlib.sql

Where

so” for any other UNIX platform and not
required for Windows.

(4)Configure the target database (the database must be open)
cd
perl adcfgclone.pl dbconfig
where target context file is:
Stage 7 : Configure the Target Application Tier
Logon to the target system as the APPLMGR user and type the following
commands
$Cd $COMMON_TOP/clone/bin
$Perl adcfgclone.pl appsTier
Finishing tasks:
(1) Update Profile options
(2) Update Printer Settings
(3) Update the workflow configuration settings
(4) Verify the APPLCSF variable setting
(5) Update the session_cookie_domain value in icx_parameters
For the finishing tasks, check the finishing tasks section of the following document
Cloning Oracle Applications Release 11i with rapid clone Note: 230672.1

Cheers...


No comments:

Related Posts Plugin for WordPress, Blogger...

Let us be Friends...

Share |

Popular Posts

Labels

11.5.1. to 11.5.5 Cloning Procedure. 11g 11i 11i and R12 11i Autoconfig 11i Cloning 12.1.1 SSL 2 Node RAC Adconfig.sh errors out adgennls.pl adop Advanced Replication Apache version Apex Apex for Oracle database Apex Installation Apex Installation on Oracle E Business Suite. 11i with Apex Apex on 11i Apex on Oracle 11i Apex402 apexins.sql APPL_TOP Character Application Express Application server Issue APPLSYS password Apps Password Asynchronous Replication Autoconfig Autoconfig Managed Beehive Bit of operating system Block block media corrupt BPEL Central Inventory Character Set Conversion Cloning of 11i Cloning of Oracle Applications Clusterware Concurrent CPU 2011 CPU 2012 April CPU 2012 January. CPU 2012 October CRS custom top Custom Top Creation Database . Database Query Dataguard DBMS_REPAIR Demantra . Domain Name E Business Suite Migration EBS 12.2 EPM exp/imp Oracle Applications Flashback table flows_020200 FND_TOP/resource FNDCPASS FNDCPUCF Forms server upgrade Forms startup FRM-92101 Fusion Middleware Hostname Hot Backup Hot cloning HotBackup Hotbackup Cloning of Oracle Apps hrglobal.drv. NLS Saudi Arabian HRMS hyperion Import and Export Oracle Applications Install Oracle Installation of R12 Installation Steps integration Oracle EBS Issues Database issues Oracle EBS Issues with Upgrade 12.1.1 Java Mission Control Java Upgrade java/sql/SavePoint JInitiator Junk Characters Language Translation Linux Linux Migration listener trace Listner version Local Inventory Login Page Master-Master Replication Memory Tuning Multiple Language NLS Non-Autoconfig Enabled OBIEE 11g Installation OBIEE Issues OIM Opatch version OpenSSL ora-01031 Oracle oracle 11g Oracle Announcement Oracle Application servers Oracle Application services Oracle Applications Oracle Applications 11i oracle applications 12.2 Oracle Applications Cloning Oracle Applications Upgrade Oracle Applications. Oracle Apps cloning Oracle BPEL oracle certifications oracle database Oracle Database RMAN Oracle Database upgradation Oracle DB oracle E Business suite 12.2 Oracle EBS oracle EPM Oracle Forms Logo oracle Fusion Applications Oracle Inventory oracle news Oracle OUI Oracle R12 oracle Sun Solaris Oracle Tuning Oracle Virtual Box Oracle Webgate Oracle WMA configuration orcladmin password for Oracle Applications Pasta Configuration pasta.cfg patch PDF Performance Physical Standby Platform migration Printer Configuration Profile Option R12 RAC Rapid Install Rapidwiz Real Application Clusters 10g Recovery RMAN RMAN Recovery SA Gosi Service Oriented Architecture SOA SQLTXPLAIN SSL Configuration step-by-step upgrade Sun solaris Swap Tablespace Trace Enable Trace file Translation Synchronization Patch transport tablespace tuning Tuning SGA uifont.ali Underscore Universal Content Management updates.oracle.com Upgradation of 12.0.5 to 12.1.1 Upgrade Upgrade 11g Upgrade Apps Upgrade DB Upgrade to 11g UTF8 version of oracle applications versions Web server upgrade weblogic windows workflow version XML Publisher version