oracle 9.2.0.8 and phisical standby and lgwr with sync problem

From: hehehe <m_at_m.ccc>
Date: Tue, 25 Aug 2009 10:47:06 +0200
Message-ID: <h708eb$2187$1_at_news2.ipartners.pl>



Hello!

  I have configuration like this :

                             service=xxxxx, LGWR SYNC
Productional DB ------------------------------------------>STANDBY xxxxx DB



So every trasaction before commit is transmit to STANDBY by lgwr. But i have problem when power go down fo 2 sec. then lgwr stop transmit information from production to standby. On standby i have 3 standby redo logs. But when power go up then productional sende again information. But when power was down information in standby redo logs is coruupt and standby database broke... What i need to do in parameter or add to parameter log_archive_dest_n to stop this corrupt think?

Regards Received on Tue Aug 25 2009 - 03:47:06 CDT

Original text of this message