One .1  BLOG Document structure chart

wps5311.tmp 

 

 

One .2   Preface

 

One .2.1   Reading guide

Technology enthusiasts , After reading this article , You can master the following skills , You can also learn something else you don't know ,~O(∩_∩)O~：

① Data Guard Broker Configuration of

② Fast-Start Failover Configuration of

③ Oracle DataGuard Client of TAF To configure

④ Use DGMGRL To manage the database

⑤  Physics dg Management and maintenance of some sql

⑥ DataGuard Client special configuration

 

Be careful ： This article BLOG I use yellow background and red font to show the places that need special attention in the code part of , For example, in the following example ,thread 1 The maximum archive log number for is 33,thread 2 The maximum archive log number for is 43 It's something that needs special attention .

  List of Archived Logs in backup set 11

  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time

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

  1    32      1621589    2015-05-29 11:09:52 1625242    2015-05-29 11:15:48

  1    33      1625242    2015-05-29 11:15:48 1625293    2015-05-29 11:15:58

  2    42      1613951    2015-05-29 10:41:18 1625245    2015-05-29 11:15:49

  2    43      1625245    2015-05-29 11:15:49 1625253    2015-05-29 11:15:53

 

 

 

 

 

If there are any mistakes or imperfections in this article, please correct them ,ITPUB Message or QQ All can , Your criticism is the biggest motivation of my writing .

One .2.2   Introduction to the experimental environment

 

  project

Main library

dg library

db  type

Single instance

Single instance

db version

11.2.0.3

11.2.0.3

db  Storage

FS type

FS type

ORACLE_SID

oradg11g

oradgphy

db_name

oradg11g

oradg11g

host IP Address ：

192.168.59.130

192.168.59.130

OS Version and kernel edition

RHEL6.5 64 position ,2.6.32-504.16.2.el6.x86_64

RHEL6.5 64 position ,2.6.32-504.16.2.el6.x86_64

OS hostname

rhel6_lhr

rhel6_lhr

 

 

 

One .2.3   Links to related reference articles

 

dg A series of articles ：

【DATAGUARD】 Establish physical backup and logical backup based on the same host （ One ）： http://blog.itpub.net/26736162/viewspace-1448197/ 
【DATAGUARD】 Establish physical backup and logical backup based on the same host （ Two ):  http://blog.itpub.net/26736162/viewspace-1448207/ 
【DATAGUARD】 Establish physical backup and logical backup based on the same host （ 3、 ... and ):  http://blog.itpub.net/26736162/viewspace-1481972/ 
【DATAGUARD】 Establish physical backup and logical backup based on the same host ( Four )-- Add a physical dg node ：http://blog.itpub.net/26736162/viewspace-1484878/

【DATAGUARD】 Physics dg Of switchover Switch （ 5、 ... and ） ：http://blog.itpub.net/26736162/viewspace-1753111/

【DATAGUARD】 Physics dg Of failover Switch ( 6、 ... and )：   http://blog.itpub.net/26736162/viewspace-1753130/

【DATAGUARD】 Physics dg Recovery in the case of lost archive files in the main library ( 7、 ... and ) ： http://blog.itpub.net/26736162/viewspace-1780863/

 

 

 

One .2.4   Brief introduction

 

This article blog Is based on cuug The content of the open class , I do the practical operation myself , Video can refer to ：http://blog.itpub.net/26736162/viewspace-1624453/ , I won't write more about it , hold cuug The content is direct copy Come here , I think it's more useful .

 

This technology, if you don't know , It's not ORACLE master

This technology, if you don't know , You can't say that you will DataGuard

This technology, if you don't know ,......

 

This online course , When the primary and standby databases are switched , How to start a service, Ensure that the client connection can continue , And it can continue select Query operation , No matter which server the primary and secondary libraries are on ; At the same time to ensure that the new customer connection without any problems . There are not many examples on the Internet of this course , Mr. Chen spent nearly a year searching for human flesh , Just recently , I can't wait to share it with you .

 

1、DataGuard Configuration of （ Fast ）

2、 establish service

3、 Create trigger

4、 Active / standby database switching test

 

Because there is so much , I'm going to divide it into 4 This is a chapter to share with you , Paste a picture , Don't strange , There is also a chapter on how to solve the problems in the experiment .

wps5321.tmp 

 

 

One .3   Related knowledge points literacy

 

   oracle Data Guard, Highest data protection at lowest cost . There are no special hardware requirements , Ordinary PC It can be realized by computer .

In a nutshell ,Data Guard, Is to automatically create and maintain the production database （ Or the main database ） One or more transaction consistent copies of （ Standby database ）. If the primary database is not available （ Because of the trouble 、 Maintenance or disaster ）, Then you can activate a standby database and make it play the role of master database . However , After the configuration is complete Data Guard after , If you need to switch between active and standby databases , You need to input multiple commands on the primary database and the standby database , The switching steps are a little cumbersome . therefore , In general ,DBA The entire switching process will be edited into a script , To run automatically , Switch state . Of course ,oracle It also provides tools Data Guard Broker, It is convenient to switch between active and standby databases by inputting only one command at the control side .

stay Data Guard Broker On the basis of , Configure and enable Fast-Start Failover, Can automatically detect the host failure , Realize the active standby switch , Fail over .

 

Data Guard Broker It's based on Data Guard On the basis of a pair of Data Guard To configure , A platform for centralized management and operation .Broker The launch of is to simplify DG Complex management processes , Its biggest function is centralized and unified management .

To configure Data Guard Broker The client tools used are DGMGRL. It's a command line management tool .

 

 

One .4   Experimental part

 

One .4.1   The goal of the experiment

 

Data Guard Broker  And complete the experiment .

 

 

One .4.2   Prerequisite

Pay attention to the prerequisites ,Data Guard Successfully configured .

1.  Set up primary and standby At startup, the parameter file is spfile 

2.  To configure DG_BROKER_CONFIG_FILEn 
DG_BROKER_CONFIG_FILEn representative 2 Parameters , Respectively DG_BROKER_CONFIG_FILE1,DG_BROKER_CONFIG_FILE2, They are Data Guard Broker Profile name for . They all have default values （windows Next is in ORACLE_HOME/database Under the table of contents ,linux Next is in ORACLE_HOME/dbs Under the table of contents ）, So generally, we don't need to make special settings . 

3.  Set up listener 
stay Data Guard Broker Environment , Need to be in listener.ora Add a static service_name by db_unique_name_DGMGRL.db_domain Registration of . This service_name Will be in DGMGRL To restart the database . adopt DGMGRL When you restart the database DMON The process will first shut down the database , then DGMGRL Use this service_name adopt listener Connect to database , Issue a start command .

4.  Set up DG_BROKER_START by TRUE 
This step is to start Data Guard Broker monitor（DMON） process , Need to be in 2 All the databases run the following commands  
alter system set dg_broker_start=true scope=both; 

 

Main warehouse operation ：

[oracle@rhel6_lhr lhr]$ sqlplus / as sysdba

 

SQL*Plus: Release 11.2.0.3.0 Production on Monday 9 month 28 10:17:04 2015

 

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

 

 

Connect to :

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

10:17:04 SQL> show parameter name

 

NAME                                 TYPE        VALUE

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

db_file_name_convert                 string      oradglg, oradg11g

db_name                              string      oradg11g

db_unique_name                       string      oradg11g

global_names                         boolean     FALSE

instance_name                        string      oradg11g

lock_name_space                      string

log_file_name_convert                string      oradglg, oradg11g

processor_group_name                 string

service_names                        string      oradg11g

10:17:08 SQL> show parameter spfile

 

NAME                                 TYPE        VALUE

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

spfile                               string      /u01/app/oracle/product/11.2.0

                                                 /dbhome_1/dbs/spfileoradg11g.o

                                                 ra

10:17:14 SQL>  show parameter DG_BROKER_CONFIG_FILE

 

NAME                                 TYPE        VALUE

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

dg_broker_config_file1               string      /u01/app/oracle/product/11.2.0

                                                 /dbhome_1/dbs/dr1oradg11g.dat

dg_broker_config_file2               string      /u01/app/oracle/product/11.2.0

                                                 /dbhome_1/dbs/dr2oradg11g.dat

10:20:43 SQL> set line 9999

10:20:44 SQL> col name format a10

10:20:44 SQL> col FS_FAILOVER_OBSERVER_HOST format a20

10:20:44 SQL> select dbid,name,current_scn,protection_mode,protection_level,database_role,force_logging,open_mode,switchover_status from v$database;

 

      DBID NAME       CURRENT_SCN PROTECTION_MODE      PROTECTION_LEVEL     DATABASE_ROLE    FOR OPEN_MODE            SWITCHOVER_STATUS

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

1403587593 ORADG11G       2336836 MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE  PRIMARY          YES READ WRITE           TO STANDBY

 

Elapsed time :  00: 00: 00.01

10:20:44 SQL> SELECT d.DBID,

10:20:44   2         d.DB_UNIQUE_NAME,

10:20:44   3         d.FORCE_LOGGING,

10:20:44   4         d.FLASHBACK_ON,

10:20:44   5         d.FS_FAILOVER_STATUS,

10:20:44   6         d.FS_FAILOVER_CURRENT_TARGET,

10:20:44   7         d.FS_FAILOVER_THRESHOLD,

10:20:44   8         d.FS_FAILOVER_OBSERVER_PRESENT,

10:20:44   9         d.FS_FAILOVER_OBSERVER_HOST

10:20:44  10    FROM v$database d;

 

      DBID DB_UNIQUE_NAME                 FOR FLASHBACK_ON       FS_FAILOVER_STATUS     FS_FAILOVER_CURRENT_TARGET     FS_FAILOVER_THRESHOLD FS_FAIL FS_FAILOVER_OBSERVER

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

1403587593 oradg11g                       YES YES                DISABLED                                                                  0

 

Elapsed time :  00: 00: 00.00

10:20:45 SQL>

10:20:45 SQL> ! ps -ef|grep dmon

oracle    7936  7895  0 10:21 pts/4    00:00:00 /bin/bash -c  ps -ef|grep dmon

oracle    7938  7936  0 10:21 pts/4    00:00:00 grep dmon

 

10:21:17 SQL> show parameter dg_broker

 

NAME                                 TYPE        VALUE

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

dg_broker_config_file1               string      /u01/app/oracle/product/11.2.0

                                                 /dbhome_1/dbs/dr1oradg11g.dat

dg_broker_config_file2               string      /u01/app/oracle/product/11.2.0

                                                 /dbhome_1/dbs/dr2oradg11g.dat

dg_broker_start                      boolean     FALSE

10:21:39 SQL> show parameter dg_broker_start

 

NAME                                 TYPE        VALUE

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

dg_broker_start                      boolean     FALSE

10:21:53 SQL> alter system set dg_broker_start=true scope=both;

 

The system has changed .

 

Elapsed time :  00: 00: 00.02

10:21:56 SQL> ! ps -ef|grep dmon

oracle    7975     1  0 10:21 ?        00:00:00 ora_dmon_oradg11g

oracle    7976  7895  0 10:22 pts/4    00:00:00 /bin/bash -c  ps -ef|grep dmon

oracle    7978  7976  0 10:22 pts/4    00:00:00 grep dmon

 

10:22:02 SQL>

10:22:02 SQL> show parameter dg_broker_start

 

NAME                                 TYPE        VALUE

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

dg_broker_start                      boolean     TRUE

10:23:48 SQL> set line 9999

10:23:58 SQL> col name format a10

10:23:58 SQL> col FS_FAILOVER_OBSERVER_HOST format a20

10:23:58 SQL> select dbid,name,current_scn,protection_mode,protection_level,database_role,force_logging,open_mode,switchover_status from v$database;

 

      DBID NAME       CURRENT_SCN PROTECTION_MODE      PROTECTION_LEVEL     DATABASE_ROLE    FOR OPEN_MODE            SWITCHOVER_STATUS

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

1403587593 ORADG11G       2337043 MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE  PRIMARY          YES READ WRITE           TO STANDBY

 

Elapsed time :  00: 00: 00.01

10:23:58 SQL> SELECT d.DBID,

10:23:58   2         d.DB_UNIQUE_NAME,

10:23:58   3         d.FORCE_LOGGING,

10:23:58   4         d.FLASHBACK_ON,

10:23:58   5         d.FS_FAILOVER_STATUS,

10:23:58   6         d.FS_FAILOVER_CURRENT_TARGET,

10:23:58   7         d.FS_FAILOVER_THRESHOLD,

10:23:58   8         d.FS_FAILOVER_OBSERVER_PRESENT,

10:23:58   9         d.FS_FAILOVER_OBSERVER_HOST

10:23:58  10    FROM v$database d;

 

      DBID DB_UNIQUE_NAME                 FOR FLASHBACK_ON       FS_FAILOVER_STATUS     FS_FAILOVER_CURRENT_TARGET     FS_FAILOVER_THRESHOLD FS_FAIL FS_FAILOVER_OBSERVER

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

1403587593 oradg11g                       YES YES                DISABLED                                                                  0

 

Elapsed time :  00: 00: 00.00

10:24:00 SQL>

 

Alarm log ：

Mon Sep 28 10:21:56 2015

ALTER SYSTEM SET dg_broker_start=TRUE SCOPE=BOTH;

Mon Sep 28 10:21:56 2015

DMON started with pid=37, OS id=7975

Starting Data Guard Broker (DMON)

Mon Sep 28 10:22:04 2015

INSV started with pid=38, OS id=7984

 

Standby database operation ：

 

[oracle@rhel6_lhr ~]$ sqlplus / as sysdba

 

SQL*Plus: Release 11.2.0.3.0 Production on Monday 9 month 28 10:25:25 2015

 

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

 

 

Connect to :

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

10:25:25 SQL> show parameter name

 

NAME                                 TYPE        VALUE

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

db_file_name_convert                 string      oradg11g, oradgphy

db_name                              string      oradg11g

db_unique_name                       string      oradgphy

global_names                         boolean     FALSE

instance_name                        string      oradgphy

lock_name_space                      string

log_file_name_convert                string      oradg11g, oradgphy

processor_group_name                 string

service_names                        string      oradgphy

10:25:27 SQL>  show parameter spfile

 

NAME                                 TYPE        VALUE

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

spfile                               string      /u01/app/oracle/product/11.2.0

                                                 /dbhome_1/dbs/spfileoradgphy.o

                                                 ra

10:25:35 SQL> show parameter DG_BROKER_CONFIG_FILE

 

NAME                                 TYPE        VALUE

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

dg_broker_config_file1               string      /u01/app/oracle/product/11.2.0

                                                 /dbhome_1/dbs/dr1oradgphy.dat

dg_broker_config_file2               string      /u01/app/oracle/product/11.2.0

                                                 /dbhome_1/dbs/dr2oradgphy.dat

10:25:43 SQL> set line 9999

10:25:51 SQL> col name format a10

10:25:51 SQL> col FS_FAILOVER_OBSERVER_HOST format a20

10:25:51 SQL> select dbid,name,current_scn,protection_mode,protection_level,database_role,force_logging,open_mode,switchover_status from v$database;

SELECT d.DBID,

       d.DB_UNIQUE_NAME,

       d.FORCE_LOGGING,

       d.FLASHBACK_ON,

       d.FS_FAILOVER_STATUS,

 

      DBID NAME       CURRENT_SCN PROTECTION_MODE      PROTECTION_LEVEL     DATABASE_ROLE    FOR OPEN_MODE            SWITCHOVER_STATUS

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

1403587593 ORADG11G       2337499 MAXIMUM PERFORMANCE  MAXIMUM PERFORMANCE  PHYSICAL STANDBY YES READ ONLY WITH APPLY NOT ALLOWED

 

Elapsed time :  00: 00: 00.11

10:25:52 SQL> 10:25:52   2  10:25:52   3  10:25:52   4  10:25:52   5  10:25:52   6         d.FS_FAILOVER_CURRENT_TARGET,

10:25:52   7         d.FS_FAILOVER_THRESHOLD,

10:25:52   8         d.FS_FAILOVER_OBSERVER_PRESENT,

10:25:52   9         d.FS_FAILOVER_OBSERVER_HOST

10:25:52  10    FROM v$database d;

 

      DBID DB_UNIQUE_NAME                 FOR FLASHBACK_ON       FS_FAILOVER_STATUS     FS_FAILOVER_CURRENT_TARGET     FS_FAILOVER_THRESHOLD FS_FAIL FS_FAILOVER_OBSERVER

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

1403587593 oradgphy                       YES NO                 DISABLED                                                                  0

 

Elapsed time :  00: 00: 00.00

10:25:56 SQL>  ! ps -ef|grep dmon

oracle    7975     1  0 10:21 ?        00:00:00 ora_dmon_oradg11g

oracle    8461  8410  0 10:26 pts/5    00:00:00 /bin/bash -c  ps -ef|grep dmon

oracle    8463  8461  0 10:26 pts/5    00:00:00 grep dmon

 

10:26:07 SQL>  show parameter dg_broker_start

 

NAME                                 TYPE        VALUE

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

dg_broker_start                      boolean     FALSE

10:26:39 SQL> alter system set dg_broker_start=true scope=both;

 

The system has changed .

 

Elapsed time :  00: 00: 00.05

10:26:46 SQL>  ! ps -ef|grep dmon

oracle    7975     1  0 10:21 ?        00:00:00 ora_dmon_oradg11g

oracle    8481     1  0 10:26 ?        00:00:00 ora_dmon_oradgphy

oracle    8501  8410  0 10:26 pts/5    00:00:00 /bin/bash -c  ps -ef|grep dmon

oracle    8503  8501  0 10:26 pts/5    00:00:00 grep dmon

 

10:26:50 SQL>

 

One .4.2.1   To configure db_domain  and   listener  And  tnsnames

The goal is ： To configure db_domain  and Static listener ,listener Medium GLOBAL_DBNAME by db_unique_name_DGMGRL.db_domain

 

Active / standby Library ：

14:05:05 SQL>  show parameter db_domain 

 

NAME                                 TYPE        VALUE

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

db_domain                            string

14:13:46 SQL> alter system set db_domain='lhr.com' scope=spfile;

 

 

 

Active / standby Library listener Configuration of , Note that the red ones are new additions ：

[oracle@rhel6_lhr admin]$ lsnrctl status

 

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 28-9 month -2015 15:05:27

 

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

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.59.130)(PORT=1521)))

LISTENER Of STATUS

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

Alias                       LISTENER

edition                       TNSLSNR for Linux: Version 11.2.0.3.0 - Production

Start date                   28-9 month -2015 14:32:08

Normal operation time               0 God 0 Hours 33 branch 18 second

Tracking level                   off

Security                     ON: Local OS Authentication

SNMP                      OFF

Listener parameter file           /u01/app/grid/11.2.0/network/admin/listener.ora

Listening endpoint profile ...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.59.130)(PORT=1521)))

Service summary ..

service "+ASM" contain 1 An example .

  example "+ASM", state READY, The 1 A handler ...

service "PLSExtProc" contain 1 An example .

  example "PLSExtProc", state UNKNOWN, The 1 A handler ...

service "ora11g" contain 1 An example .

  example "ora11g", state UNKNOWN, The 1 A handler ...

service "oradg11g" contain 1 An example .

  example "oradg11g", state UNKNOWN, The 1 A handler ...

service "oradg11g.lhr.com" contain 2 An example .

  example "oradg11g", state UNKNOWN, The 1 A handler ...

  example "oradg11g", state READY, The 1 A handler ...

service "oradg11gXDB.lhr.com" contain 2 An example .

  example "oradg11g", state READY, The 1 A handler ...

  example "oradgphy", state READY, The 1 A handler ...

service "oradg11g_DGB.lhr.com" contain 1 An example .

  example "oradg11g", state READY, The 1 A handler ...

service "oradg11g_DGMGRL.lhr.com" contain 1 An example .

  example "oradg11g", state UNKNOWN, The 1 A handler ...

service "oradglg" contain 1 An example .

  example "oradglg", state UNKNOWN, The 1 A handler ...

service "oradgphy" contain 1 An example .

  example "oradgphy", state UNKNOWN, The 1 A handler ...

service "oradgphy.lhr.com" contain 2 An example .

  example "oradgphy", state UNKNOWN, The 1 A handler ...

  example "oradgphy", state READY, The 1 A handler ...

service "oradgphy_DGB.lhr.com" contain 1 An example .

  example "oradgphy", state READY, The 1 A handler ...

service "oradgphy_DGMGRL.lhr.com" contain 1 An example .

  example "oradgphy", state UNKNOWN, The 1 A handler ...

service "oradgss" contain 1 An example .

  example "oradgss", state UNKNOWN, The 1 A handler ...

service "orclasm.lhr.com" contain 1 An example .

  example "orclasm", state UNKNOWN, The 1 A handler ...

Command executed successfully

[oracle@rhel6_lhr admin]$ more /u01/app/grid/11.2.0/network/admin/listener.ora

# listener.ora Network Configuration File: /u01/app/grid/11.2.0/network/admin/listener.ora

# Generated by Oracle configuration tools.

 

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME = orclasm.lhr.com)

      (SID_NAME = orclasm)

      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)

    )

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)

      (PROGRAM = extproc)

    )

  (SID_DESC =

    (GLOBAL_DBNAME = oradg11g)

    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)

    (SID_NAME= oradg11g)

  )

  (SID_DESC =

    (GLOBAL_DBNAME = oradgphy)

    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)

    (SID_NAME= oradgphy)

  )

  (SID_DESC =

    (GLOBAL_DBNAME = oradglg)

    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)

    (SID_NAME= oradglg)

  )

  (SID_DESC =

    (GLOBAL_DBNAME = oradgss)

    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)

    (SID_NAME= oradgss)

  )

  (SID_DESC =

    (GLOBAL_DBNAME = ora11g)

    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)

    (SID_NAME= ora11g)

  )

    (SID_DESC =

    (GLOBAL_DBNAME = oradg11g.lhr.com)

    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)

    (SID_NAME= oradg11g)

  )

  (SID_DESC =

    (GLOBAL_DBNAME = oradgphy.lhr.com)

    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)

    (SID_NAME= oradgphy)

  )

  (SID_DESC =

    (GLOBAL_DBNAME = oradg11g_DGMGRL.lhr.com)

    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)

    (SID_NAME= oradg11g)

  )

  (SID_DESC =

    (GLOBAL_DBNAME = oradgphy_DGMGRL.lhr.com)

    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)

    (SID_NAME= oradgphy)

  )

  )

 

LOGGING_LISTENER = OFF

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.130)(PORT = 1521))

    )

  )

 

ADR_BASE_LISTENER = /u01/app/grid

 

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

 

#TRACE_LEVEL_LISTENER = OFF

[oracle@rhel6_lhr admin]$

 

Active / standby Library tnsnames Configuration of , Note that the red ones are new additions ：

[oracle@rhel6_lhr admin]$ more tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

 

tns_oradg11g_DGMGRL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.130)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = oradg11g_DGMGRL.lhr.com)

    )

  )

tns_oradgphy_DGMGRL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.130)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = oradgphy_DGMGRL.lhr.com)

    )

  )

 

tns_oradg11g =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.130)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = oradg11g)

    )

  )

tns_oradgphy =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.130)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = oradgphy)

    )

  )

tns_oradglg =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.59.130)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = oradglg)

    )

  )

 

 

One .4.3  dgmgrl Middle configuration broker And enable the


[oracle@rhel6_lhr ~]$ dgmgrl

DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production

 

Copyright (c) 2000, 2009, Oracle. All rights reserved.

 

Welcome to use DGMGRL, For more information, type "help".

DGMGRL> help

 

You can use the following command :

 

add            Add an alternate database to the mediation configuration

connect        Connect to Oracle Database instance

convert        Converting a database from one type to another

create         Create mediation configuration

disable        Disable configuration , Database or quick start failover

edit           Edit the configuration , Database or instance

enable         Enable configuration , Database or quick start failover

exit           Exit procedure

failover       Change the standby database to the primary database

help           Displays the description and syntax of the command

quit           Exit procedure

reinstate      Change the database marked for recovery to a viable standby database

rem            DGMGRL Comments are ignored

remove         Delete the configuration , Database or instance

show           Display information about configuration , Database or instance information

shutdown       Close the currently running Oracle Database instance

sql            perform SQL sentence

start          Start the quick start failover observer

startup        start-up Oracle Database instance

stop           Stop the quick start of the failover observer

switchover     Switch roles between primary and standby databases

 

Use "help <command>" You can see the syntax of each command

 

DGMGRL> connect sys/lhr@tns_oradg11g_dgmgrl

Connected .

DGMGRL>

DGMGRL> show configuration

ORA-16532: Data Guard Mediation configuration does not exist

 

Configuration details cannot be created by DGMGRL determine

DGMGRL> help create 

 

Create mediation configuration

 

grammar :

 

  CREATE CONFIGURATION <configuration name> AS

    PRIMARY DATABASE IS <database name>

    CONNECT IDENTIFIER IS <connect identifier>;

 

DGMGRL> create configuration 'fsf_oradg11g_lhr' as

> primary database is 'oradg11g'

> connect identifier is tns_oradg11g_dgmgrl;

Configuration created "fsf_oradg11g_lhr", The main database is "oradg11g"

DGMGRL> show configuration

 

To configure - fsf_oradg11g_lhr

 

  Protected mode :        MaxPerformance

  database :

    oradg11g - Master database

 

Quick start of failover : DISABLED

 

Configuration status :

DISABLED

 

DGMGRL> add database 'oradgphy' as

> connect identifier is tns_oradgphy_dgmgrl

> maintained as physical;

Database added "oradgphy"

DGMGRL> show configuration

 

To configure - fsf_oradg11g_lhr

 

  Protected mode :        MaxPerformance

  database :

    oradg11g - Master database

    oradgphy - Physical backup database

 

Quick start of failover : DISABLED

 

Configuration status :

DISABLED

 

DGMGRL>

 

DGMGRL> enable configuration

Enabled .

DGMGRL> show configuration

 

To configure - fsf_oradg11g_lhr

 

  Protected mode :        MaxPerformance

  database :

    oradg11g - Master database

    oradgphy - Physical backup database

 

Quick start of failover : DISABLED

 

Configuration status :

SUCCESS

 

DGMGRL> 

 

DGMGRL>

DGMGRL> show database verbose oradg11g

 

database - oradg11g

 

  role :            PRIMARY

  Expected state :        TRANSPORT-ON

  example :

    oradg11g

 

  attribute :

    DGConnectIdentifier             = 'tns_oradg11g_dgmgrl'

    ObserverConnectIdentifier       = ''

    LogXptMode                      = 'ASYNC'

    DelayMins                       = '0'

    Binding                         = 'OPTIONAL'

    MaxFailure                      = '0'

    MaxConnections                  = '1'

    ReopenSecs                      = '300'

    NetTimeout                      = '30'

    RedoCompression                 = 'DISABLE'

    LogShipping                     = 'ON'

    PreferredApplyInstance          = ''

    ApplyInstanceTimeout            = '0'

    ApplyParallel                   = 'AUTO'

    StandbyFileManagement           = 'AUTO'

    ArchiveLagTarget                = '0'

    LogArchiveMaxProcesses          = '4'

    LogArchiveMinSucceedDest        = '1'

    DbFileNameConvert               = 'oradgphy, oradg11g'

    LogFileNameConvert              = 'oradgphy, oradg11g'

    FastStartFailoverTarget         = ''

    InconsistentProperties          = '(monitor)'

    InconsistentLogXptProps         = '(monitor)'

    SendQEntries                    = '(monitor)'

    LogXptStatus                    = '(monitor)'

    RecvQEntries                    = '(monitor)'

    SidName                         = 'oradg11g'

    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rhel6_lhr)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=oradg11g_DGMGRL.lhr.com)(INSTANCE_NAME=oradg11g)(SERVER=DEDICATED)))'

    StandbyArchiveLocation          = 'USE_DB_RECOVERY_FILE_DEST'

    AlternateLocation               = ''

    LogArchiveTrace                 = '0'

    LogArchiveFormat                = '%t_%s_%r.dbf'

    TopWaitEvents                   = '(monitor)'

 

Database state :

SUCCESS

 

DGMGRL>  show database verbose oradgphy

 

database - oradgphy

 

  role :            PHYSICAL STANDBY

  Expected state :        APPLY-ON

  Transmission lag :        0 second

  Application lag :        0 second

  Real-time query :        ON

  example :

    oradgphy

 

  attribute :

    DGConnectIdentifier             = 'tns_oradgphy_dgmgrl'

    ObserverConnectIdentifier       = ''

    LogXptMode                      = 'ASYNC'

    DelayMins                       = '0'

    Binding                         = 'optional'

    MaxFailure                      = '0'

    MaxConnections                  = '1'

    ReopenSecs                      = '300'

    NetTimeout                      = '30'

    RedoCompression                 = 'DISABLE'

    LogShipping                     = 'ON'

    PreferredApplyInstance          = ''

    ApplyInstanceTimeout            = '0'

    ApplyParallel                   = 'AUTO'

    StandbyFileManagement           = 'AUTO'

    ArchiveLagTarget                = '0'

    LogArchiveMaxProcesses          = '4'

    LogArchiveMinSucceedDest        = '1'

    DbFileNameConvert               = 'oradg11g, oradgphy'

    LogFileNameConvert              = 'oradg11g, oradgphy'

    FastStartFailoverTarget         = ''

    InconsistentProperties          = '(monitor)'

    InconsistentLogXptProps         = '(monitor)'

    SendQEntries                    = '(monitor)'

    LogXptStatus                    = '(monitor)'

    RecvQEntries                    = '(monitor)'

    SidName                         = 'oradgphy'

    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rhel6_lhr)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=oradgphy_DGMGRL.lhr.com)(INSTANCE_NAME=oradgphy)(SERVER=DEDICATED)))'

    StandbyArchiveLocation          = 'USE_DB_RECOVERY_FILE_DEST'

    AlternateLocation               = ''

    LogArchiveTrace                 = '0'

    LogArchiveFormat                = '%t_%s_%r.dbf'

    TopWaitEvents                   = '(monitor)'

 

Database state :

SUCCESS

 

DGMGRL>

DGMGRL>

 

 

Main library alarm log ：

 

Mon Sep 28 15:20:28 2015

NSV1 started with pid=30, OS id=25660

Mon Sep 28 15:20:54 2015

ALTER SYSTEM SET log_archive_config='dg_config=(oradg11g,oradgphy)' SCOPE=BOTH;

Mon Sep 28 15:20:57 2015

ALTER SYSTEM SET log_archive_dest_2='service="tns_oradgphy_dgmgrl"','LGWR ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name="oradgphy" net_timeout=30','valid_for=(all_logfiles,primary_role)' SCOPE=BOTH;

ALTER SYSTEM SET log_archive_trace=0 SCOPE=BOTH SID='oradg11g';

ALTER SYSTEM SET log_archive_format='%t_%s_%r.dbf' SCOPE=SPFILE SID='oradg11g';

ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH SID='*';

ALTER SYSTEM SET archive_lag_target=0 SCOPE=BOTH SID='*';

ALTER SYSTEM SET log_archive_max_processes=4 SCOPE=BOTH SID='*';

ALTER SYSTEM SET log_archive_min_succeed_dest=1 SCOPE=BOTH SID='*';

ALTER SYSTEM SET db_file_name_convert='oradgphy','oradg11g' SCOPE=SPFILE;

ALTER SYSTEM SET log_file_name_convert='oradgphy','oradg11g' SCOPE=SPFILE;

ALTER SYSTEM ARCHIVE LOG

Mon Sep 28 15:20:57 2015

NSA2 started with pid=34, OS id=25706

 

 

Standby alarm log ：

 

NSV0 started with pid=21, OS id=25696

Mon Sep 28 15:20:57 2015

ALTER SYSTEM SET log_archive_trace=0 SCOPE=BOTH SID='oradgphy';

ALTER SYSTEM SET log_archive_format='%t_%s_%r.dbf' SCOPE=SPFILE SID='oradgphy';

ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH SID='*';

ALTER SYSTEM SET archive_lag_target=0 SCOPE=BOTH SID='*';

ALTER SYSTEM SET log_archive_max_processes=4 SCOPE=BOTH SID='*';

ALTER SYSTEM SET log_archive_min_succeed_dest=1 SCOPE=BOTH SID='*';

ALTER SYSTEM SET db_file_name_convert='oradg11g','oradgphy' SCOPE=SPFILE;

ALTER SYSTEM SET log_file_name_convert='oradg11g','oradgphy' SCOPE=SPFILE;

ALTER SYSTEM SET fal_server='tns_oradg11g_dgmgrl' SCOPE=BOTH;

Mon Sep 28 15:21:01 2015

Primary database is in MAXIMUM PERFORMANCE mode

RFS[4]: Assigned to RFS process 25708

RFS[4]: Selected log 4 for thread 1 sequence 145 dbid 1403587593 branch 886695024

 

 

One .4.4   test Data Guard Broker  function

In the configuration broker After completion , We can use it broker complete switchover 了 . stay DGMGRL There's only one simple command needed in . 
switchover to standby-database 
(standby-database: This parameter is db_unique_name, Case sensitive . If the name is uppercase , You need quotation marks . Indicates switching standby-database For the host , The original host changes to the standby state ) 

 

 

DGMGRL> show configuration

 

To configure - fsf_oradg11g_lhr

 

  Protected mode :        MaxPerformance

  database :

    oradg11g - Master database

    oradgphy - Physical backup database

 

Quick start of failover : DISABLED

 

Configuration status :

SUCCESS

 

DGMGRL> switchover to oradgphy;

Switch now , Please wait a moment ...

New master database "oradgphy" Opening ...

The operation requires closing the instance "oradg11g" ( In the database "oradg11g" On )

Closing instance "oradg11g"...

ORACLE Routine closed .

The operation requires starting the instance "oradg11g" ( In the database "oradg11g" On )

Starting instance "oradg11g"...

ORACLE Routine started .

Database loading complete .

The database has been opened .

Switch successful , The new main database is "oradgphy"

DGMGRL> show configuration

 

To configure - fsf_oradg11g_lhr

 

  Protected mode :        MaxPerformance

  database :

    oradgphy - Master database

    oradg11g - Physical backup database

 

Quick start of failover : DISABLED

 

Configuration status :

SUCCESS

 

DGMGRL>

 

 

Switch again , Back to the original state ：

DGMGRL> switchover to oradg11g;

Switch now , Please wait a moment ...

New master database "oradg11g" Opening ...

The operation requires closing the instance "oradgphy" ( In the database "oradgphy" On )

Closing instance "oradgphy"...

ORACLE Routine closed .

The operation requires starting the instance "oradgphy" ( In the database "oradgphy" On )

Starting instance "oradgphy"...

ORACLE Routine started .

Database loading complete .

The database has been opened .

Switch successful , The new main database is "oradg11g"

DGMGRL> show configuration

 

To configure - fsf_oradg11g_lhr

 

  Protected mode :        MaxPerformance

  database :

    oradg11g - Master database

    oradgphy - Physical backup database

 

Quick start of failover : DISABLED

 

Configuration status :

SUCCESS

 

DGMGRL>

 

When switching for the first time, the alarm log status ：

Main library alarm log ：

 

 

 

Mon Sep 28 15:26:24 2015

ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN

ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY [Process Id: 23943] (oradg11g)

Mon Sep 28 15:26:24 2015

Thread 1 advanced to log sequence 146 (LGWR switch)

  Current log# 2 seq# 146 mem# 0: /u01/app/oracle/oradata/oradg11g/redo02.log

Mon Sep 28 15:26:24 2015

Stopping background process CJQ0

Stopping background process QMNC

Stopping Job queue slave processes, flags = 27

Mon Sep 28 15:26:27 2015

Archived Log entry 501 added for thread 1 sequence 145 ID 0x5495956b dest 1:

Waiting for Job queue slaves to complete

Job queue slave processes stopped

All dispatchers and shared servers shutdown

CLOSE: killing server sessions.

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

Active process 25846 user 'oracle' program 'oracle@rhel6_lhr (W000)'

CLOSE: all sessions shutdown successfully.

Waiting for all non-current ORLs to be archived...

All non-current ORLs have been archived.

Waiting for all FAL entries to be archived...

All FAL entries have been archived.

Waiting for dest_id 2 to become synchronized...

Active, synchronized Physical Standby switchover target has been identified

Switchover End-Of-Redo Log thread 1 sequence 146 has been fixed

Switchover: Primary highest seen SCN set to 0x0.0x262c94

ARCH: Noswitch archival of thread 1, sequence 146

ARCH: End-Of-Redo Branch archival of thread 1 sequence 146

ARCH: LGWR is actively archiving destination LOG_ARCHIVE_DEST_2

ARCH: Standby redo logfile selected for thread 1 sequence 146 for destination LOG_ARCHIVE_DEST_2

Archived Log entry 502 added for thread 1 sequence 146 ID 0x5495956b dest 1:

ARCH: Archiving is disabled due to current logfile archival

Primary will check for some target standby to have received alls redo

Final check for a synchronized target standby. Check will be made once.

Archive destination LOG_ARCHIVE_DEST_3 invalidated

DB_UNIQUE_NAME oradglg is not in the Data Guard configuration

Archive destination LOG_ARCHIVE_DEST_4 invalidated

DB_UNIQUE_NAME oradgss is not in the Data Guard configuration

LOG_ARCHIVE_DEST_2 is a potential Physical Standby switchover target

Active, synchronized target has been identified

Target has also received all redo

Backup controlfile written to trace file /u01/app/oracle/diag/rdbms/oradg11g/oradg11g/trace/oradg11g_rsm0_23943.trc

Clearing standby activation ID 1419089259 (0x5495956b)

The primary database controlfile was created using the

'MAXLOGFILES 16' clause.

There is space for up to 13 standby redo logfiles

Use the following SQL commands on the standby database to create

standby redo logfiles that match the primary database:

ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 52428800;

ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 52428800;

ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 52428800;

ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 52428800;

Archivelog for thread 1 sequence 146 required for standby recovery

Switchover: Primary controlfile converted to standby controlfile succesfully.

Switchover: Complete - Database shutdown required

Completed: ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN

Mon Sep 28 15:26:37 2015

Performing implicit shutdown abort due to switchover to physical standby

Shutting down instance (abort)

License high water mark = 8

USER (ospid: 26018): terminating the instance

Instance terminated by USER, pid = 26018

Mon Sep 28 15:26:38 2015

Instance shutdown complete

ORA-1092 : opitsk aborting process

Mon Sep 28 15:26:38 2015

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 3

Archive destination LOG_ARCHIVE_DEST_3 invalidated

DB_UNIQUE_NAME oradglg is not in the Data Guard configuration

Archive destination LOG_ARCHIVE_DEST_4 invalidated

DB_UNIQUE_NAME oradgss is not in the Data Guard configuration

Autotune of undo retention is turned on.

IMODE=BR

ILAT =27

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options.

ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1

System name:    Linux

Node name:      rhel6_lhr

Release:        2.6.32-504.16.2.el6.x86_64

Version:        #1 SMP Tue Apr 21 08:37:59 PDT 2015

Machine:        x86_64

VM name:        VMWare Version: 6

Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileoradg11g.ora

System parameters with non-default values:

  processes                = 150

  memory_target            = 300M

  memory_max_target        = 400M

  control_files            = "/u01/app/oracle/oradata/oradg11g/control01.ctl"

  control_files            = "/u01/app/oracle/flash_recovery_area/oradg11g/control02.ctl"

  db_file_name_convert     = "oradgphy"

  db_file_name_convert     = "oradg11g"

  log_file_name_convert    = "oradgphy"

  log_file_name_convert    = "oradg11g"

  db_block_size            = 8192

  compatible               = "11.2.0.0.0"

  log_archive_dest_1       = "LOCATION=USE_DB_RECOVERY_FILE_DEST db_unique_name=oradg11g valid_for=(ALL_LOGFILES,ALL_ROLES)"

  log_archive_dest_2       = "service="tns_oradgphy_dgmgrl""

  log_archive_dest_2       = "LGWR ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name="oradgphy" net_timeout=30"

  log_archive_dest_2       = "valid_for=(all_logfiles,primary_role)"

  log_archive_dest_3       = "SERVICE=tns_oradglg LGWR ASYNC db_unique_name=oradglg valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)"

  log_archive_dest_4       = "SERVICE=tns_oradgss LGWR ASYNC db_unique_name=oradgss valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE)"

  log_archive_dest_state_1 = "ENABLE"

  log_archive_dest_state_2 = "ENABLE"

  log_archive_dest_state_3 = "defer"

  log_archive_dest_state_4 = "defer"

  log_archive_min_succeed_dest= 1

  fal_client               = "oradg11g"

  fal_server               = "tns_oradgphy_dgmgrl"

  log_archive_trace        = 0

  log_archive_config       = "dg_config=(oradg11g,oradgphy)"

  log_archive_format       = "%t_%s_%r.dbf"

  log_archive_max_processes= 4

  archive_lag_target       = 0

  db_recovery_file_dest    = "/u01/app/oracle/flash_recovery_area"

  db_recovery_file_dest_size= 4122M

  standby_file_management  = "AUTO"

  undo_tablespace          = "UNDOTBS1"

  remote_login_passwordfile= "EXCLUSIVE"

  db_domain                = "lhr.com"

  global_names             = TRUE

  dispatchers              = "(PROTOCOL=TCP) (SERVICE=oradg11gXDB)"

  audit_file_dest          = "/u01/app/oracle/admin/oradg11g/adump"

  audit_trail              = "DB"

  db_name                  = "oradg11g"

  db_unique_name           = "oradg11g"

  open_cursors             = 300

  dg_broker_start          = TRUE

  diagnostic_dest          = "/u01/app/oracle"

Mon Sep 28 15:26:38 2015

PMON started with pid=2, OS id=26102

Mon Sep 28 15:26:38 2015

PSP0 started with pid=3, OS id=26104

Mon Sep 28 15:26:39 2015

Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

destination database instance is 'started' not 'mounted'

Mon Sep 28 15:26:39 2015

VKTM started with pid=4, OS id=26112 at elevated priority

VKTM running at (1)millisec precision with DBRM quantum (100)ms

Mon Sep 28 15:26:39 2015

GEN0 started with pid=5, OS id=26116

Mon Sep 28 15:26:39 2015

DIAG started with pid=6, OS id=26118

Mon Sep 28 15:26:40 2015

DBRM started with pid=7, OS id=26120

Mon Sep 28 15:26:40 2015

DIA0 started with pid=8, OS id=26122

Mon Sep 28 15:26:40 2015

MMAN started with pid=9, OS id=26124

Mon Sep 28 15:26:40 2015

DBW0 started with pid=10, OS id=26126

Mon Sep 28 15:26:40 2015

LGWR started with pid=11, OS id=26128

Mon Sep 28 15:26:40 2015

CKPT started with pid=12, OS id=26130

Mon Sep 28 15:26:40 2015

SMON started with pid=13, OS id=26132

Mon Sep 28 15:26:40 2015

RECO started with pid=14, OS id=26134

Mon Sep 28 15:26:40 2015

MMON started with pid=15, OS id=26136

Mon Sep 28 15:26:40 2015

MMNL started with pid=16, OS id=26138

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

starting up 1 shared server(s) ...

ORACLE_BASE from environment = /u01/app/grid

Mon Sep 28 15:26:40 2015

DMON started with pid=19, OS id=26145

Mon Sep 28 15:26:40 2015

alter database  mount

ARCH: STARTING ARCH PROCESSES

Mon Sep 28 15:26:44 2015

ARC0 started with pid=22, OS id=26157

ARC0: Archival started

ARCH: STARTING ARCH PROCESSES COMPLETE

ARC0: STARTING ARCH PROCESSES

Successful mount of redo thread 1, with mount id 1419115888

Allocated 3981120 bytes in shared pool for flashback generation buffer

Starting background process RVWR

Mon Sep 28 15:26:45 2015

ARC1 started with pid=23, OS id=26159

Mon Sep 28 15:26:45 2015

RVWR started with pid=24, OS id=26161

Mon Sep 28 15:26:45 2015

ARC2 started with pid=25, OS id=26163

Mon Sep 28 15:26:45 2015

ARC3 started with pid=26, OS id=26165

ARC1: Archival started

ARC2: Archival started

ARC1: Becoming the 'no FAL' ARCH

ARC1: Becoming the 'no SRL' ARCH

ARC2: Becoming the heartbeat ARCH

Physical Standby Database mounted.

Lost write protection disabled

ARC2: Becoming the active heartbeat ARCH

Completed: alter database  mount

alter database  open

Data Guard Broker initializing...

Data Guard Broker initialization complete

AUDIT_TRAIL initialization parameter is changed to OS, as DB is NOT compatible for database opened with read-only access

Beginning standby crash recovery.

Serial Media Recovery started

Managed Standby Recovery starting Real Time Apply

Media Recovery Log /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_09_28/o1_mf_1_145_c0ktx3cj_.arc

Media Recovery Log /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_09_28/o1_mf_1_146_c0ktx6mn_.arc

Identified End-Of-Redo (switchover) for thread 1 sequence 146 at SCN 0x0.262c94

Resetting standby activation ID 0 (0x0)

Incomplete Recovery applied until change 2501780 time 09/28/2015 15:26:30

Completed standby crash recovery.

SMON: enabling cache recovery

Mon Sep 28 15:26:46 2015

RFS[1]: Assigned to RFS process 26177

RFS[1]: Opened log for thread 1 sequence 148 dbid 1403587593 branch 886695024

Archived Log entry 504 added for thread 1 sequence 148 rlc 886695024 ID 0x54960fb7 dest 2:

Dictionary check beginning

Mon Sep 28 15:26:46 2015

RFS[2]: Assigned to RFS process 26179

RFS[2]: Opened log for thread 1 sequence 147 dbid 1403587593 branch 886695024

Archived Log entry 505 added for thread 1 sequence 147 rlc 886695024 ID 0x54960fb7 dest 2:

Dictionary check complete

Database Characterset is ZHS16GBK

No Resource Manager plan active

replication_dependency_tracking turned off (no async multimaster replication found)

Physical standby database opened for read only access.

RFS[2]: Selected log 4 for thread 1 sequence 149 dbid 1403587593 branch 886695024

Completed: alter database  open

Archived Log entry 506 added for thread 1 sequence 149 ID 0x54960fb7 dest 1:

Mon Sep 28 15:26:46 2015

db_recovery_file_dest_size of 4122 MB is 6.96% used. This is a

user-specified limit on the amount of space that will be used by this

database for recovery-related files, and does not reflect the amount of

space available in the underlying filesystem or ASM diskgroup.

Mon Sep 28 15:26:46 2015

Primary database is in MAXIMUM PERFORMANCE mode

RFS[3]: Assigned to RFS process 26185

RFS[3]: Selected log 4 for thread 1 sequence 150 dbid 1403587593 branch 886695024

ARC3: Archival started

ARC0: STARTING ARCH PROCESSES COMPLETE

Starting Data Guard Broker (DMON)

Mon Sep 28 15:26:48 2015

INSV started with pid=30, OS id=26191

Mon Sep 28 15:26:51 2015

NSV1 started with pid=31, OS id=26199

Mon Sep 28 15:26:55 2015

RSM0 started with pid=32, OS id=26208

ALTER SYSTEM SET log_archive_dest_state_1='ENABLE' SCOPE=BOTH;

ALTER SYSTEM SET log_archive_trace=0 SCOPE=BOTH SID='oradg11g';

ALTER SYSTEM SET log_archive_format='%t_%s_%r.dbf' SCOPE=SPFILE SID='oradg11g';

ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH SID='*';

ALTER SYSTEM SET archive_lag_target=0 SCOPE=BOTH SID='*';

ALTER SYSTEM SET log_archive_max_processes=4 SCOPE=BOTH SID='*';

ALTER SYSTEM SET log_archive_min_succeed_dest=1 SCOPE=BOTH SID='*';

ALTER SYSTEM SET db_file_name_convert='oradgphy','oradg11g' SCOPE=SPFILE;

ALTER SYSTEM SET log_file_name_convert='oradgphy','oradg11g' SCOPE=SPFILE;

ALTER SYSTEM SET fal_server='tns_oradgphy_dgmgrl' SCOPE=BOTH;

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE  THROUGH ALL SWITCHOVER DISCONNECT  USING CURRENT LOGFILE

Attempt to start background Managed Standby Recovery process (oradg11g)

Mon Sep 28 15:26:59 2015

MRP0 started with pid=33, OS id=26214

MRP0: Background Managed Standby Recovery process started (oradg11g)

started logmerger process

Mon Sep 28 15:27:04 2015

Managed Standby Recovery starting Real Time Apply

Parallel Media Recovery started with 2 slaves

Waiting for all non-current ORLs to be archived...

All non-current ORLs have been archived.

Clearing online redo logfile 1 /u01/app/oracle/oradata/oradg11g/redo01.log

Clearing online log 1 of thread 1 sequence number 150

Clearing online redo logfile 1 complete

Clearing online redo logfile 2 /u01/app/oracle/oradata/oradg11g/redo02.log

Clearing online log 2 of thread 1 sequence number 146

Mon Sep 28 15:27:05 2015

Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE  THROUGH ALL SWITCHOVER DISCONNECT  USING CURRENT LOGFILE

Clearing online redo logfile 2 complete

Clearing online redo logfile 3 /u01/app/oracle/oradata/oradg11g/redo03.log

Clearing online log 3 of thread 1 sequence number 149

Clearing online redo logfile 3 complete

Mon Sep 28 15:27:07 2015

RFS[3]: Selected log 5 for thread 1 sequence 151 dbid 1403587593 branch 886695024

Mon Sep 28 15:27:07 2015

Archived Log entry 507 added for thread 1 sequence 150 ID 0x54960fb7 dest 1:

Media Recovery Log /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_09_28/o1_mf_1_147_c0ktxp86_.arc

Media Recovery Log /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_09_28/o1_mf_1_148_c0ktxp70_.arc

Media Recovery Log /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_09_28/o1_mf_1_149_c0ktxpgt_.arc

Media Recovery Log /u01/app/oracle/flash_recovery_area/ORADG11G/archivelog/2015_09_28/o1_mf_1_150_c0ktycgh_.arc

Media Recovery Waiting for thread 1 sequence 151 (in transit)

Recovery of Online Redo Log: Thread 1 Group 5 Seq 151 Reading mem 0

  Mem# 0: /u01/app/oracle/oradata/oradg11g/standby_redo05.log

 

 

 

 

 

Standby alarm log ：

 

 

 

Mon Sep 28 15:26:24 2015

Archived Log entry 128 added for thread 1 sequence 145 ID 0x5495956b dest 1:

Mon Sep 28 15:26:24 2015

Media Recovery Waiting for thread 1 sequence 146

Mon Sep 28 15:26:30 2015

RFS[6]: Assigned to RFS process 25998

RFS[6]: Selected log 4 for thread 1 sequence 146 dbid 1403587593 branch 886695024

Mon Sep 28 15:26:30 2015

Archived Log entry 129 added for thread 1 sequence 146 ID 0x5495956b dest 1:

Mon Sep 28 15:26:30 2015

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL

MRP0: Background Media Recovery cancelled with status 16037

Errors in file /u01/app/oracle/diag/rdbms/oradgphy/oradgphy/trace/oradgphy_pr00_24252.trc:

ORA-16037: user requested cancel of managed recovery operation

Managed Standby Recovery not using Real Time Apply

Recovery interrupted!

Mon Sep 28 15:26:31 2015

MRP0: Background Media Recovery process shutdown (oradgphy)

Managed Standby Recovery Canceled (oradgphy)

Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL

Database not available for switchover

  End-Of-REDO archived log file has not been recovered

  Incomplete recovery SCN:0:2481770 archive SCN:0:2501780

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE THROUGH LAST SWITCHOVER NODELAY

Media Recovery Start: Managed Standby Recovery (oradgphy)

started logmerger process

Mon Sep 28 15:26:32 2015

Managed Standby Recovery not using Real Time Apply

Parallel Media Recovery started with 2 slaves

Media Recovery Log /u01/app/oracle/flash_recovery_area/ORADGPHY/archivelog/2015_09_28/o1_mf_1_146_c0ktx6n6_.arc

Identified End-Of-Redo (switchover) for thread 1 sequence 146 at SCN 0x0.262c94

Resetting standby activation ID 1419089259 (0x5495956b)

Media Recovery End-Of-Redo indicator encountered

Media Recovery Applied through change 2501780

Media Recovery Complete: End-Of-REDO (oradgphy)

Attempt to set limbo arscn 0:2501780 irscn 0:2501780

Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE THROUGH LAST SWITCHOVER NODELAY

ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WAIT WITH SESSION SHUTDOWN

ALTER DATABASE SWITCHOVER TO PRIMARY (oradgphy)

Maximum wait for role transition is 15 minutes.

krsv_proc_kill: Killing 2 processes (all RFS)

All dispatchers and shared servers shutdown

CLOSE: killing server sessions.

CLOSE: all sessions shutdown successfully.

Mon Sep 28 15:26:34 2015

SMON: disabling cache recovery

Backup controlfile written to trace file /u01/app/oracle/diag/rdbms/oradgphy/oradgphy/trace/oradgphy_rsm0_24244.trc

SwitchOver after complete recovery through change 2501780

Online log /u01/app/oracle/oradata/oradgphy/redo01.log: Thread 1 Group 1 was previously cleared

Online log /u01/app/oracle/oradata/oradgphy/redo02.log: Thread 1 Group 2 was previously cleared

Online log /u01/app/oracle/oradata/oradgphy/redo03.log: Thread 1 Group 3 was previously cleared

Standby became primary SCN: 2501778

AUDIT_TRAIL initialization parameter is changed back to its original value as specified in the parameter file.

Switchover: Complete - Database mounted as primary

Completed: ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WAIT WITH SESSION SHUTDOWN

Mon Sep 28 15:26:36 2015

idle dispatcher 'D000' terminated, pid = (17, 1)

ALTER DATABASE OPEN

Data Guard Broker initializing...

Mon Sep 28 15:26:37 2015

Assigning activation ID 1419120567 (0x54960fb7)

Mon Sep 28 15:26:37 2015

ARC3: Becoming the 'no SRL' ARCH

Thread 1 advanced to log sequence 148 (thread open)

ARC0: Becoming the 'no SRL' ARCH

Thread 1 opened at log sequence 148

  Current log# 2 seq# 148 mem# 0: /u01/app/oracle/oradata/oradgphy/redo02.log

Successful open of redo thread 1

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

SMON: enabling cache recovery

Archived Log entry 130 added for thread 1 sequence 147 ID 0x54960fb7 dest 1:

ARC3: Becoming the 'no SRL' ARCH

Mon Sep 28 15:26:37 2015

NSA2 started with pid=17, OS id=26022

Mon Sep 28 15:26:37 2015

 

 

***********************************************************************

 

Fatal NI connect error 12537, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.59.130)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oradg11g_DGMGRL.lhr.com)(CID=(PROGRAM=oracle)(HOST=rhel6_lhr)(USER=grid))))

 

  VERSION INFORMATION:

        TNS for Linux: Version 11.2.0.3.0 - Production

        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production

  Time: 28-SEP-2015 15:26:37

  Tracing not turned on.

  Tns error struct:

    ns main err code: 12537

   

 

 

***********************************************************************

 

Fatal NI connect error 12537, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.59.130)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oradg11g_DGMGRL.lhr.com)(CID=(PROGRAM=oracle)(HOST=rhel6_lhr)(USER=grid))))

 

  VERSION INFORMATION:

        TNS for Linux: Version 11.2.0.3.0 - Production

        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production

  Time: 28-SEP-2015 15:26:37

  Tracing not turned on.

  Tns error struct:

    ns main err code: 12537

   

[24244] Successfully onlined Undo Tablespace 2.

Undo initialization finished serial:0 start:21508174 end:21508224 diff:50 (0 seconds)

Dictionary check beginning

TNS-12537: TNS:connection closed

TNS-12537: TNS:connection closed

    ns secondary err code: 12560

    nt main err code: 507

        ns secondary err code: 12560

 

    nt main err code: 507

TNS-00507: Connection closed

        nt secondary err code: 0

 

    nt OS err code: 0

TNS-00507: Connection closed

    nt secondary err code: 0

    nt OS err code: 0

 

 

***********************************************************************

 

Fatal NI connect error 12537, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.59.130)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oradg11g_DGMGRL.lhr.com)(CID=(PROGRAM=oracle)(HOST=rhel6_lhr)(USER=grid))))

 

  VERSION INFORMATION:

        TNS for Linux: Version 11.2.0.3.0 - Production

        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production

  Time: 28-SEP-2015 15:26:37

  Tracing not turned on.

  Tns error struct:

    ns main err code: 12537

   

TNS-12537: TNS:connection closed

    ns secondary err code: 12560

    nt main err code: 507

   

TNS-00507: Connection closed

    nt secondary err code: 0

    nt OS err code: 0

Dictionary check complete

Verifying file header compatibility for 11g tablespace encryption..

Verifying 11g file header compatibility for tablespace encryption completed

SMON: enabling tx recovery

Database Characterset is ZHS16GBK

Starting background process SMCO

 

 

***********************************************************************

 

Fatal NI connect error 12537, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.59.130)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oradg11g_DGMGRL.lhr.com)(CID=(PROGRAM=oracle)(HOST=rhel6_lhr)(USER=grid))))

 

  VERSION INFORMATION:

        TNS for Linux: Version 11.2.0.3.0 - Production

        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production

  Time: 28-SEP-2015 15:26:37

  Tracing not turned on.

  Tns error struct:

    ns main err code: 12537

   

TNS-12537: TNS:connection closed

    ns secondary err code: 12560

    nt main err code: 507

   

TNS-00507: Connection closed

    nt secondary err code: 0

    nt OS err code: 0

 

 

***********************************************************************

 

Fatal NI connect error 12537, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.59.130)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oradg11g_DGMGRL.lhr.com)(CID=(PROGRAM=oracle)(HOST=rhel6_lhr)(USER=grid))))

 

  VERSION INFORMATION:

        TNS for Linux: Version 11.2.0.3.0 - Production

        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production

  Time: 28-SEP-2015 15:26:37

  Tracing not turned on.

  Tns error struct:

    ns main err code: 12537

   

TNS-12537: TNS:connection closed

    ns secondary err code: 12560

    nt main err code: 507

   

TNS-00507: Connection closed

    nt secondary err code: 0

    nt OS err code: 0

Error 12537 received logging on to the standby

FAL[server, ARC3]: Error 12537 creating remote archivelog file 'tns_oradg11g_dgmgrl'

FAL[server, ARC3]: FAL archive failed, see trace file.

ARCH: FAL archive failed. Archiver continuing

ORACLE Instance oradgphy - Archival Error. Archiver continuing.

Mon Sep 28 15:26:37 2015

SMCO started with pid=26, OS id=26033

 

 

***********************************************************************

 

Fatal NI connect error 12537, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.59.130)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oradg11g_DGMGRL.lhr.com)(CID=(PROGRAM=oracle)(HOST=rhel6_lhr)(USER=grid))))

 

  VERSION INFORMATION:

        TNS for Linux: Version 11.2.0.3.0 - Production

        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production

  Time: 28-SEP-2015 15:26:37

  Tracing not turned on.

  Tns error struct:

    ns main err code: 12537

   

TNS-12537: TNS:connection closed

    ns secondary err code: 12560

    nt main err code: 507

   

TNS-00507: Connection closed

    nt secondary err code: 0

    nt OS err code: 0

Error 12537 received logging on to the standby

PING[ARC2]: Heartbeat failed to connect to standby 'tns_oradg11g_dgmgrl'. Error is 12537.

No Resource Manager plan active

Starting background process QMNC

Mon Sep 28 15:26:37 2015

QMNC started with pid=27, OS id=26036

LOGSTDBY: Validating controlfile with logical metadata

LOGSTDBY: Validation complete

Completed: ALTER DATABASE OPEN

ALTER SYSTEM SET log_archive_trace=0 SCOPE=BOTH SID='oradgphy';

ALTER SYSTEM SET log_archive_format='%t_%s_%r.dbf' SCOPE=SPFILE SID='oradgphy';

Starting background process CJQ0

Mon Sep 28 15:26:37 2015

CJQ0 started with pid=32, OS id=26050

ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH SID='*';

ALTER SYSTEM SET archive_lag_target=0 SCOPE=BOTH SID='*';

ALTER SYSTEM SET log_archive_max_processes=4 SCOPE=BOTH SID='*';

ALTER SYSTEM SET log_archive_min_succeed_dest=1 SCOPE=BOTH SID='*';

ALTER SYSTEM SET db_file_name_convert='oradg11g','oradgphy' SCOPE=SPFILE;

ALTER SYSTEM SET log_file_name_convert='oradg11g','oradgphy' SCOPE=SPFILE;

ARC2: STARTING ARCH PROCESSES

ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH;

ALTER SYSTEM ARCHIVE LOG

Mon Sep 28 15:26:38 2015

ARC4 started with pid=28, OS id=26052

ARC4: Archival started

ARC2: STARTING ARCH PROCESSES COMPLETE

PING[ARC2]: Heartbeat failed to connect to standby 'tns_oradg11g_dgmgrl'. Error is 16058.

Thread 1 advanced to log sequence 149 (LGWR switch)

  Current log# 3 seq# 149 mem# 0: /u01/app/oracle/oradata/oradgphy/redo03.log

Archived Log entry 131 added for thread 1 sequence 148 ID 0x54960fb7 dest 1:

Mon Sep 28 15:26:41 2015

 

 

***********************************************************************

 

Fatal NI connect error 12514, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.59.130)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oradg11g_DGB.lhr.com)(INSTANCE_NAME=oradg11g)(CID=(PROGRAM=oracle)(HOST=rhel6_lhr)(USER=grid))))

 

  VERSION INFORMATION:

        TNS for Linux: Version 11.2.0.3.0 - Production

        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production

  Time: 28-SEP-2015 15:26:41

  Tracing not turned on.

  Tns error struct:

    ns main err code: 12564

   

TNS-12564: TNS:connection refused

    ns secondary err code: 0

    nt main err code: 0

    nt secondary err code: 0

    nt OS err code: 0

 

 

***********************************************************************

 

Fatal NI connect error 12514, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.59.130)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oradg11g_DGB.lhr.com)(INSTANCE_NAME=oradg11g)(CID=(PROGRAM=oracle)(HOST=rhel6_lhr)(USER=grid))))

 

  VERSION INFORMATION:

        TNS for Linux: Version 11.2.0.3.0 - Production

        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production

  Time: 28-SEP-2015 15:26:41

  Tracing not turned on.

  Tns error struct:

    ns main err code: 12564

   

TNS-12564: TNS:connection refused

    ns secondary err code: 0

    nt main err code: 0

    nt secondary err code: 0

    nt OS err code: 0

 

 

***********************************************************************

 

Fatal NI connect error 12514, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.59.130)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oradg11g_DGB.lhr.com)(INSTANCE_NAME=oradg11g)(CID=(PROGRAM=oracle)(HOST=rhel6_lhr)(USER=grid))))

 

  VERSION INFORMATION:

        TNS for Linux: Version 11.2.0.3.0 - Production

        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production

  Time: 28-SEP-2015 15:26:41

  Tracing not turned on.

  Tns error struct:

    ns main err code: 12564

   

TNS-12564: TNS:connection refused

    ns secondary err code: 0

    nt main err code: 0

    nt secondary err code: 0

    nt OS err code: 0

 

 

***********************************************************************

 

Fatal NI connect error 12514, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.59.130)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oradg11g_DGB.lhr.com)(CID=(PROGRAM=oracle)(HOST=rhel6_lhr)(USER=grid))))

 

  VERSION INFORMATION:

        TNS for Linux: Version 11.2.0.3.0 - Production

        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production

  Time: 28-SEP-2015 15:26:42

  Tracing not turned on.

  Tns error struct:

    ns main err code: 12564

   

TNS-12564: TNS:connection refused

    ns secondary err code: 0

    nt main err code: 0

    nt secondary err code: 0

    nt OS err code: 0

 

 

***********************************************************************

 

Fatal NI connect error 12514, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.59.130)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oradg11g_DGB.lhr.com)(CID=(PROGRAM=oracle)(HOST=rhel6_lhr)(USER=grid))))

 

  VERSION INFORMATION:

        TNS for Linux: Version 11.2.0.3.0 - Production

        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production

  Time: 28-SEP-2015 15:26:42

  Tracing not turned on.

  Tns error struct:

    ns main err code: 12564

   

TNS-12564: TNS:connection refused

    ns secondary err code: 0

    nt main err code: 0

    nt secondary err code: 0

    nt OS err code: 0

 

 

***********************************************************************

 

Fatal NI connect error 12514, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.59.130)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oradg11g_DGB.lhr.com)(CID=(PROGRAM=oracle)(HOST=rhel6_lhr)(USER=grid))))

 

  VERSION INFORMATION:

        TNS for Linux: Version 11.2.0.3.0 - Production

        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production

  Time: 28-SEP-2015 15:26:42

  Tracing not turned on.

  Tns error struct:

    ns main err code: 12564

   

TNS-12564: TNS:connection refused

    ns secondary err code: 0

    nt main err code: 0

    nt secondary err code: 0

    nt OS err code: 0

ARC3: Becoming the 'no SRL' ARCH

Mon Sep 28 15:26:44 2015

ARC0: Becoming the 'no SRL' ARCH

Shutting down archive processes

ARCH shutting down

ARC4: Archival stopped

Mon Sep 28 15:26:46 2015

ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=MEMORY SID='*';

ARC0: Becoming the 'no SRL' ARCH

ARC3: Becoming the 'no SRL' ARCH

Thread 1 advanced to log sequence 150 (LGWR switch)

  Current log# 1 seq# 150 mem# 0: /u01/app/oracle/oradata/oradgphy/redo01.log

ARC3: Becoming the 'no SRL' ARCH

Archived Log entry 134 added for thread 1 sequence 149 ID 0x54960fb7 dest 1:

ARC0: Becoming the 'no SRL' ARCH

ARC0: Standby redo logfile selected for thread 1 sequence 149 for destination LOG_ARCHIVE_DEST_2

******************************************************************

LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2

******************************************************************

LNS: Standby redo logfile selected for thread 1 sequence 150 for destination LOG_ARCHIVE_DEST_2

Mon Sep 28 15:27:05 2015

ALTER SYSTEM ARCHIVE LOG

Mon Sep 28 15:27:05 2015

Thread 1 cannot allocate new log, sequence 151

Checkpoint not complete

  Current log# 1 seq# 150 mem# 0: /u01/app/oracle/oradata/oradgphy/redo01.log

Mon Sep 28 15:27:07 2015

ARC3: Becoming the 'no SRL' ARCH

Thread 1 advanced to log sequence 151 (LGWR switch)

  Current log# 2 seq# 151 mem# 0: /u01/app/oracle/oradata/oradgphy/redo02.log

Archived Log entry 137 added for thread 1 sequence 150 ID 0x54960fb7 dest 1:

Mon Sep 28 15:27:07 2015

LNS: Standby redo logfile selected for thread 1 sequence 151 for destination LOG_ARCHIVE_DEST_2

 

 

 

 

 

thus ,Data Guard Broker End of configuration .

 

 

 

 

 

One .5   summary

 

This is the first section , Please check out the second section ： Fast-Start Failover  Configuration of