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

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

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>

Thalai Muthu Oracle Apps DBA

07 August 2012

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

On Stand by server :-

Switch over to Primary as a Standby

Switching Standby as a Primary :-

Preparing Standby application :-

Failover testing on DbTier:-

No comments: