Re: Who uses active data guard?

From: <>
Date: Mon, 15 Oct 2012 13:39:47 -0700 (PDT)
Message-ID: <>

On Sunday, October 14, 2012 11:31:39 PM UTC-4, (unknown) wrote:
> Oracle has great technology such as Active Data Guard where one can do reporting from a standby database which is in synch with production database; but I have not found any application for it. My company buys off the shelf applications such as Documentum, SAP, Trackwise (Event Tracking System) and all applications have been deigned to have a centralized database. Since vendor does not support a separate database for reporting, it is hard to convince management to use an unsupported configuration which can stop working any time!! I am curious lots of companies buy off the shelf packages, so where a technology like Data Guard really gets used.

I thought data guard (whether active or not) provides for automatic repair from block corruption. Can you confirm, it is only active data guard?

To clarify I did not mean standby database will stop working, what I meant was vednor's appliction stops wroking when new patches come because vendor has not tested their apllication/reports with a read only database. Sometimes, reports etc behind the scene may write something to database such as audit information; so it is hard to start using standyby database for reporting when vendor has not blessed it. It may work initailly but when new patches come, it may not! Received on Mon Oct 15 2012 - 22:39:47 CEST

Original text of this message