11 Accessing Recovery Appliance Reports

This chapter explains how to access the pre-created Oracle Business Intelligence (BI) Publisher reports in Oracle Enterprise Manager Cloud Control (Cloud Control). To learn how to access the Backup Reports page for a protected database in Cloud Control, see Zero Data Loss Recovery Appliance Protected Database Configuration Guide.

This chapter contains the following topics:

About Recovery Appliance Reports

This section contains the following topics:

See Also:

"Protection Policies" for an architectural overview

Purpose of Recovery Appliance Reports

A principal task for a Recovery Appliance administrator is storage capacity planning. Through BI Publisher, Recovery Appliance provides pre-created BI Publisher reports that enable you to meet the following goals:

  • Ensure that the Recovery Appliance has sufficient storage space for its needs

    By using the capacity reports, you can plan for additional storage, reduce the number of new protected databases added to the Recovery Appliance, or adjust protection policies so that the aggregate recovery window space decreases.

  • Ensure that the network is not overloaded

    The capacity reports also indicate whether the Recovery Appliance has maximized network capacity. In some cases, you can reduce network load by redistributing network traffic more evenly throughout the day. If network traffic is not distributed, and if network peaks are close to maximizing network bandwidth, then you may need to adjust the backup window times of some protected databases.

  • Provide a good view of system performance and activity for service requests

  • Obtain a brief or highly detailed status report for any protected database, which can sometimes be useful for troubleshooting databases that are not meeting recovery window goals

Overview of Recovery Appliance Reports

BI Publisher is an enterprise reporting solution for authoring, managing, and delivering reports and other documents.

Pre-Created BI Publisher Reports

Recovery Appliance provides the following pre-created BI Publisher reports:

  • Capacity Planning Summary

    This report provides an overview of storage for the Recovery Appliance so you can forecast when it will run out of capacity. Of special usefulness is the summary table, which provides a quick view of the number of days until capacity is exceeded. The network capacity planning summary provides a view of the aggregated network traffic over various time periods. This view shows both average and maximum rates, which are based on network samples.

  • Capacity Planning Details

    This report provides a finer granularity of information about capacity planning. It provides information on storage capacity, network throughput, CPU utilization for each protected database host, and disk and flash storage I/O throughput over time. Unlike the capacity planning summary, the detailed report also has memory and IOPS summary information, and detailed daily data.

  • Recovery Window Summary

    This report lists protected databases that are not meeting their recovery window goal or are exceeding their unprotected window threshold (see unprotected_window in "CREATE_PROTECTION_POLICY"). You can use this report as a quick view of recovery window and unprotected data window issues for a Recovery Appliance, and then follow up on individual protected databases using the Protected Database Details report.

  • Protected Database Details

    This report contains extensive status information about a protected database, including summaries of the following:

  • Top 10 Protected Databases by Data Transfer

    This report ranks the top 10 protected databases according to the amount of backup data transferred to or from the Recovery Appliance. The report aggregates data by hour or by day. Specifically, the report measures the following amounts:

    • Backup data sent to the Recovery Appliance

    • Replication data sent by the Recovery Appliance

    • Copy-to-tape data sent by the Recovery Appliance

    This report does not correlate directly to how much space is being used by backups of the ranked databases.

The preceding reports are only accessible through BI publisher. Also, the BI Publisher software included with Cloud Control can only access data in the Enterprise Manager Repository, not data in the Recovery Appliance schema.

Note:

Although performance data is accessible through SQL queries of V$ and recovery catalog views, Oracle highly recommends that you use the BI Publisher reports instead. Recovery Appliance has finite CPU and other resources, so if users run frequent or expensive SQL queries, then overall Recovery Appliance performance can suffer.

See Also:

BI Publisher Report Scheduling

Oracle recommends that you configure BI Publisher to generate reports automatically on a regular schedule (for example, every week), and to send the reports by email to the backup management team. You can also generate reports as needed using the techniques described in this chapter.

See Also:

Oracle Fusion Middleware User's Guide for Oracle Business Intelligence Publisher to learn how to schedule reports using BI Publisher

Accessing the Recovery Appliance Reports Page in Cloud Control

This section explains how to access the Recovery Appliance Reports page, which links to all pre-created BI Publisher reports.

To access the Recovery Appliance Reports page:

  1. Access the Recovery Appliance Home page, as described in "Accessing the Recovery Appliance Home Page".

  2. From the Enterprise menu, select Reports, and then BI Publisher Enterprise Reports.

    The BI Publisher Enterprise Reports page appears.

  3. Expand the Enterprise Manager Cloud Control folder, and then expand the Recovery Appliance Reports subfolder.

    Links to the pre-created reports are shown.

See Also:

Cloud Control online help to learn how to view reports in BI Publisher

Basic Tasks for Accessing Recovery Appliance Reports

This section explains the basic tasks involved in managing reports. Figure 11-1 shows the overall workflow described in Recovery Appliance Workflow, with the reporting tasks highlighted.

Figure 11-1 Reporting Tasks in the Recovery Appliance Workflow

Description of Figure 11-1 follows
Description of "Figure 11-1 Reporting Tasks in the Recovery Appliance Workflow"

Typically, you perform reporting tasks in the following sequence:

  1. During the planning phase, familiarize yourself with the monitoring and reporting tools available through Cloud Control.

    "Planning for Recovery Appliance" describes these tasks.

  2. During the ongoing maintenance phase (see "Maintenance Tasks for Recovery Appliance"), review the reports as needed. Typical tasks include:

Accessing the Storage Capacity Reports

This tutorial explains how to view the storage capacity reports for a Recovery Appliance.

Assumptions

Assume that the following statements are true of your Recovery Appliance environment:

  • The Recovery Appliance named ZDLRA London was set up over two weeks ago.

  • 20 protected databases back up to ZDLRA London.

To review reports on storage capacity:

  1. Go to the pre-created reports page, as described in "Accessing the Recovery Appliance Reports Page in Cloud Control".

  2. Click Capacity Planning Summary.

    The BI Publisher Enterprise page appears.

  3. Enter your BI Publisher credentials, and then click Sign In.

    The Capacity Planning Summary page appears.

  4. In Recovery Appliance, select a Recovery Appliance, and then click Apply.

    For example, select ZDLRA London.

  5. Review the Storage Capacity Planning Summary section to determine the storage growth rate and days until capacity is exceeded.

    For example, the following graphic shows the summary for ZDLRA London:

    The key metric is the 6.85 days until capacity is exceeded. Within a week, the Recovery Appliance will either purge backups or reject incoming backups, depending on the protection policy settings (see "Guaranteed Copy").

  6. View the historical storage trends.

    For example, examine the trends for the past week:

    The preceding chart shows that over the last two days, the total space needed to satisfy the recovery window goals for all protected databases has increased from 5.2 TB to 21 TB. The number of protected databases has been steady at 20.

  7. In the Network Capacity Planning Summary, check the network throughput.

    For example, examine the network throughput for the past week:

    The preceding chart shows that the receive rate spiked during the last two days.

    The network capacity planning summary provides a view of the aggregated network traffic over various time periods (24 hours, 7 days, and 30 days).

  8. Return to the pre-created reports page.

  9. Click Capacity Planning Details.

    The Recovery Appliance: Capacity Planning - Details page appears.

    This report provides an even finer granularity of information than the capacity planning summary. Unlike the capacity planning report, the detailed report also has memory and IOPS information.

  10. If the desired Recovery Appliance is not already selected in Recovery Appliance, then select it and click Apply.

  11. At the beginning of the report, click Storage Capacity Planning Details to jump to this section.

  12. Scroll down to the Cell Disk IO subsection of the IO Historical Data section.

    For example, for each storage server, the following table shows the IOPS and throughput at 15 minute intervals:

Accessing the Recovery Window Summary Report

This tutorial explains how to view the recovery window summary of the databases protected by your Recovery Appliance.

Assumptions

Assume that the following statements are true of your environment:

  • The Recovery Appliance named ZDLRA Montreal protects 13 databases.

  • You want to determine whether any database has not been meeting its recovery window.

To review the recovery window summary report:

  1. Go to the pre-created reports page, as described in "Accessing the Recovery Appliance Reports Page in Cloud Control".

  2. Click Recovery Window Summary.

    The Recovery Appliance: Recovery Window Summary page appears.

  3. Enter your BI Publisher credentials, and then click Sign In.

    The Recovery Appliance: Recovery Window Summary page appears.

  4. In Recovery Appliance, select a Recovery Appliance, and then click Apply.

    For example, select ZDLRA Montreal.

    The page refreshes, displaying the summary at the top, as in the following example:

    The pie chart shows that over 75% of the databases are not meeting their service level agreements. The table shows that out of 13 total databases, 3 databases are not meeting their recovery window goal. Also, 8 databases are not within their unprotected data threshold.

  5. Scroll down to charts showing the databases not meeting their recovery window goals.

    The following example shows two sample reports:

    The preceding example shows that databases DB1116 and DB1123 both have recovery window goals of 1 day, but have recovery windows that are many hours short of this goal. DB11242 also has a goal of 1 day, but has an actual recovery window of less than an hour.

Accessing the Protected Database Details Report

You can access the Protected Database Details report either from the Recovery Appliance Reports page or the Protected Database page.

Accessing the Details Report from the Protected Databases Page

This access path is an alternative to using the Enterprise menu to go to the Recovery Appliance Reports page.

To access the Protected Database Details page:

  1. Access the Recovery Appliance Home page, as described in "Accessing the Recovery Appliance Home Page".

    For example, access the home page for ZDLRA Montreal.

  2. From the Recovery Appliance menu, select Protected Databases.

    The Protected Databases page appears.

  3. In the Protected Databases table, select a database.

    For example, select DB1124.

    At the bottom of the page, the Protected Database Detail section is refreshed.

  4. In the Protected Database Detail section, select Status.

    The Status subpage is displayed, as shown in the following example:

  5. Click Protected Database Report.

    The BI Publisher page appears.

  6. Enter your BI Publisher credentials, and then click Sign In.

    The Recovery Appliance: Protected Database Details page appears (see Step 4 in "Accessing the Protected Database Details Report from the Recovery Appliance Reports Page").

Accessing the Protected Database Details Report from the Recovery Appliance Reports Page

This tutorial explains how to access detailed reports for protected databases.

Assumptions

Assume that Recovery Appliance named ZDLRA Philadelphia protects 12 databases.

To review reports on protected databases:

  1. Go to the pre-created reports page, as described in "Accessing the Recovery Appliance Reports Page in Cloud Control".

  2. Click Protected Database Details.

    The Recovery Appliance: Protected Database Details page appears.

    Note:

    You can also access this report directly from the Protected Databases page, as explained in "Accessing the Details Report from the Protected Databases Page".

  3. In Recovery Appliance, select a Recovery Appliance.

    For example, select ZDLRA Philadelphia.

  4. In Protected Database, select a database, and then click Apply.

    For example, select DB1124.

    The Recovery Appliance: Protected Database Details page appears.

  5. Scroll down to the Backup/Recovery section.

    For example, the following graphic shows the statistics for the DB1124 database:

    The preceding statistics indicate that the database needs 182.83 GB to meet its recovery window goal.

  6. Examine the backup history.

    For example, the following chart shows the data sent and received over the past week by DB1124:

    The preceding chart shows that the daily backup data was between 31 and 49 GB every day except 8/25, when it was 305.1 GB. On every day, the amount of replication data sent was slightly less than the backup data received.

  7. Repeat the preceding two steps as needed to investigate the backup activity of all the protected databases.

Accessing the Protected Database Data Transfer Report

This tutorial explains how to view the data transfer reports for a Recovery Appliance.

Assumptions

Assume that the following statements are true of your environment:

  • The Recovery Appliance named ZDLRA Montreal protects 10 databases.

  • The Recovery Appliance replicates backups for some databases, but does not archive to tape.

  • You want to determine which database has been transferring the most data over the past week.

To review the data transfer report:

  1. Go to the pre-created reports page, as described in "Accessing the Recovery Appliance Reports Page in Cloud Control".

  2. Click Top 10 Protected Databases by Data Transfer.

    The BI Publisher Enterprise page appears.

  3. Enter your BI Publisher credentials, and then click Sign In.

    The Top 10 Protected Databases by Data Transfer page appears.

  4. In Recovery Appliance, select a Recovery Appliance, and then click Apply.

    For example, select ZDLRA Montreal.

  5. Click Top 10 Databases by Backup Data.

    The Backup Data section is shown.

  6. Scroll down to the Last 7 Days (Aggregated By Day) section.

    For example, the period from 09/08 to 09/15 shows the following data:

    According to the preceding chart, database DB12CDB backed up the most data every day. The peak transfer was on 09/09, with about 1.25 TB.

  7. Return to the top of the report, and then click Top 10 Databases by Replication Data.

    The Replication Data section is shown.

  8. Scroll down to the Last 7 Days (Aggregated By Day) section.

    For example, the period from 09/08 to 09/15 shows the following data:

    According to the preceding chart, database DB12CDB replicated the most data every day. The peak transfer was on 09/11, with around 1.7 TB.

Accessing the Protected Database Chargeback Report

This tutorial describes how to view the charge calculation information for a protected database.

About the Protected Database Chargeback Report

The Protected Database Chargeback report is used for chargeback of protected databases enrolled with Recovery Appliance. It displays data in both graph and pivot table formats.

The Protected Database Chargeback report is not an out-of-the-box report. After you deploy this report, it can be accessed from the location to which it is deployed.

The report contains the following two versions:

  • Recovery Appliance Protected Database Chargeback - Greatest

    Provides charge calculation based on tape storage utilization and the higher value among backup storage utilized and projected recovery window storage utilization. With this model, the consumer pays for the entire recovery window space needed up front.

  • Recovery Appliance Protected Database Chargeback - Least

    Provides charge calculation based on tape storage utilization and the lower value among backup storage utilized and projected recovery window storage utilization. With this model, the consumer pays only for the utilized space.

Each version of the Protected Database Chargeback report contains the following two sections:

  • Protected Database Space Chargeback on the Recovery Appliance

  • Protected Database Space Chargeback on Tape

Each section is further divided into the following subsections:

  • Monthly chargeback (last 12 months)

    This subsection contains the following:

    • Space breakdown

    • Budgetary breakdown

  • Yearly chargeback

    This subsection contains the following:

    • Space breakdown

    • Budgetary breakdown

  • Daily information (last 30 days)

    Displays the maximum current space, maximum recovery window space, and the maximum reserved space for the selected protected database in the last 30 days.

The space breakdown contains the following information:

  • Current space

    Represents the amount of disk space on the Recovery Appliance currently being used by this protected database during the indicated time period

  • Reserved space

    Represents the minimum amount of disk space on the Recovery Appliance reserved for use by this protected database to meet its recovery window goal

  • Recovery window space

    Represents the estimated space (in GB) that is needed to meet the recovery window goal for this protected database

The budgetary breakdown contains the following information:

  • Chargeback amount

    Represents the fixed amount charged for the database for a given time period

  • Chargeback amount delta

    Represents the difference in chargeback between the current and previous reported value

Viewing the Protected Database Chargeback Report

Use Enterprise Manager Cloud Control to access the Protected Database Chargeback report.

Before you access the report, deploy the Protected Database Chargeback report to BI Publisher using the information in My Oracle Support Note Doc ID 2247393.1 (http://support.oracle.com/epmos/faces/DocumentDisplay?id=2247393.1).
To view the protected database chargeback report:
  1. Go to the pre-created reports page, as described in "Accessing the Recovery Appliance Reports Page in Cloud Control".
  2. From the Enterprise menu, select Reports, and then BI Publisher Enterprise Reports.

    The BI Publisher Enterprise Reports page appears.

  3. Expand the My Folders folder and then expand the ZDLRA – New BI Reports (Wave 2) folder.
  4. Depending on which version of the report you want to access, click Recovery Appliance - Protected Database Chargeback – Greatest or Recovery Appliance - Protected Database Chargeback – Least.
  5. Select the required values in the Recovery Appliance, Protection Policy, Protected Database, Recovery Appliance – Cost $/GB, and Tape – Cost $/GB.
  6. Click Apply to display the report.

    For both Recovery Appliance and Copy to Tape, the space breakdown and the budgetary breakdown are displayed.

    The following chart shows the monthly space breakdown for the protected database T12E8K in the Recovery Appliance. The details tabulated for each month include the maximum current space, maximum recovery space, and the maximum reserved space. The table below the graphic displays the same information in tabular format in table below the graph. Click the column headers to sort for filter the displayed data.

    The monthly budgetary breakdown for tape is displayed below. Data, including the chargeback amount and chargeback amount delta, is displayed in both chart and tabular format.

    The following image displays the daily information for the Recovery Appliance in the last 30 days. Details include the maximum current space, maximum recovery window space, and maximum reserved space.

    Description of pdb_chargeback_ra_30days.gif follows
    Description of the illustration pdb_chargeback_ra_30days.gif

Accessing the Active Incidents Report

This tutorial describes how to view the current active incidents for a Recovery Appliance. The data is represented in both pie chart and table format.

The incidents report can be broken down by component, protected database, or incident severity.

Deploy the incident report to BI Publisher using the information in My Oracle Support Note Doc ID 2247391.1 (http://support.oracle.com/epmos/faces/DocumentDisplay?id=2247391.1).

Assumptions

Assume that the following statements are true of your environment:

  • The steps required to deploy the incidents report to BI Publisher have been performed.

    The active incidents report is not an out-of-the-box report. After you deploy this report, it can be accessed from the location to which it is deployed

To review the active incidents report:

  1. Go to the pre-created reports page, as described in "Accessing the Recovery Appliance Reports Page in Cloud Control".
  2. Click Recovery Appliance Incidents.

    The Recovery Appliance Incidents page is displayed.

  3. From the Recovery Appliance list, select the name of the Recovery Appliance and click Apply.

    The active incidents report for the selected Recovery Appliance is displayed. The report contains three pie charts and a table.

    For example, select ZDLRA Baltimore and click Apply.

    The page refreshes displaying a report containing the following: a pie chart of active incidents by component, a pie chart of active incidents by protected database, a pie chart of active incidents by severity, and a tabular representation of the report.

    For example, the following pie chart shows the percentage of active incidents for each Recovery Appliance component:

    Click a section in the chart to display active incident details for component represented by the selected section. For example, click the section representing the SCHEDULER to view active incident details for the scheduler. The active incidents by database, active incidents by severity, and the tabular representation of the report are automatically updated based on your selection.

  4. View the active incidents broken down by protected database.

    For example, the following chart shows the statistics of active incidents reported for six protected databases :

    When you click the section representing a particular protected database, the data in the other pie charts and table is updated automatically based on the selection.

  5. View the active incidents broken down by severity.

    Incident severity can be one of the following:

    • Internal severity: This indicates an error that needs immediate action. It is the highest category of incidents.

    • Error severity: This indicates that the operation ended in an error and needs attention.

    • Warning severity: This indicates that the operation resulted in a warning. You can review the warning for additional actions that may be need to be performed.

    The following chart shows that there are only warnings, no incidents of internal severity or errors, for the selected Recovery Appliance:

    Below this chart is the tabular format of the active history report, as shown in the following example:

Accessing the API History Report

This tutorial describes how to view the history of API calls made to procedures in the DBMS_RA package. The report displays the data in pie chart and pivot table formats.

The pie chart in the API history report can be broken down by API call. The report also contains a table with the name of the API calls, data they were run, and the number of calls.

Deploy the API history report to BI Publisher using the information in My Oracle Support Note Doc ID 2247392.1 (http://support.oracle.com/epmos/faces/DocumentDisplay?id=2247392.1).

Assumptions

Assume that the following statements are true of your environment:

  • The steps required to deploy the incidents report to BI Publisher have been performed.

    The API history report is not an out-of-the-box report. After you deploy this report, it can be accessed from the location to which it is deployed

To review the API history report:

  1. Go to the pre-created reports page, as described in "Accessing the Recovery Appliance Reports Page in Cloud Control".
  2. Click API History audit.

    The API History Audit page is displayed.

  3. From the Recovery Appliance list, select the name of the Recovery Appliance and click Apply.

    The API call history report for the selected Recovery Appliance is displayed. A pie chart displays the statistics for the API calls made, as in the following example:

    Click a section in the chart to display the details for the API call represented by the selected section in the table below the chart. For example, click the section on the right of the chart that represents GRANT DB to display the history details for this API. The data in the table is automatically updated based on your selection.

  4. View the API history in tabular format.

    By default, a date-wise summary with one column for each API call in the report is displayed, as shown in the following example:

    Click a cell in the summary to display details for the API call and date represented by the selected cell.