Re: Best practices Oracle E-Business Suite and 11g Active Data Guard

  • From: Chuck Edwards <chuck@xxxxxxxxxxxxx>
  • To: ora-apps-dba@xxxxxxxxxxxxx
  • Date: Thu, 12 Mar 2009 06:48:46 -0700

You can use Active Data Guard with EBS, you just can't use the applications on the standby. As the Steven Chan article points out, you can still use Active Data Guard as a valid part of a DR strategy, with the added advantage of the database open read-only.


You could therefore use an EBS Active Data Guard instance for reporting, as long as that reporting did not require the concurrent manages or other EBS application components to be available. Direct queries, etc, should work fine. If that is of use to you and you can afford the licensing, it may be worthwhile.


Chuck Edwards
Blue Gecko, Inc.
http://www.bluegecko.net

On Mar 12, 2009, at 6:20 AM, Reddy, Sridhar wrote:

EBS 11i or R12 supports only physical standby database as part of its Data guard strategy. It does not support Active Data Guard.

The concept of Active Data Guard is such that it is open READ ONLY mode while still the log is being applied and to login to EBS you need the DB in READ WRITE mode.

For complete details see the following link

http://blogs.oracle.com/stevenChan/2008/10/comparing_oracle_data_guard_vs_active_data_guard_f.html

Thanks
Sridhar





Other related posts: