Shulou(Shulou.com)06/01 Report--

Configuration method

1. Both master and slave add DG broker configuration to static monitoring.

The main library is

(SID_DESC=

(GLOBAL_DBNAME=PROD_DGMGRL)

(ORACLE_HOME=/db/oracle/product/11.2.0/db_1/)

(SID_NAME=PROD)

)

The reserve library is

(SID_DESC=

(GLOBAL_DBNAME=PROD_STD_DGMGRL)

(ORACLE_HOME=/mnt/sdb1/u01/app/oracle/product/11.2.0.4/db)

(SID_NAME=PROD_STD)

)

2. Set parameters for both master and standby

SQL > alter system set dg_broker_start=true

Usage

Both master and standby can be executed.

Dgmgrl

DGMGRL > connect sys/123456

DGMGRL > connect sys/123456@tnsname

DGMGRL > help

DGMGRL > help show

Displays information about a configuration, database, or instance

Syntax:

SHOW CONFIGURATION [VERBOSE]

SHOW DATABASE [VERBOSE] []

SHOW INSTANCE [VERBOSE] []

[ON DATABASE]

SHOW FAST_START FAILOVER

DGMGRL > help create

Creates a broker configuration

Syntax:

CREATE CONFIGURATION AS

PRIMARY DATABASE IS

CONNECT IDENTIFIER IS

DGMGRL > help add

Adds a standby database to the broker configuration

Syntax:

ADD DATABASE

[AS CONNECT IDENTIFIER IS]

[MAINTAINED AS {PHYSICAL | LOGICAL}]

DGMGRL > help switchover

Switches roles between a primary and standby database

Syntax:

SWITCHOVER TO

The above database name actually represents tnsname for db_unique_name,connect identifier

DGMGRL > SHOW CONFIGURATION

ORA-16532: Data Guard broker configuration does not exist

Configuration details cannot be determined by DGMGRL

DGMGRL > CREATE CONFIGURATION DG1 AS PRIMARY DATABASE IS PROD2 CONNECT IDENTIFIER IS PROD2

Configuration "dg1" created with primary database "prod2"

DGMGRL > ADD DATABASE PROD2_STD AS CONNECT IDENTIFIER IS PROD2_STD MAINTAINED AS PHYSICAL

Database "prod2_std" added

DGMGRL > SHOW CONFIGURATION

Configuration-dg1

Protection Mode: MaxPerformance

Databases:

Prod2-Primary database

Prod2_std-Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

DISABLED

DGMGRL > enable CONFIGURATION

Enabled.

Once enable configuration, then the log_archive_dest_2 of the main library is worth it

DGMGRL > show CONFIGURATION VERBOSE

Configuration-dg1

Protection Mode: MaxPerformance

Databases:

Prod2-Primary database

Prod2_std-Physical standby database

Properties:

FastStartFailoverThreshold = '30'

OperationTimeout = '30'

FastStartFailoverLagLimit = '30'

CommunicationTimeout = '180'

ObserverReconnect ='0'

FastStartFailoverAutoReinstate = 'TRUE'

FastStartFailoverPmyShutdown = 'TRUE'

BystandersFollowRoleChange = 'ALL'

ObserverOverride = 'FALSE'

ExternalDestination1 =''

ExternalDestination2 =''

PrimaryLostWriteAction = 'CONTINUE'

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.