We're here to help!

Use the Standby database as a reporting (read-only) database

Follow

Description

The article explains how to use the Dbvisit Standby database for reporting purposes during certain time frames in a day. This is solution is for customers who are not worries about the data being latest or in sync with primary and are ok with using old data.
Solution

With Dbvisit Standby, as with any physical Oracle standby database solution, the standby database can either be in:

Apply mode
Where changes from the primary are applied to bring it up to date.
Read-only mode
Where the database is open for query access but at which time the changes from production are not applied.

Using Dbvisit Standby makes it possible to easily automate a schedule to switch between these different modes. For example, the following could be set up:

6-8am
Apply mode: Apply queued up changes from production.
8am - 12pm
Read only mode: Have the standby database open for querying by your team. Bear in mind that by midday it will now be up to four hours behind production. For many customers this is acceptable.
12-1pm
Apply mode: Apply changes from the primary database to bring it up to date with that instance.
1-5pm
Read only mode: Have the standby database open for querying again.

etc, etc...

Two further comments on this:

  1. Changes from production are actually delivered to the DR server the entire time, so in a sense if they have been successfully transferred then you are protected in terms of DR.
  2. You only need have the Standby database in apply mode for as long as needed to apply the queued up changes from production before you open it back up for read only access. The actual time required for this depends on the volume of redo generated and the speed of the components (ie: servers) in your system.

If this does not meet your requirements, in that you are looking for a real-time and always available reporting system, we offer a low-cost solution: Dbvisit Reporting. As with Dbvisit Standby we offer a fully featured, free 30 day trial version of this software. We encourage you to make use of this if you believe it may be suited to your requirements.

http://www.dbvisit.com/products/dbvisit_reporting_offload_reporting_databases/

Mike Donovan November 20, 2012 08:25

 

Have more questions? Submit a request

Comments