ogg同步表

最新推荐文章于 2024-06-05 09:04:18 发布

zhaojian1988

最新推荐文章于 2024-06-05 09:04:18 发布

阅读量1.8k

点赞数

分类专栏： ogg oracle 常用

本文链接：https://blog.youkuaiyun.com/zhaojian1988/article/details/45539139

版权

oracle 常用同时被 2 个专栏收录

45 篇文章

订阅专栏

ogg

7 篇文章

订阅专栏

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.*;

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