Database Software

Dear user530956,

I think i have seen a calculation of the bandwidth once in a white paper of the Data Guard but we have to search internet for that.

I don't know the exact calculation but i can give an example that might help you out;

We have 2 TB database with 200 - 250G archivelog generation per day. We have 300 mbit connection between primary and the DR site. It can catch up and does not fall behind. But if have a 155 mbit connection, the system could fail because of the transport rate.

Hope That Helps.

Ogan

Thanks for the reply. One more consultancy question, imagine the primary db is running in highend configuration attached with SAN and connecting to Standby site with sufficient network bandwidth. And standby server connecting to NAS storage and with midrange server configuration and DG configured in Maximum performance mode, will have any performance issues on production box ?

Dear user530956,

Maximum performance mode is the best one if you don't have sufficient bandwidth and less hardware design and configuration. If you pay more, you are going to loose less or even zero data when a disaster happens WITH the standby redo logs, LGWR SYNC AFFIRM option and the maximized protection of the data guard.

Protection level and the synchronization method (SYNC or ASYNC) can change the performance on the standby database EVEN on the primary database, do not forget that.

Regarding your configuration question, it would be better for you to set the hardware specification identical. Bear in mind that when a disaster happens, the standby database will be the PRIMARY database until you reconfigure the actual primary database again. That is a recommendation and taking serious or not is totally up to you. I have written my experiences.

Regards and hope that helps.

Ogan