Skip to content

Data Guard in Cloud Control 12c (1/4) - Basic Administration

  • by
Data Guard in Cloud Control 12c (0/4) - An Overview

Go to database main page which lists all the databases that can be monitored and managed by Cloud Control.

Data Guard in Cloud Control 12c - Basic Administration - 01

Data Guard in Cloud Control 12c - Basic Administration - 01

There are three databases listed and all up in our case:

  • primdb.example.com: a primary cluster database which has two instances.
  • standb.example.com: a standby cluster database which has two instances.
  • smalldb: a very small database resides in the first node of two primary servers.

Click the primary cluster database link.

Data Guard in Cloud Control 12c - Basic Administration - 01

Data Guard in Cloud Control 12c - Basic Administration - 01

The page shows summarized information of the primary cluster database.

Data Guard in Cloud Control 12c - Basic Administration - 02

Data Guard in Cloud Control 12c - Basic Administration - 02

Let's find the entry of Data Guard Administration, then click.

Data Guard in Cloud Control 12c - Basic Administration - 03

Data Guard in Cloud Control 12c - Basic Administration - 03

Enter database credentials to proceed.

Data Guard in Cloud Control 12c - Basic Administration - 04

Data Guard in Cloud Control 12c - Basic Administration - 04

You can see Data Guard is basically healthy except an applying lag problem needs to be deal with.

Data Guard in Cloud Control 12c - Basic Administration - 05

Data Guard in Cloud Control 12c - Basic Administration - 05

Since I can't see any entry that can manage the broker configuration, so I decide to go back to DGMGRL to solve the problems.

DGMGRL> show database standb

Database - standb

  Role:            PHYSICAL STANDBY
  Intended State:  APPLY-ON
  Transport Lag:   0 seconds
  Apply Lag:       2 hours 10 minutes 49 seconds
  Real Time Query: ON
  Instance(s):
    standb1
    standb2 (apply instance)

Database Status:
SUCCESS

DGMGRL> enable database standb
Enabled.
DGMGRL> show database standb

Database - standb

  Role:            PHYSICAL STANDBY
  Intended State:  APPLY-ON
  Transport Lag:   0 seconds
  Apply Lag:       0 seconds
  Real Time Query: ON
  Instance(s):
    standb1
    standb2 (apply instance)

Database Status:
SUCCESS

Refresh the page to reload newest status. Now, it's back to normal.

Data Guard in Cloud Control 12c - Basic Administration - 06

Data Guard in Cloud Control 12c - Basic Administration - 06

Data Guard in Cloud Control 12c (2/4) - Monitor Performance and Verify Configuation

Leave a Reply

Your email address will not be published.