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 Testa, Oracle Certified Professional 
Senior Engineering & Administration Lead
(Work) 614-677-1668
(Cell) 614-312-6715

"Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
05/13/2010 01:55 PM
Data Guard and E-Business Suite
Sent by:

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 
Dick Goulet 
Senior Oracle DBA/NA Team Lead 
PAREXEL International 
900 Chelmsford St, Suite 310 
Lowell, MA 01821 
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: