RE: Automatic log switching in DataGuard
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.
http://dl.dropbox.com/u/1308790/Captura.JPG
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/log_transport.htm
De: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] En nombre de Allen, Brandon [Brandon.Allen_at_OneNeck.com] Enviado el: martes, 21 de septiembre de 2010 18:16 Para: Amihay.Gonen_at_ecitele.com; oracle-l_at_freelists.org CC: Koby Nachmany
Asunto: RE: Automatic log switching in DataGuard
Why not use real-time apply instead? Then you dont need to be concerned about log switches. For more info:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/log_apply.htm#SBYDB0050
Disclaimer: Ive 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.
Thanks,
Brandon
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 21 2010 - 13:18:52 CDT