ITPub博客

首页 > 数据库 > Oracle > 搭建逻辑Data Guard 12c

搭建逻辑Data Guard 12c

原创 Oracle 作者:hooca 时间:2016-06-20 21:28:30 0 删除 编辑
参考: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. 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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-09-29

  • 博文量
    215
  • 访问量
    401328