Chat now with support
Chat with Support

Foglight for Oracle (Cartridge) 5.9.2.1 - User Guide

Installing and Configuring Agents Using Foglight for Oracle
Viewing the Databases Dashboard Assigning Instances to Users Selecting an Instance to Monitor Foglight for Oracle Overview Dashboard Overview view Advisories view SQL Performance Investigator (SQL PI) Oracle Activity Drilldown Pluggable Databases Drilldown Storage Drilldown Reviewing Configuration Settings Reviewing the Alert Log Reviewing Monitored Data Guard Environments Reviewing ASM Instances Reviewing Exadata-related Information
Administering Foglight for Oracle Reporting Reference Glossary

Reviewing Monitored Data Guard Environments

Starting in version 5.7.5.50, Foglight for Oracle provides a detailed dashboard for monitoring Data Guard environments. The Data Guard environment information is presented only after Data Guard environments are configured. The Data Guard tab lists all Data Guard environments which have been configured.

To access the detailed dashboard for that Data Guard environment, click the name of that Data Guard environment under the Name column.

Figure 2. Accessing the Data Guard Dashboard

The Data Guard dashboard displays a Data Guard status, provides information about Primary and Standby databases, monitors progress and performance of log transfer and apply processes.

The Data Guard dashboard has three tabs:

•
Summary — For details, see Reviewing Summary Information
•
Performance — For details, see Reviewing Performance Information .
•
Log Shipping Status — For details, see Reviewing Log Shipping Status Information .

Reviewing Summary Information

The Summary tab displays information about all Primary and Standby databases that are configured for the Data Guard environment. It comprises the following sections:

•
General information about Data Guard environment — shows details about a Data Guard environment that includes its protection mode, fast-start failover status and if Data Guard Broker is enabled.
•
Primary Database table — shows details about Primary database that includes database mode, switchover status, and DG errors that were raised in the Primary database during the selected time frame.
•
Standby Databases table — shows a list of Standby databases and their details, which include statuses, DG errors that were raised in the Standby database, and a number of received and applied log gaps.
•
Gap Time Chart — provides a representation of the current received and applied gap time in seconds for each Standby database.
* 
IMPORTANT: Gap Time Chart is available for Standby databases that are monitored by users that have SYSDBA privileges.

Reviewing Performance Information

The Performance tab displays the following charts:

•
Primary Redo Generation Rate chart — provides a redo generation rate of the Primary database per hour.
•
Transport Rate bar chart — provides a transport rate for each Standby database per hour.
This chart can be displayed in two modes. You can switch the mode in the menu of Data Guard dashboard.
a
Displaying all monitored Standby databases of the specific Data Guard environment in the same chart.
b
Displaying only one selected Standby database in the chart.
•
Standby Apply Rate bar chart — provides an apply rate for each Standby database per hour.
This chart can be displayed in two modes. You can switch the mode in the menu of Data Guard dashboard.
a
Displaying all monitored Standby databases of the specific Data Guard environment in the same chart.
b
Displaying only one selected Standby database in the chart.
•
Estimated Failover chart — provides an estimated failover time in seconds for each Standby database.
* 
IMPORTANT: Estimated Failover chart is available for Standby databases that are monitored by users that have SYSDBA privileges.
This chart can be displayed in two modes. You can switch the mode in the menu of Data Guard dashboard.
a
Displaying all monitored Standby databases of the specific Data Guard environment in the same chart.
b
Displaying only one selected Standby database in the chart.

Reviewing Log Shipping Status Information

The log shipping status tab contains information about non received and non applied logs into Physical Standby databases of the configured Data Guard environment. It comprises the following sections:

•
Primary Database table — shows details about a current log in the Primary database.
•
Standby Databases table — shows a list of Physical Standby databases of specific Data Guard environment and details about current received and applied logs for each Physical Standby database.
•
Log Details table — shows a list of non received and non applied logs for a chosen Physical Standby database from the Standby Databases table above.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating