Pre-Created Oracle Analytics Publisher Reports

Recovery Appliance provides the following pre-created Oracle Analytics Publisher (OAP) reports. [Enterprise Manager 13.4 and earlier, these reports were available within Cloud Control as BI Publisher reports.]

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.
Capacity Planning Summary: This report provides an overview of storage utilization and aggregated network traffic for the Recovery Appliance so that 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.
Protected Database Chargeback Greatest: This report is used for chargeback of protected databases enrolled with the Reovery Appliance. With this model, the consumer pays for the entire recovery window space needed upfront.
Protected Database Chargeback Least: This report is used for chargeback of protected databases enrolled with the Recovery Appliance. With this model, the consumer pays only for the utilized space.
Protected Database Details: This report provides extensive information about a protected database including summaries of the following:
- The protection policy
- Recovery Appliance storage location
- The disk recovery window goal
- The reserved space, which is the minimum amount of disk space in the Recovery Appliance reserved for the database to meet its disk recovery window goal
- The status of real-time redo transport, which eliminates data loss
- Data sent and received over time for backup, copy-to-tape, and Recovery Appliance replication operations, which gives a good overview of the traffic coming to and from the protected database to the Recovery Appliance
Recovery Window Summary: This report provides a list of protected databases that are not meeting their recovery window goal or are exceeding their 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.
System Activity: This report is a diagnostic aid for problems with the Recovery Appliance system and provides an organized visual report of all activity on the system. This includes general state, storage usage, running tasks, incidents encountered, and API commands executed.
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.

Note:

Although performance data is accessible through SQL queries of V$ and recovery catalog views, Oracle highly recommends that you use the OAP 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.