搭建逻辑Data Guard 12c

参考：http://docs.oracle.com/database/121/SBYDB/create_ls.htm#SBYDB4741

一些注意：逻辑Standby同步不如物理Standby及时，并且收到头几个日志时似乎不会马上Apply，这时需要在主库alter system archive log current几次。

观察Standby：

点击(此处)折叠或打开

1. COLUMN DICT_BEGIN FORMAT A10;
   
2. SET NUMF 99999999;
   
3. SELECT FILE_NAME, SEQUENCE# AS SEQ#, FIRST_CHANGE# AS F_SCN#, -
   
4. NEXT_CHANGE# AS N_SCN#, TIMESTAMP, -
   
5. DICT_BEGIN AS BEG, DICT_END AS END, -
   
6. THREAD# AS THR#, APPLIED FROM DBA_LOGSTDBY_LOG -
   
7. ORDER BY SEQUENCE#;
8. 
   
9. FILE_NAME
   --------------------------------------------------------------------------------
        SEQ#    F_SCN#    N_SCN# TIMESTAMP           BEG END      THR# APPLIED
   --------- --------- --------- ------------------- --- --- --------- --------
   /fra/DG/foreign_archivelog/prod/2016_06_20/o1_mf_1_22_cphkvflk_.arc
          22   1939460   1941135 2016-06-20 18:37:39 YES YES         1 CURRENT
   
   
   /fra/DG/foreign_archivelog/prod/2016_06_20/o1_mf_1_23_cphkvfgz_.arc
          23   1941135   1941245 2016-06-20 18:37:36 NO  NO          1 CURRENT
   
   
   /fra/DG/foreign_archivelog/prod/2016_06_20/o1_mf_1_24_cphl1pnn_.arc
          24   1941245   1943556 2016-06-20 18:40:56 NO  NO          1 NO
   
   
   
   
   FILE_NAME
   --------------------------------------------------------------------------------
        SEQ#    F_SCN#    N_SCN# TIMESTAMP           BEG END      THR# APPLIED
   --------- --------- --------- ------------------- --- --- --------- --------
   /fra/DG/foreign_archivelog/prod/2016_06_20/o1_mf_1_25_cphl1w86_.arc
          25   1943556   1943564 2016-06-20 18:41:01 NO  NO          1 NO
   
   
   /fra/DG/foreign_archivelog/prod/2016_06_20/o1_mf_1_26_cphl1v4t_.arc
          26   1943564   1943582 2016-06-20 18:40:59 NO  NO          1 NO
   
   

主要观察APPLIED字段。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22621861/viewspace-2120544/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22621861/viewspace-2120544/