Oracle DG Standby Redo Log

Standby Redo Log
SRL用途:主要是备库用来接收来自主库的online redo log,用在最大保护,最大可用性的data guard模式中,以及最大性能的LGWR ASYNC传输方式中.
也就是说,默认的最大性能模式归档传送redo的方式的data guard可以不使用SRL,我们的生产库目前就没有使用SRL,但Oracle官方建议在主备库启用SRL.
文件大小:保持与主库一致大小.
文件数目:(maximum number of logfiles for each thread + 1) *maximum number of threads
select group#,status,type,member from v$logfile order by 1

    GROUP# STATUS  TYPE    MEMBER
---------- ------- ------- ----------------------------------------------------------------------
         1         ONLINE  +DATA/rdpsdbst/onlinelog/group_1.270.774897787
         1         ONLINE  +RECOVERY/rdpsdbst/onlinelog/group_1.263.774897801
         2         ONLINE  +DATA/rdpsdbst/onlinelog/group_2.271.774897811
         2         ONLINE  +RECOVERY/rdpsdbst/onlinelog/group_2.264.774897825
         3         ONLINE  +DATA/rdpsdbst/onlinelog/group_3.272.774897835
         3         ONLINE  +RECOVERY/rdpsdbst/onlinelog/group_3.265.774897843
         4         ONLINE  +DATA/rdpsdbst/onlinelog/group_4.273.774897855
         4         ONLINE  +RECOVERY/rdpsdbst/onlinelog/group_4.266.774897865
         5         STANDBY +DATA/rdpsdbst/onlinelog/group_5.264.774894019
         5         STANDBY +RECOVERY/rdpsdbst/onlinelog/group_5.257.774894027
         6         STANDBY +DATA/rdpsdbst/onlinelog/group_6.265.774894061

    GROUP# STATUS  TYPE    MEMBER
---------- ------- ------- ----------------------------------------------------------------------
         6         STANDBY +RECOVERY/rdpsdbst/onlinelog/group_6.258.774894069
         7         STANDBY +DATA/rdpsdbst/onlinelog/group_7.266.774894099
         7         STANDBY +RECOVERY/rdpsdbst/onlinelog/group_7.259.774894107
         8         STANDBY +DATA/rdpsdbst/onlinelog/group_8.267.774894163
         8         STANDBY +RECOVERY/rdpsdbst/onlinelog/group_8.260.774894171
         9         STANDBY +DATA/rdpsdbst/onlinelog/group_9.268.774894193
         9         STANDBY +RECOVERY/rdpsdbst/onlinelog/group_9.261.774894205
        10         STANDBY +DATA/rdpsdbst/onlinelog/group_10.269.774894225
        10         STANDBY +RECOVERY/rdpsdbst/onlinelog/group_10.262.774894235

单个线程最多有2个成员, 这里有2个线程 ,所以SRL的数量为(2+1)*2=6,所以要创建6个SRL Group,每个Group成员2个(为镜像关系).

Dataguard的三种模式中,redo传输方式与SRL的应用.

参见官方文档
http://docs.oracle.com/cd/B19306_01/server.102/b14239/create_ps.htm#i1225703

http://docs.oracle.com/cd/B19306_01/server.102/b14239/standby.htm#i72459

http://docs.oracle.com/cd/B19306_01/server.102/b14239/concepts.htm#i1029121

http://docs.oracle.com/cd/B19306_01/server.102/b14239/log_transport.htm#i1178539