Create Broker Configuration

Information:

Primary Database Unique Name: ipxtest

Standby Database Unique Name: teston

Connection identifier for primary database in tnsnames.ora file is: ipxtest

Connection identifier for Standby database in tnsnames.ora file is: teston


Primary database:

[oracle@primary_Server ~]$ dgmgrl

DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production

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

Welcome to DGMGRL, type "help" for information.

DGMGRL> connect sys

Password:

Connected.

DGMGRL> create configuration 'DGConfig1' as primary database is 'ipxtest'

> connect identifier is ipxtest;

Configuration "DGConfig1" created with primary database "ipxtest"

DGMGRL> add database 'teston' as connect identifier is teston;

Database "teston" added

DGMGRL> enable configuration

Enabled.

DGMGRL> show configuration

 

Configuration - DGConfig1

 

  Protection Mode: MaxPerformance

  Databases:

    ipxtest - Primary database

    teston  - Physical standby database

 

Fast-Start Failover: DISABLED

 

Configuration Status:

SUCCESS

 

Check in Standby:

[oracle@Standby_server ~]$ dgmgrl

DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production

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

Welcome to DGMGRL, type "help" for information.

DGMGRL> connect sys

Password:

Connected.

DGMGRL> show configuration;

Configuration - DGConfig1

  Protection Mode: MaxPerformance

  Databases:

    ipxtest - Primary database

    teston  - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

Comments