oracle data guard 的一些经验优化

oracle data guard 的一些经验优化

os: centos 7.4
db: oracle 11.2.0.4

足够的带宽

比如 redo log 的生成速度是 5MBps，那么带宽至少要是 5MB/0.7 *8=57 Mbps

oracle net 的 SDU

SDU全程是 Session Data Unit，当 oracle net 进行数据传输时，oracle 将数据缓存在SDU内存中。通过调大 SDU值，可以明显提高日志传输性能。
修改 a

DEFAULT_SDU_SIZE=32767

或者在 a 针对特定 service name 进行设置

ORAVM_11.2.0.4 =(DESCRIPTION =(SDU=32767)(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.220)(PORT = 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl)))

对 a 也要修改

SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SDU=32767)(GLOBAL_DBNAME = orcl)(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)(SID_NAME = orcl)))

设置 TCP Sockte Buffer

修改 a

ORAVM_11.2.0.4 =(DESCRIPTION =(SEND_BUF_SIZE=9375000)(RECV_BUF_SIZE=9375000)(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.220)(PORT = 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl)))

修改 a

LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.200)(PORT = 1521)(SEND_BUF_SIZE=9375000)(RECV_BUF_SIZE=9375000))))

设置网卡队列长度

默认是 1000，调整到 10000

# echo 2000 > /proc/sys/net/core/netdev_max_backlog;
echo 1 > /proc/sys/net/ipv4/route/flush; 
ifconfig eth0 txqueuelen 10000;