RE: Data Guard and E-Business Suite
- From: "SHEEHAN, JEREMY" <JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx>
- To: "Richard.Goulet@xxxxxxxxxxx" <Richard.Goulet@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 13 May 2010 13:58:58 -0400
I had this setup at my last job and we didn't see any performance hits at all.
We did have data guard issues, but it was due to a small pipe to the DR site.
Jeremy
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Goulet, Richard
Sent: Thursday, May 13, 2010 1:54 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Data Guard and E-Business Suite
Have a question from one of the other folks here who is dealing solely with
EBS. They recently created a data guard standby database (play type) and went
to try a failover to see how the app server would behave. Again this is a play
environment so errors are expected. What she did not expect is that when
failing over the database the system complained about block corruption. We
consequently figured out the it was due to the master db not having forced
logging enabled so we know the master cause. But we did check around the db
and found a very large number of application tables that had nologging set.
This e think is rather odd and is either a foul-up on the development side at
Oracle or something they did deliberately for one reason or the other. We're
now wondering if setting forded logging on at the database level is going to
cause us performance or other problems. So, is anyone out there running EBS
with a DG standby and forced logging on the master??? What effects are you
seeing???
Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International
900 Chelmsford St, Suite 310
Lowell, MA 01821
978.614.2857
Richard.Goulet@xxxxxxxxxxx
http://www.parexel.com
The information transmitted in this communication is intended only for the
person or entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or other use of,
or taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received this
in error, please destroy any copies, contact the sender and delete the material
from any computer.
Other related posts:
