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 first published in June 2005

Dig deeper on Oracle data warehousing

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close