Dbvisit - The ultimate Oracle standby database solution
Giving you peace of mind
Dbvisit reporting database
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. As long as this office has an Internet connection, Dbvisit can send the compressed archives through the Internet to the 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.
Because of the clever way that Dbvisit functions as separate independent modules on the primary and standby/reporting servers, 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. In the event that the reporting database has to be activated and used as the new primary database, all the logs from the primary database are available and can be applied to ensure that the reporting database is completely "up-to-date".
Dbvisit is a registered trademark of Avisit Solutions Limited
Oracle is a registered trademark of Oracle Corporation
