搭建邏輯Data Guard 12c

hooca發表於2016-06-20
參考：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#;

  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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章