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.