07 August 2012

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

Business Continuity Oracle E-Business Release 12 Using Oracle 11g Physical Standby Database Part -4

On Stand by server :-

SQL> startup nomount
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
SQL> alter database mount standby database;

Database altered.

SQL> alter database open read only;

Database altered.

SQL> alter database register physical logfile '/xprodarch/xprodarch/XPROD/archive/XPROD_1_152_789237530.arch';

Switch over to Primary as a Standby

SQL> startup
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.
Database opened.
SQL> alter database commit to switchover to primary with session shutdown;

Database altered.

SQL> select open_mode from v$database;

OPEN_MODE
----------
READ WRITE

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /xprodarch/xprodarch/XPROD/archive
Oldest online log sequence 180
Next log sequence to archive 181
Current log sequence 181
SQL> alter system switch logfile;

System altered.

SQL> select switchover_status from v$database;

SWITCHOVER_STATUS
--------------------
TO STANDBY

SQL> shut immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup nomount
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
SQL> alter database mount;

Database altered.

SQL> alter database open;

Database altered.

SQL> alter database recover managed standby database disconnect from session;

Database altered.

SQL> select open_mode from v$database;

OPEN_MODE
----------
MOUNTED

SQL> show parameter;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_2 string enable

SQL> alter system set log_archive_dest_state_2=defer;

System altered.

SQL> select switchover_status from v$database;

SWITCHOVER_STATUS
--------------------
SESSIONS ACTIVE

SQL> select database_role, open_mode from v$database;

DATABASE_ROLE OPEN_MODE
---------------- ----------
PHYSICAL STANDBY MOUNTED

SQL>

Switching Standby as a Primary :-

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /xprodarch/xprodarch/XPROD/archive
Oldest online log sequence 178
Next log sequence to archive 0
Current log sequence 182

SQL> alter database recover managed standby database disconnect from session;

Database altered.

SQL> select open_mode from v$database;

OPEN_MODE
----------
MOUNTED

SQL> alter database open;

Database altered.

SQL> select open_mode from v$database;

OPEN_MODE
----------
READ ONLY

SQL> alter database commit to switchover to primary with session shutdown;

Database altered.

SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
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.
Database opened.
SQL> show parameter;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_2 string defer

SQL> alter system set log_archive_dest_state_2=enable;

System altered.

SQL> select database_role, open_mode from v$database;

DATABASE_ROLE OPEN_MODE
---------------- ----------
PRIMARY READ WRITE

SQL>

Preparing Standby application :-

$ sqlplus apps/apps

SQL> exec fnd_conc_clone.setup_clean

Run auto Config on Database tier

$ adclonectx.pl /xprodfm/xprodfm/XPROD/inst/apps/XPROD_bcibms22/appl/admin/XPROD_bcibms22.xml

Copyright (c) 2002 Oracle Corporation
Redwood Shores, California, USA

Oracle Applications Rapid Clone

Version 12.0.0

adclonectx Version 120.23.12010000.1

Running:
/xprodfm/xprodfm/XPROD/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /xprodfm/xprodfm/XPROD/apps/apps_st/comn/clone/bin/../jlib/ojdbc14.jar:/xprodfm/xprodfm/XPROD/apps/apps_st/comn/clone/bin/../jlib/xmlparserv2.jar:/xprodfm/xprodfm/XPROD/apps/apps_st/comn/clone/bin/../jlib/java oracle.apps.ad.context.CloneContext -e /xprodfm/xprodfm/XPROD/inst/apps/XPROD_bcibms22/appl/admin/XPROD_bcibms22.xml
Enter the APPS password : apps

Log file located at /xprodfm/xprodfm/XPROD/apps/apps_st/comn/clone/bin/CloneContext_0728123328.log

Provide the values required for creation of the new APPL_TOP Context file.

Target System Hostname (virtual or normal) [bcibmp15] :

It is recommended that your inputs are validated by the program.
However you might choose not to validate them under following circumstances:

-If cloning a context on source system for a remote system.
-If cloning a context on a machine where the ports are taken and
you do not want to shutdown the services at this point.
-If cloning a context but the database it needs to connect is not available.

Do you want the inputs to be validated (y/n) [n] ? :
Target System Database SID : XPROD
Target System Database Server Node [bcibmp15] :
Target System Base Directory : /xprodfm/xprodfm/XPROD
Target System Tools ORACLE_HOME Directory [/xprodfm/xprodfm/XPROD/apps/tech_st/10.1.2] :
Target System Web ORACLE_HOME Directory [/xprodfm/xprodfm/XPROD/apps/tech_st/10.1.3] :
Target System APPL_TOP Directory [/xprodfm/xprodfm/XPROD/apps/apps_st/appl] :
Target System COMMON_TOP Directory [/xprodfm/xprodfm/XPROD/apps/apps_st/comn] :
Target System Instance Home Directory [/xprodfm/xprodfm/XPROD/inst] :
Username for the Applications File System Owner [xappl] :
Group for the Applications File System Owner [dba] :
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 [bcibms22:0.0] (y/n) ? : n
Target System Display [bcibmp15: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] : 50
Checking the port pool 50
done: Port Pool 50 is free
Report file located at /xprodfm/xprodfm/XPROD/inst/apps/XPROD_bcibmp15/admin/out/portpool.lst
Complete port information available at /xprodfm/xprodfm/XPROD/inst/apps/XPROD_bcibmp15/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp
2. /xprodtmp
3. /xproddb/xproddb/XPROD/db/tech_st/11.1.0/appsutil/outbound/XPROD_bcibmp15
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] : 2

Creating the new APPL_TOP Context file from :
/xprodfm/xprodfm/XPROD/apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmp

The new APPL_TOP context file has been created :
/xprodfm/xprodfm/XPROD/inst/apps/XPROD_bcibmp15/appl/admin/XPROD_bcibmp15.xml

Log file located at /xprodfm/xprodfm/XPROD/apps/apps_st/comn/clone/bin/CloneContext_0728123328.log
contextfile=/xprodfm/xprodfm/XPROD/inst/apps/XPROD_bcibmp15/appl/admin/XPROD_bcibmp15.xml
Check Clone Context logfile /xprodfm/xprodfm/XPROD/apps/apps_st/comn/clone/bin/CloneContext_0728123328.log for details.
$ pwd
/xprodfm/xprodfm/XPROD/apps/apps_st/comn/clone/bin

Run adconfig on Application Tier using new Context file .

Failover testing on DbTier:-

xdb@pbcibms55(/home/xdb)# sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on Sun Jul 29 14:25:52 2012

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> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;
Database altered.
SQL> ALTER DATABASE ACTIVATE STANDBY DATABASE;
Database altered.
SQL> shut immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup
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.
Database opened.
SQL> conn apps/apps
Connected.
SQL> select REQUEST_DATE,REQUEST_ID,LAST_UPDATE_DATE from fnd_concurrent_requests where REQUEST_ID='11272536';
REQUEST_D REQUEST_ID LAST_UPDA
--------- ---------- ---------
29-JUL-12 11272536 29-JUL-12

SQL> select name,DATABASE_ROLE,OPEN_MODE from v$database;

NAME DATABASE_ROLE OPEN_MODE
--------- ---------------- ----------
XPROD PRIMARY READ WRITE
SQL>

 

 

 


No comments: