![]() ![]() (3) Update the workflow configuration settings Logon to the target system as the APPLMGR user and type the following commands Stage 7 : Configure the Target Application Tier Where target context file is: /appsutil/. ![]() (4)Configure the target database (the database must be open) Where is “sl” for HP-UX, “so” for any other UNIX platform and not required for Windows. (3) Run the library update script against the database SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL Īfter the last archive log has been applied, issue the following commandĪfter opening the database, add temp files to target database Once control file is created, database will be in mount stageĮxecute recover command using backup control file after the database is mounted Sql> ( here clone.ctl is the control file which we have modified above) 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, delete all lines after the CHARACTER SET statementĬREATE CONTROLFILE SET DATABASE “TEST” NORESETLOGS ARCHIVELOG… Modify Source DB SID to Target SID (Here PROD to TEST)Į. remove all lines before the startup nomount statementĬ. (2) Create the target database control file manuallyĪ. Log on to the target system as the ORACLE user Stage 6: Configure the Target Database (TESTSERVER) 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. 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. (c) Copy the All Data files to /backup directory. $ORACLE_HOME/PROD_prodserver.env ( c) Change directory to the /appsoui/setup $cd $ORACLE_HOME/appsoui/setup ( d) Execute the perl script : $perl => Check all other Requirements as Perl, JRE, JDK, ZIP utilities on Source and Target Nodes as per document “Cloning Oracle Applications Release 11i with Rapid Clone” => Apply the Latest AD Minipack on Application Tier (Latest One is AD.I.5) =è Apply the Latest Autoconfig Template Patch and Latest Rapidclone Patches to Application Tier (Check Metalink for These Patches) Stage2: Prepare the Source System (PRODSERVER) (a) Login into Database Tier as ORACLE user and run the preclone $cd $ORACLE_HOME/appsutil/scripts/PROD_prodserver $perl dbTier (b) Login into the Application Tier as APPLMGR User and run the preclone $cd $COMMON_TOP/admin/scripts/PROD_prodserver $perl 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. ![]() (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 directory: $unzip -od /u01/proddb/9.2.0 p5035661_11i_LINUX.zip (b) Source the DB environment file : $. $APPL_TOP/APPSORA.env ( c) Change directory to the /appsoui/setup $cd $IAS_ORACLE_HOME/appsoui/setup (d ) Execute the perl script : $perl NOTE: In the case of a Multi-Node instance, the above process should be repeated on the of each Node. Applying the patch on the iAS $ORACLE_HOME: = (a) Unzip the patch into the directory: $unzip -od /d01/prodora/iAS p5035661_11i_LINUX.zip ( b) Source the Apps environment file : $. You need to apply this patch on IAS Oracle Home (if Database is not 10g)Ī. ![]() If you are having 10g Oracle Home, there is no need of applying this patch. Stage1: Prerequisites: => Apply OUI22 Patch, 5035661 to every IAS Oracle Home and RDBMS Oracle Home to be cloned. This is second time cloning with Hot Backup from PRODSERVER. Note: This target System was previously cloned with cold backup. (b) P4 2.6 GHz system with 1.5 GB RAM with 300 GB HDD (Redhat Linux AS 4) backup - 100 GB (NFS mount point Shared on TEST Server)ĭatabase Version: 10.2.0.2 Target System (TEST): (a) P4 3.0 GHz System with 2GB RAM and 200 GB HDD (Redhat Linux AS 4) Here I am sharing the information that, what i follow during the hotbackup cloning. So we thought that, if we write one article regarding this, it will be more useful for the apps newbies. We are getting lot of questions on Hot Backup Cloning of 11i in the forum. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |