RE: standby config --> FAL_SERVER / FAL_CLIENT

  • From: <k.sriramkumar@xxxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 10 Feb 2004 17:45:28 +0530

Hi Prem,

        Yes there is a performance overhead with maximize protection. As I said 
=
earlier, the LGWR process is going to ship the log changes to the =
standby database (does not wait till its applied) and hence It boils =
down to the network connectivity that exists between the primary and the =
standby database. Your overhead is proportional to the network =
bandwidth. Pls test it with a real load before you put in production.

Best Regards

Sriram Kumar


-----Original Message-----
From: Prem Khanna J [mailto:jprem@xxxxxxxxxxxx]=20
Sent: Tuesday, February 10, 2004 4:01 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: standby config --> FAL_SERVER / FAL_CLIENT

>>Sri:Well the moment you say its maximize protection(Zero data=20
>>loss), The LGWR takes charge of ensuring that the Logfiles and the=20
>>remote standby redolog files are in sync. The transaction would be
signaled=20
>>a commit iff the transaction is applied to log file and the standby=20
>>redolog file. So don't worry abt placing your log files in a Shared
storage=20
>>you wont need them for this protection mode

Thanks again Sriram .=20
Read in docs that " Maximum Protection " has some performance overhead .
what's ur opinion about it ? anyway , i need to test it and see whether
it
is acceptable for me .

Regards,
Prem.

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


DISCLAIMER:
This message contains privileged and confidential information and is =
intended only for the individual named.If you are not the intended =
recipient you should not disseminate,distribute,store,print, copy or =
deliver this message.Please notify the sender immediately by e-mail if =
you have received this e-mail by mistake and delete this e-mail from =
your system.E-mail transmission cannot be guaranteed to be secure or =
error-free as information could be =
intercepted,corrupted,lost,destroyed,arrive late or incomplete or =
contain viruses.The sender therefore does not accept liability for any =
errors or omissions in the contents of this message which arise as a =
result of e-mail transmission. If verification is required please =
request a hard-copy version.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: