Skip to content
Home » Oracle Database » Data Guard in Cloud Control 12c (2/4) - Monitor Performance and Verify Configuation

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

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

Let's go to "Data Guard Performance" page to monitor Data Guard performance.

Cloud Control 12c
Cloud Control 12c

The page shows the status of overall, redo generation, transportation and apply. Let's scroll down to the bottom.

Cloud Control 12c
Cloud Control 12c

The chart of apply lag time shows there was a lag around 2:30 pm and a sharp drop after solving that.

Cloud Control 12c
Cloud Control 12c

Let's go to "Verify Data Guard Configuration" page.

Cloud Control 12c
Cloud Control 12c

I don't think this configuration is same as the broker configuration.

The verification is in proceed.

Cloud Control 12c
Cloud Control 12c

The result is some kinds of advisers, which recommends we should create standby redo logs to facilitate Data Guard.

Cloud Control 12c
Cloud Control 12c

But I do have standby redo logs in both primary and standby cluster databases. I don't need more standby redo logs.

[oracle@primary01 ~]$ sqlplus / as sysdba
...

SQL> select GROUP#, THREAD#, SEQUENCE#, BYTES from v$standby_log;

    GROUP#    THREAD#  SEQUENCE#      BYTES
---------- ---------- ---------- ----------
         5          1          0   52428800
         6          1          0   52428800
         7          2          0   52428800
         8          2          0   52428800
....

[oracle@standby01 ~]$ sqlplus / as sysdba
...


    GROUP#    THREAD#  SEQUENCE#      BYTES
---------- ---------- ---------- ----------
         5          1          0   52428800
         6          1        110   52428800
         7          2        109   52428800
         8          2          0   52428800

However, I accept the recommendation and click "OK" button below to create standby redo logs.

Cloud Control 12c
Cloud Control 12c

Now, I got two more standby redo logs in standby cluster database.

SQL> /

    GROUP#    THREAD#  SEQUENCE#      BYTES
---------- ---------- ---------- ----------
         5          1        116   52428800
         6          1          0   52428800
         7          2          0   52428800
         8          2        115   52428800
         9          2          0   52428800
        10          1          0   52428800

6 rows selected.

Why would the function of "Verify Data Guard Configuration" make such confusing recommendation? Is it a bug or something?

Data Guard in Cloud Control 12c (3/4) - Switchover to Standby Database.

Leave a Reply

Your email address will not be published. Required fields are marked *