07 August 2012

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

No comments: