Q

Data warehousing possible on a disaster recovery hot site?

We have been granted approval to put together a disaster recovery hot site (high availability) We are planning on buying the appropriate DR licenses from Oracle and implementing DataGuard as the replication tool. Our CIO would like to do some data warehousing or at least reporting on the hot site. Is this possible when using DataGuard in a standby DR replication scenario?
One of the advantages of Data Guard is that you can place the standby instance in READ ONLY mode so that you can run reports against the database without impacting your Primary instance. The biggest downside to this approach is that while the standby instance is in READ ONLY mode, it is not able to apply redo from the primary database. So data divergence will exist. In the event of a failure, you will have to wait for the Standy to apply all of the redo before it can become your new primary database. The amount of time you place your standby in READ ONLY mode can lead to a long delay in the amount of time it takes for a failover to occur.
This was last published in June 2005

Dig Deeper on Oracle data warehousing

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close