????????????????????????????ORL????????????LNS????log
buffer????????????????????????????????ORL????????????????????????????redo??????????log
buffer????ORL??????????LNS??????????log buffer?? -->
??????????????????????????????????lgwr??????????,lgwr????????????????,??????????????
????LNS????????,??????????????sync/async??????????
????????????ORL????????????LNS????log
buffer????-->??????????????????????????????????X$LOGBUF_READHIST??????????????????????
??????????????LNS????????ORL.
------------------ ???????? ------------------
????de??: "Kamus@Enmotech"<kamus@xxxxxxxxxxxx>;
????????: 2015??7??16??(??????) ????1:44
??????: "enmotech"<enmotech@xxxxxxxxxxxxx>;
????: [Enmotech] Re: [Enmotech] Re: [Enmotech]????DG??REDO????????
????????????????????????????????????????????11gR1????Oracle??????????????LNS??????log
buffer??????????????????????????????
Note: Oracle Data Guard asynchronous redo transport will only read in-memory
redo blocks
that have already been written to the ORL. This ensures that there is no
divergence between
the Standby and Primary as a result of this feature.
????????????????????????????ORL????????????LNS????log
buffer????????????????????????????????ORL????????????????????????????redo??????????log
buffer????ORL??????????LNS??????????log
buffer????????????????????????????????????????
??????????????????????????????????????????????
--Make Your Data Dance.
????????Kamus??
????????????????????????????????
Yunhe Enmo??Beijing??Technology Co.,LTD
????: ??????????????8??????SOHO????B??2108
????: 18010193990
????: kamus@xxxxxxxxxxxx
????: www.enmotech.com
Blog: www.dbform.com
------------------------------------
???????? ??????????
------------------------------------
2015-07-16 13:30 GMT+08:00 feng.chen@xxxxxxxxxxxx <feng.chen@xxxxxxxxxxxx>:
????????????????????X$LOGBUF_READHIST????????????????????LNS??redo log
buffer????????redo??????????????????????????
??View X$LOGBUF_READHIST and In-Memory Log Buffer Hit Rate Histogram (???? ID
951152.1).pdf??
??????????????????????LNS????????redo log
buffer??????????????????????????????????????????
???????? Bin.Liu
?????????? 2015-07-16 00:56
???????? enmotech
?????? [Enmotech]????DG??REDO????????
??~??????????????????????????????.??????????????share????
?? 7??/15/15 17:26, Kamus@Enmotech ????:
Hi lists
???????????????????????????????? Primary??11.2????12.1??????????????????LGWR
ASYNC????????redo??????????Data Guard????????????????????
1.
????????Primary??Standby??????????????????????????????????????Oracle??????????????????????????????DG??????????????????????
??????????REDO????????
2.
??????????????LGWR??????????REDO??????DG??????????????????????????????REDO??????????DG????Standby
Redo Log????????????????????REDO????
3.
????????????????????????????????????REDO??????????????????????????REDO??????????
