Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to build DG Broker, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

DG Broker building

1. Environment description

Databasesiddb_namedb_unique_namenet service nameprimaryoggoggoggogg_pphysical standbydoggoggdoggdogg_s

two。 View parameters

-main library

SYS@ogg > show parameter broker

NAME TYPE VALUE

-

Dg_broker_config_file1 string / u01/app/oracle/product/11.2.0 / dbhome_1/dbs/dr1ogg.dat

Dg_broker_config_file2 string / u01/app/oracle/product/11.2.0 / dbhome_1/dbs/dr2ogg.dat

Dg_broker_start boolean FALSE

-prepare the library

SYS@dogg > show parameter broker

NAME TYPE VALUE

-

Dg_broker_config_file1 string / u01/app/oracle/product/11.2.0 / db_1/dbs/dr1dogg.dat

Dg_broker_config_file2 string / u01/app/oracle/product/11.2.0/db_1/dbs/dr2dogg.dat

Dg_broker_start boolean FALSE

-modify dg_broker_config_file parameters. The default path is used here, or you can specify it yourself. If you are in a RAC environment, this puts the file on the shared storage, and if there is an ASM, you can put it in the ASM.

3. Enable BROKER

-execute on both databases:

Alter system set dg_broker_start=true scope=both

4. Login configuration

-it is OK to do the following in any one of them, and it is also possible to install the client with client.

[oracle@ogg-80 ~] $dgmgrl

(1) Connect to the current master database

DGMGRL > connect sys/oracle@ogg_p

DGMGRL > help create-View help

Creates a broker configuration

Syntax:

CREATE CONFIGURATION AS

PRIMARY DATABASE IS

CONNECT IDENTIFIER IS

(2) create a configuration file (ogg is the name of the configuration db_unique_name,oggDG-can be modified, and ogg_p is the tnsname that connects to the prod database)

Create configuration oggDG as primary database is ogg connect identifier is ogg_p

(3) enable configuration files

DGMGRL > enable configuration

(4) add slave database to configuration file (dogg is slave db_unique_name,dogg_s is tnsname connected to sprod database)

DGMGRL > add database dogg as connect identifier is dogg_s

(5) enable backup database

DGMGRL > enable database dogg

(6) View the configuration file

DGMGRL > show configuration

Configuration-oggdg

Protection Mode: MaxPerformance

Databases:

Ogg-Primary database

Dogg-Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

(7) View the configuration messages of the main database

DGMGRL > show database verbose ogg

Database-ogg

Role: PRIMARY

Intended State: TRANSPORT-ON

Instance (s):

Ogg

Properties:

DGConnectIdentifier = 'ogg_p'

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 ='/ u01Accord oradata, / u01scarp, oracle, oradata, oradata,

LogFileNameConvert ='/ u01Accord oradata, / u01scarp, oracle, oradata, oradata,

FastStartFailoverTarget =''

InconsistentProperties ='(monitor)'

InconsistentLogXptProps ='(monitor)'

SendQEntries ='(monitor)'

LogXptStatus ='(monitor)'

RecvQEntries ='(monitor)'

ApplyLagThreshold ='0'

TransportLagThreshold ='0'

TransportDisconnectedThreshold = '30'

SidName = 'ogg'

StaticConnectIdentifier ='(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=ogg-80) (PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=ogg_DGMGRL) (INSTANCE_NAME=ogg) (SERVER=DEDICATED)'

StandbyArchiveLocation ='/ u01According to an oracle.archive.'

AlternateLocation =''

LogArchiveTrace ='0'

LogArchiveFormat ='% tweets% slots% r.dbf'

TopWaitEvents ='(monitor)'

Database Status:

SUCCESS

(8) View the configuration messages of the slave database.

DGMGRL > show database verbose dogg

Database-dogg

Role: PHYSICAL STANDBY

Intended State: APPLY-ON

Transport Lag: 0 seconds (computed 0 seconds ago)

Apply Lag: 0 seconds (computed 0 seconds ago)

Apply Rate: 0 Byte/s

Real Time Query: ON

Instance (s):

Dogg

Properties:

DGConnectIdentifier = 'dogg_s'

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 ='/ u01Accord oradata, / u01scarlet, oradata, oradata,

LogFileNameConvert ='/ u01Accord oradata, / u01scarlet, oradata, oradata,

FastStartFailoverTarget =''

InconsistentProperties ='(monitor)'

InconsistentLogXptProps ='(monitor)'

SendQEntries ='(monitor)'

LogXptStatus ='(monitor)'

RecvQEntries ='(monitor)'

ApplyLagThreshold ='0'

TransportLagThreshold ='0'

TransportDisconnectedThreshold = '30'

SidName = 'dogg'

StaticConnectIdentifier ='(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=d-ogg) (PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=dogg_DGMGRL) (INSTANCE_NAME=dogg) (SERVER=DEDICATED)'

StandbyArchiveLocation ='/ u01According to an oracle.archive.'

AlternateLocation =''

LogArchiveTrace ='0'

LogArchiveFormat ='% tweets% slots% r.dbf'

TopWaitEvents ='(monitor)'

Database Status:

SUCCESS

(9) modify the StaticConnectIdentifier parameters, remember to modify both databases.

DGMGRL > edit database ogg set property StaticConnectIdentifier=' (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=192.168.1.80) (PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=ogg) (SERVER=DEDICATED))'

DGMGRL > edit database dogg set property StaticConnectIdentifier=' (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=192.168.1.90) (PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=dogg) (SERVER=DEDICATED))'

(10) start switching

DGMGRL > switchover to dogg

Performing switchover NOW, please wait...

Operation requires a connection to instance "dogg" on database "dogg"

Connecting to instance "dogg"...

Connected.

New primary database "dogg" is opening...

Operation requires startup of instance "ogg" on database "ogg"

Starting instance "ogg"...

ORACLE instance started.

Database mounted.

Database opened.

Switchover succeeded, new primary is "dogg"

(11) View status

DGMGRL > show configuration

Configuration-oggdg

Protection Mode: MaxPerformance

Databases:

Dogg-Primary database

Ogg-Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

(12) switch back again

DGMGRL > switchover to ogg

Thank you for reading this article carefully. I hope the article "how to build DG Broker" shared by the editor will be helpful to everyone. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.