Re: Data Guard and E-Business Suite
- From: TESTAJ3@xxxxxxxxxxxxxx
- To: Richard.Goulet@xxxxxxxxxxx
- Date: Thu, 13 May 2010 13:56:57 -0400
I can't answer from the EBS but there is a performance penalty to forced
logging but its a requirement for standby to place nice :)
joe
_______________________________________
Joe Testa, Oracle Certified Professional
Senior Engineering & Administration Lead
(Work) 614-677-1668
(Cell) 614-312-6715
From:
"Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
To:
<oracle-l@xxxxxxxxxxxxx>
Date:
05/13/2010 01:55 PM
Subject:
Data Guard and E-Business Suite
Sent by:
oracle-l-bounce@xxxxxxxxxxxxx
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:
