Creating DG Broker Config
Creating a DG Broker Configuration
This tutorial shows you how to use DGMGRL
to create a Data Guard Broker configuration. You will learn how to:
- Add the Broker required listener entries
- Create <db_unique_name>_DGMGRL
services entry
- Create the Broker configuration using DGMGRL.
- Verify the configuration
- Examine the parameters
- Ensure the configuration is in Maximum Performance
NOTE: In this OBE, you configure the network
for a single server environment. If you are configuring an environment on two
different servers, you would need to configure Net Manager on both servers accordingly.
Approximately 1 hour
This tutorial covers the following topics:
Place
the cursor over this icon to load and view all
the screenshots for this tutorial. (Caution: This action loads all
screenshots simultaneously, so response time may be slow depending on your Internet
connection.)
Note: Alternatively, you can place the cursor over
an individual icon in the following steps to load and view only the screenshot
associated with that step. You can hide an individual screenshot by clicking
it.
The Data Guard command-line interface (DGMGRL)
enables you to control and monitor a Data Guard configuration from the DGMGRL
prompt or within scripts. You can perform most of the activities required to
manage and monitor the databases in the configuration using DGMGRL.
Back to Topic List
Before you perform this tutorial, you should:
| 1. |
Perform an Oracle Database 11g installation (software
and db installed) for a single server environment OR Oracle Database
11g installation (software and db installed) on 1 server and Oracle
Database 11g software only on 2nd server for a dual server environment. |
| 2. |
Creating a Physical Standby Database OBE |
Back to Topic List
In this task, you set the DG_BROKER_START
initialization parameter to TRUE
for your primary database and physical standby database.
| 1. |
Connect to your primary database and
check the value of DG_BROKER_START
|
| 2. |
On the primary database, set the DG_BROKER_START parameter to TRUE.
|
| 3. |
Now connect to your physical standby
database and check the value of DG_BROKER_START.
|
| 4. |
Set the value of DG_BROKER_START
to TRUE on your standby database.
|
Back to Topic List
In this task you define a service for the listener that includes
the db_unique_name_DGMGRL.db_domain
values for the GLOBAL_DBNAME.
Back to Topic List
| 1. |
Launch Oracle Net Manager.
[oracle@edtdr9p1]$ netmgr
|
| 2. |
Expand Local |
| 3. |
Expand Listeners
|
| 4. |
Select LISTENER.
|
| 5. |
Select Database Services in the drop-down list, and click Add
Database
|
| 6. |
Enter orclsby1_DGMGRL.us.oracle.com
in the Global Database Name field. Accept the default value for the
Oracle Home Directory. Enter orclsby1
in the SID field.
|
| 7. |
Select File -> Save Network Configuration. |
| 8. |
Select File -> Exit. |
| 9. |
Your $ORACLE_HOME/network/admin/listener.ora
file should contain entries as follows:
NOTE: The value for the GLOBAL_DBNAME should be a concatenation of the initialization
parameters <db_unique_name>_DGMGRL.<db_domain>.
|
| 10. |
Reload the listener.
|
Back to Topic
In this task you create a Data Guard Broker configuration.
| 1. |
Invoke DGMGRL and connect to your primary
database.
|
| 2. |
Create the broker configuration including
a profile for the primary database.
|
| 3. |
Display information about the configuration.
|
| 4. |
Use the following commands to add your physical
standby database to the broker configuration.
|
| 5. |
Use the SHOW
CONFIGURATION command to verify that the orclsby1
database was added to the configuration.
|
Back to Topic
With the Data Guard environment set successfully for your
primary and standby databases. you can now enable the broker configuration.
| 1. |
Enable the entire configuration. This may
take some time to complete.
|
| 2. |
Verify that the configuration was successfully
enabled.
|
Back to Topic
In this tutorial, you learned how to:
Back to Topic List
Place the cursor over this icon to hide all screenshots.
| 
Bookmark