OGG进程参数事例

本文深入探讨了数据库管理系统中的关键组件,包括源数据库、远程数据库、管理器、提取和导入过程,以及复制配置。重点阐述了参数设置、工作状态、延迟检查点和时间间隔等核心概念。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

----------------------------------------------------------------------------------------------------------------
Source Database:

GGSCI (ogg1) 46> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                           
EXTRACT     RUNNING     DUMP1       00:00:00      00:00:05    
EXTRACT     RUNNING     EXT1        00:00:00      00:00:08    


MGR:
GGSCI (ogg1) 47> view params mgr
port 7809
DYNAMICPORTLIST 7810-7820
autorestart extract *, retries 5, waitminutes 3
purgeoldextracts ./dirdat/*,usecheckpoints, minkeepdays 10
userid ogg,password ogg

EXT:
GGSCI (ogg1) 48> view params ext1
extract ext1
setenv ( NLS_LANG = AMERICAN_AMERICA.AL32UTF8 )
userid ogg, password ogg
REPORT AT 01:59
reportrollover at 02:00
THREADOPTIONS MAXCOMMITPROPAGATIONDELAY  3000 IOLATENCY 3000
TRANLOGOPTIONS DBLOGREADER,DBLOGREADERBUFSIZE 4096000
TRANLOGOPTIONS BUFSIZE 10000000
discardfile  ./dirrpt/ext1.dsc,append,megabytes 10
exttrail ./dirdat/ee
numfiles 3000
dynamicresolution
STATOPTIONS REPORTFETCH
FETCHOPTIONS SUPPRESSDUPLICATES
table sun.DEPT1;
table sun.EMP1;
table sun.TABLES1;
table sun.INDEXES1;
table sun.test;

DUMP:
GGSCI (ogg1) 50> view params dump1
extract dump1
setenv ( NLS_LANG = AMERICAN_AMERICA.AL32UTF8 )
userid ogg, password ogg
REPORT AT 01:59
reportrollover at 02:00
RMTHOST 10.0.2.12, MGRPORT 7809
RMTTRAIL /ogg/ogghome/dirdat/ee
DYNAMICRESOLUTION
numfiles 3000
table sun.DEPT1;
table sun.EMP1;
table sun.TABLES1;
table sun.INDEXES1;
table sun.test;


-----------------------------------------------------------------------------------------------------------------------------------------
Remote Database:

GGSCI (ogg1) 4> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                           
REPLICAT    RUNNING     REP1        00:00:00      00:00:08    


MGR:
GGSCI (ogg1) 5> view params mgr
port 7809
DYNAMICPORTLIST 7810-7820
autorestart extract *, retries 5, waitminutes 3
purgeoldextracts ./dirdat/*,usecheckpoints, minkeepdays 10
userid ogg,password ogg


REP:
GGSCI (ogg1) 7> view params rep1
REPLICAT rep1
setenv ( NLS_LANG = AMERICAN_AMERICA.AL32UTF8 )
USERID ogg,PASSWORD ogg
SQLEXEC "ALTER SESSION SET CONSTRAINTS=DEFERRED"
REPORT AT 01:59
REPORTROLLOVER AT 02:00
REPERROR DEFAULT,DISCARD
HANDLECOLLISIONS
DISCARDFILE ./dirrpt/rep1.dsc,PURGE
DISCARDROLLOVER AT 02:00
GETTRUNCATES
ASSUMETARGETDEFS
DYNAMICRESOLUTION
ALLOWNOOPUPDATES;
map sun.*, target sun.*;

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值