RE: Automatic log switching in DataGuard

From: Juan Cruz Miranda Vigo <>
Date: Tue, 21 Sep 2010 20:18:52 +0200
Message-ID: <5A25A252E6111747ADBF7904B67E9DCA0183513CB060_at_MAILSERVER2.itdeusto.local>

Indeed you donīt need real time apply.

You need to create standby redologs and configure: log_archive_dest_2="SERVICE=STBY reopen=30 DELAY=180 OPTIONAL NOAFFIRM LGWR ASYNC"

this way you will send the data to remote standby redologs AND online redologs at same time and you donīt have data loss.

Data in standby redo logs will be applied on standby database when DELAY time expires. It will be applied immediatly if you have real-time-apply.

Note that redo-transport and redo-apply are independent jobs.

De: [] En nombre de Allen, Brandon [] Enviado el: martes, 21 de septiembre de 2010 18:16 Para:; CC: Koby Nachmany
Asunto: RE: Automatic log switching in DataGuard

Why not use real-time apply instead? Then you don’t need to be concerned about log switches. For more info:

Disclaimer: I’ve never used real-time apply myself, but am in the process of setting it up for the first time right now. If anyone has any reasons why it should not be used, please let me know.


Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.
Received on Tue Sep 21 2010 - 13:18:52 CDT

Original text of this message