Data Guard and E-Business Suite
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 13 May 2010 13:54:04 -0400
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:
