Step by Step Create Business Continuity Oracle E-Business Release 12 Using Oracle 11g Physical Standby Database Part -2

 BusinessContinuity Oracle E-Business Release 12 Using Oracle 11g Physical Standby Database Part -2

Primary Server Cloning Process:-

DB Tier:-

xdb@pbcibms22(/xproddb/xproddb/XPROD/db/tech_st/11.1.0/appsutil/scripts/XPROD_bcibms55)# perl 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.2

Enter the APPS User Password:

Running:

perl /xproddb/xproddb/XPROD/db/tech_st/11.1.0/appsutil/bin/adclone.pl java=/xproddb/xproddb/XPROD/db/tech_st/11.1.0/appsutil/jre mode=stage stage=/xproddb/xproddb/XPROD/db/tech_st/11.1.0/appsutil/clone component=dbTier method=CUSTOM dbctx=/xproddb/xproddb/XPROD/db/tech_st/11.1.0/appsutil/XPROD_bcibms55.xml showProgress

APPS Password :

Setting LIBPATH to /xproddb/xproddb/XPROD/db/tech_st/11.1.0/oui/lib/aix

Beginning database tier Stage - Thu Jul 26 19:36:09 2012

/xproddb/xproddb/XPROD/db/tech_st/11.1.0/appsutil/jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/xproddb/xproddb/XPROD/db/tech_st/11.1.0/oui -classpath /xproddb/xproddb/XPROD/db/tech_st/11.1.0/lib/xmlparserv2.jar:/xproddb/xproddb/XPROD/db/tech_st/11.1.0/jdbc/lib/ojdbc6.jar:/xproddb/xproddb/XPROD/db/tech_st/11.1.0/appsutil/java:/xproddb/xproddb/XPROD/db/tech_st/11.1.0/oui/jlib/OraInstaller.jar:/xproddb/xproddb/XPROD/db/tech_st/11.1.0/oui/jlib/ewt3.jar:/xproddb/xproddb/XPROD/db/tech_st/11.1.0/oui/jlib/share.jar:/xproddb/xproddb/XPROD/db/tech_st/11.1.0/oui/jlib/srvm.jar:/xproddb/xproddb/XPROD/db/tech_st/11.1.0/jlib/ojmisc.jar oracle.apps.ad.clone.StageDBTier -e /xproddb/xproddb/XPROD/db/tech_st/11.1.0/appsutil/XPROD_bcibms55.xml -stage /xproddb/xproddb/XPROD/db/tech_st/11.1.0/appsutil/clone -tmp /tmp -method CUSTOM -showProgress

APPS Password :

Log file located at /xproddb/xproddb/XPROD/db/tech_st/11.1.0/appsutil/log/XPROD_bcibms55/StageDBTier_07261936.log

/ 50% completed

Completed Stage...

Thu Jul 26 19:36:33 2012

xdb@pbcibms22(/xproddb/xproddb/XPROD/db/tech_st/11.1.0/appsutil/scripts/XPROD_bcibms55)#

Primary Server AppsTier :-

xappl@pbcibms22(/xprodfm/xprodfm/XPROD/inst/apps/XPROD_bcibms22/admin/scripts)#perl 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.2

Running:

perl /xprodfm/xprodfm/XPROD/apps/apps_st/appl/ad/12.0.0/bin/adclone.pl java=/xprodfm/xprodfm/XPROD/apps/tech_st/10.1.3/appsutil/jdk mode=stage stage=/xprodfm/xprodfm/XPROD/apps/apps_st/comn/clone component=appsTier method= appctx=/xprodfm/xprodfm/XPROD/inst/apps/XPROD_bcibms22/appl/admin/XPROD_bcibms22.xml showProgress

APPS Password :

method defaulted to CUSTOM

Setting LIBPATH to /xprodfm/xprodfm/XPROD/apps/tech_st/10.1.3/oui/lib/aix

Beginning application tier Stage - Thu Jul 26 19:38:51 2012

/xprodfm/xprodfm/XPROD/apps/tech_st/10.1.3/appsutil/jdk/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /xprodfm/xprodfm/XPROD/apps/tech_st/10.1.3/lib/xmlparserv2.jar:/xprodfm/xprodfm/XPROD/apps/tech_st/10.1.3/jdbc/lib/ojdbc14.jar:/xprodfm/xprodfm/XPROD/apps/apps_st/comn/java/classes:/xprodfm/xprodfm/XPROD/apps/tech_st/10.1.3/oui/jlib/OraInstaller.jar:/xprodfm/xprodfm/XPROD/apps/tech_st/10.1.3/oui/jlib/ewt3.jar:/xprodfm/xprodfm/XPROD/apps/tech_st/10.1.3/oui/jlib/share.jar:/xprodfm/xprodfm/XPROD/apps/tech_st/10.1.3/oui/jlib/srvm.jar:/xprodfm/xprodfm/XPROD/apps/tech_st/10.1.3/jlib/ojmisc.jar oracle.apps.ad.clone.StageAppsTier -e /xprodfm/xprodfm/XPROD/inst/apps/XPROD_bcibms22/appl/admin/XPROD_bcibms22.xml -stage /xprodfm/xprodfm/XPROD/apps/apps_st/comn/clone -tmp /tmp -method CUSTOM -showProgress

Log file located at /xprodfm/xprodfm/XPROD/inst/apps/XPROD_bcibms22/admin/log/StageAppsTier_07261938.log

- 80% completed

Completed Stage...

Thu Jul 26 19:39:16 2012

xappl@pbcibms22(/xprodfm/xprodfm/XPROD/inst/apps/XPROD_bcibms22/admin/scripts)#

Shut down Your Application using adstpall.sh -------------Your Down time started here

Shut down Your DB and Listner -------------Your Down time started here

xdb@pbcibms22(/xproddb/xproddb/XPROD/db/tech_st/11.1.0/appsutil/scripts/XPROD_bcibms55)# sqlplus

SQL*Plus: Release 11.1.0.7.0 - Production on Thu Jul 26 19:40:04 2012

Copyright (c) 1982, 2008, Oracle. All rights reserved.

Enter user-name: /as sysdba

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> 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

xdb@pbcibms22(/xproddb/xproddb/XPROD/db/tech_st/11.1.0/appsutil/scripts/XPROD_bcibms55)# lsnrctl stop XPROD

LSNRCTL for IBM/AIX RISC System/6000: Version 11.1.0.7.0 - Production on 26-JUL-2012 19:41:11

Copyright (c) 1991, 2008, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bcibms55.hilbcdom.com)(PORT=1571)))

The command completed successfully

xdb@pbcibms22(/xproddb/xproddb/XPROD/db/tech_st/11.1.0/appsutil/scripts/XPROD_bcibms55)#

Copy all file from Primary to Standby server

xdb@pbcibms22(/xproddb/xproddb/XPROD/db/tech_st/11.1.0/appsutil/scripts/XPROD_bcibms55)# sqlplus

SQL*Plus: Release 11.1.0.7.0 - Production on Fri Jul 27 09:37:01 2012

Copyright (c) 1982, 2008, Oracle. All rights reserved.

Enter user-name: /as sysdba

Connected to an idle instance.

SQL> startup mount

ORACLE instance started.

Total System Global Area 2137886720 bytes

Fixed Size 2155464 bytes

Variable Size 452987960 bytes

Database Buffers 1660944384 bytes

Redo Buffers 21798912 bytes

Database mounted.

SQL> alter database create standby controlfile as '/xproddata1/controll01.dbf';

Database altered.

SQL>alter database open;

Database altered.

SQL>alter system switch logfile;

System altered.

SQL>select thread#, sequence#-1 from v$log where status ='CURRENT';

THREAD# SEQUENCE#-1

---------- -----------

1 80

SQL>

Step by Step Create Business Continuity Oracle E-Business Release 12 Using Oracle 11g Physical Standby Database Part -3  Click here