oracle standby redo,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