ogg同步表

来源：互联网发布：3g模型淘宝编辑：程序博客网时间：2024/06/11 15:33

oracle11.2.0.4

Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100

select * from v$trancation;

1.stop r_bj
2.查看scn
col GET_SYSTEM_CHANGE_NUMBER for 999999999999999999999999
select dbms_flashback.get_system_change_number from dual;

GET_SYSTEM_CHANGE_NUMBER
-------------------------
14115053976261

3.eidt param r_bj
MAP ADMIN.CR_DEVICE_WARE, target SMODEL_BJJ.CR_DEVICE_WARE, filter(@getenv('transaction','csn')>14115053976261);

select count(*) from CR_DEVICE_WARE;

4.impdp导入
drop table CR_DEVICE_WARE purge;
impdp smodel_bjj/ITsp30_smodel directory=dump_dir logfile=CR_DEVICE_WARE.log remap_schema=admin:smodel_bjj network_link='ogglink_bj' REMAP_TABLESPACE=USERS:ITSP_DATA_BJJ FLASHBACK_SCN=14115053976261 TABLES=admin.CR_DEVICE_WARE

GGSCI (rmmodel15) 10> view param r_bj

REPLICAT R_BJ
SETENV (ORACLE_SID = "rmmd08pr1")
SETENV (NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK")
USERID ogg_bj, PASSWORD ogg_bj
ASSUMETARGETDEFS
ALLOWNOOPUPDATES
discardfile ./dirrpt/rs.dsc, purge, megabytes 500

reperror default, discard
discardrollover
STATOPTIONS RESETREPORTSTATS
REPORT AT 00:01
REPORTROLLOVER AT 00:01
REPORTCOUNT EVERY 60 SECONDS, RATE
gettruncates
DDL INCLUDE ALL
--DDL
DDLERROR DEFAULT DISCARD RETRYOP MAXRETRIES 2 RETRYDELAY 5
--MAPEXCLUDE admin.CE_NET_CABLE
--map ADMIN.CM_LINK, target SMODEL_BJJ.CM_LINK, filter(@getenv('transaction','csn')>14115051667610);
--map ADMIN.CE_DEVICE_CONNECT_BJ, target SMODEL_BJJ.CE_DEVICE_CONNECT_BJ, filter(@getenv('transaction','csn')>14115046415828);
--map ADMIN.CE_NET_CABLE, target SMODEL_BJJ.CE_NET_CABLE, filter(@getenv('transaction','csn')>14115046332927);
--MAPEXCLUDE admin.CE_NET_CABLE
--MAPEXCLUDE ADMIN.CE_DEVICE_CONNECT_BJ
--map ADMIN.CE_NET_CABLE, target SMODEL_BJJ.CE_NET_CABLE, filter(@getenv('transaction','csn')>14115046505816);
--MAP admin.CE_NET_CABLE, TARGET smodel_bjj.CE_NET_CABLE , colmap (usedefaults), REPERROR (-01163, IGNORE), FILTER ( @STRLEN(OPTICAL_CABLE_MODEL_ID) < 8, ON INSERT, ON
DELETE, ON UPDATE, RAISEERROR 21002) ,REPERROR (21002, DISCARD),REPERROR (-01163, DISCARD);
--MAP ADMIN.CE_NET_CABLE, TARGET SMODEL_BJJ.CE_NET_CABLE,colmap (USEDEFAULTS, OPTICAL_CABLE_MODEL_ID = OPTICAL_CABLE_MODEL_ID);
--MAPEXCLUDE admin.CE_NET_CABLE
--MAPEXCLUDE admin.CE_NET_CABLE_1
--MAP ADMIN.CM_LINK, target SMODEL_BJJ.CM_LINK, filter(@getenv('transaction','csn')>14115052136461);
--MAPEXCLUDE admin.CM_LINK
--MAP ADMIN.CE_NET_CABLE, target SMODEL_BJJ.CE_NET_CABLE, filter(@getenv('transaction','csn')>14115053424164);
--MAPEXCLUDE admin.CE_NET_CABLE
MAP ADMIN.*, TARGET smodel_bjj.*;

=================================================

0 0