Dear Guru's,
Could you please explain me the difference between Gurad 10g sync and async.
Thanks in advance...
Best Regards,
Printable View
Dear Guru's,
Could you please explain me the difference between Gurad 10g sync and async.
Thanks in advance...
Best Regards,
don't mind to google it.
Thanks,
a good one for you from google ...;)
http://www.oracle.com/technology/dep...tPractices.pdf
Thanks,
Synchronous : The synchronous redo transport mode transmits redo data synchronously with
respect to transaction commitment. A transaction cannot commit until all redo generated by that transaction has been successfully sent to every enabled redo transport destination that uses the synchronous redo transport mode.This transport mode is used by the Maximum Protection and Maximum Availability data protection modes .
Asynchronous : The asynchronous redo transport mode transmits redo data asynchronously with respect to transaction commitment. A transaction can commit without waiting for the redo generated by that transaction to be successfully sent to any redo transport destination that uses the asynchronous redo transport mode.This transport mode is used by the Maximum Performance data protection mode .