Re: Data Guard and E-Business Suite

From: <>
Date: Thu, 13 May 2010 13:56:57 -0400
Message-ID: <>

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" <> To:
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 seeing???
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.

Received on Thu May 13 2010 - 12:56:57 CDT

Original text of this message