3
Copyright © 2006, Oracle. All rights reserved.
Using Data Guard Broker
and Enterprise Manager
Copyright © 2006, Oracle. All rights reserved.
3 - 2
Objectives
After completing this lesson, you should be able to do the
following:
•
Describe the Data Guard broker architecture
•
Describe the Data Guard broker components
•
Explain the benefits of the Data Guard broker
•
Explain Data Guard broker configurations
•
Use Enterprise Manager to manage your Data Guard
configuration
•
Invoke DGMGRL to manage your Data Guard
configuration
Copyright © 2006, Oracle. All rights reserved.
3 - 3
Features of Data Guard Broker
•
The Data Guard broker is a distributed management
framework.
•
The broker automates and centralizes the creation,

Chicago
Primary
site
Boston
Standby
site
Oracle Net
Copyright © 2006, Oracle. All rights reserved.
3 - 6
Data Guard Broker: Management Model
Data Guard Broker Configuration
Primary database
Broker-controlled
databases
Standby database
Standby database
Standby database
Standby database
Standby database
Standby database
Standby database
Standby database
Standby database
Instances
Instances
Copyright © 2006, Oracle. All rights reserved.
3 - 7
Primary site
Standby site 9
Standby site 2

Standby
database
Copyright © 2006, Oracle. All rights reserved.
3 - 8
Life Cycle of a Broker Configuration
Create
configuration
Enable
configuration
Make state or
role changes
Update database
properties
Monitor and tune
configuration
Copyright © 2006, Oracle. All rights reserved.
3 - 9
Data Guard Broker: Requirements
•
Enterprise Edition of Oracle Database 10g
•
Single-instance or multi-instance environment
•
COMPATIBLE must be set to 9.2.0.1.0 or higher for
primary and standby databases.
•
Oracle Net network files must be configured for
databases that you add to the configuration.
•
LOCAL_LISTENER on each instance must resolve to an