Oracle Reporting Database

Local Balancing

To offset the load on the primary database and server when running large reports, these reports may be run on a reporting database. This reporting database functions much like a standby database and is an exact copy of the production database running on a separate server.

This reporting database feature can be used for:

  • Providing a reporting database to run large reports without impacting the primary database and server. Having this functionality can help ease the load on the primary database by migrating large reports to the reporting database.
  • Providing an up-to-date database for a remote office.

The difference between a standby database and a reporting database is that the reporting database is available in READONLY mode while a standby database is not available for reading purposes. A standby database is in recovery mode.

When a reporting database is in READONLY mode, it is not able to be kept up to date with the primary database. Only when the reporting database is in recovery mode, can it be kept up to date with the primary database.

The reporting solution can be totally automated

Dbvisit can automate the process so that the reporting database is available for reporting during the day and at night is in recovery mode to automatically start applying all the updates that have arrived during the day and subsequent night. Next morning, Dbvisit will automatically open the reporting database in READONLY mode so that it is up to date with the primary database to run reports.

Cost effective

In order to safe cost, the function of the reporting database and the standby database can be combined into one standby database with Dbvisit. This makes Dbvisit a very cost effective solution that provides both a standby and a reporting database.

Continuous protection

With Dbvisit it is possible to open the standby database for reporting purposes during the day, while the primary database is still sending updates to the standby/reporting server. This ensures you are continuously protected as all the updates are available ready to be applied in case of disaster or failure.