一些注意:逻辑Standby同步不如物理Standby及时,并且收到头几个日志时似乎不会马上Apply,这时需要在主库alter system archive log current几次。
观察Standby:
点击(此处)折叠或打开
-
COLUMN DICT_BEGIN FORMAT A10;
-
SET NUMF 99999999;
-
SELECT FILE_NAME, SEQUENCE# AS SEQ#, FIRST_CHANGE# AS F_SCN#, -
-
NEXT_CHANGE# AS N_SCN#, TIMESTAMP, -
-
DICT_BEGIN AS BEG, DICT_END AS END, -
-
THREAD# AS THR#, APPLIED FROM DBA_LOGSTDBY_LOG -
- ORDER BY SEQUENCE#;
-
-
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