解决方案 »
- 动态执行视图强制创建语句 create or replace force view出现的问题
- ROWNUM的问题
- 关于Vista系统下启动Oracle时的初级问题
- 想给Oracle打补丁,opatch apply问题
- 两个表关联后重复的记录如何只显示一条?
- oracle建表时有没有可视化的工具,如果想设置为自增字段应该如何设置呢?
- oracle8i中重启后management serve就不能用了,为何?
- 在触发器中分割字符串
- Oracle备份问题。
- 用oracle查询数据表t时,为什么加上hometown='浙江省'后,查询速度慢了5分钟呢?详情请看:
- 一个频繁增删的表,如何建立索引,提高查询效率
- killSQL之后不想回滚怎么办
Oracle GoldenGate Capture for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230
Windows (optimized), Oracle 10g on Apr 23 2012 05:59:13Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
Starting at 2014-10-03 10:23:01
***********************************************************************Operating System Version:
Microsoft Windows Server 2003, Enterprise Edition, on x86
Version 5.2 (Build 3790: Service Pack 2)Process id: 5164Description:***********************************************************************
** Running with the following parameters **
***********************************************************************2014-10-03 10:23:01 INFO OGG-03035 Operating system character set identifie
d as GBK. Locale: zh_Hans_CN, LC_ALL:.
EXTRACT extbl
DBOPTIONS ALLOWUNUSEDCOLUMN
USERID GGUSRP, PASSWORD ******2014-10-03 10:23:01 INFO OGG-03500 WARNING: NLS_LANG environment variable d
oes not match database character set, or not set. Using database character set v
alue of ZHS16GBK.
--与数据库字符集一致
SETENV (NLS_LANG="AMERICAN_AMERICA.ZHS16GBK")
Set environment variable (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
SETENV (ORACLE_SID="bslisprd")
Set environment variable (ORACLE_SID=bslisprd)
--捕获Truncate操作,使用ddl时,不能使用此参数
GETTRUNCATES
--每隔1分钟生成统计信息,STATS查看报告使用
REPORTCOUNT EVERY 1 MINUTES, RATE
--最大处理的表的数目
numfiles 5000
--Discard文件,采用append方式,最大1000M
DISCARDFILE ./dirrpt/extbl.dsc, APPEND, MEGABYTES 1000
DISCARDROLLOVER AT 3:00
--每隔3分钟检查大事务,超过2小时的作为大事务进行报告
WARNLONGTRANS 2h,CHECKINTERVAL 3m
EXTTRAIL ./dirdat/et
DYNAMICRESOLUTION
TABLE BSLISPRDCUSR.BLOOD_INFO_LOG, KEYCOLS(XKC00);
TABLE BSLISPRDCUSR.L_DEVICE_REPAIR, KEYCOLS(DEVICEID,LOGDATE,LOGREPAIR,USEER);
TABLE BSLISPRDCUSR.L_DEVICE_USEING, KEYCOLS(DEVICEID,LOGDATE,STATUS,CONCLUSION,U
SEER);
TABLE BSLISPRDCUSR.L_PBBWEEK, KEYCOLS(KSDM,YHDM,PBYF);
TABLE BSLISPRDCUSR.L_REFERENCEVALUE_BAK, KEYCOLS(TESTID,SAMPLETYPE);
TABLE BSLISPRDCUSR.L_REFERENCEVALUE_BAK_1, KEYCOLS(TESTID,SAMPLETYPE,REFAGE);
TABLE BSLISPRDCUSR.L_TEMP, KEYCOLS(TESTID);
TABLE BSLISPRDCUSR.L_TEMPSYXM, KEYCOLS(TESTID,SAMPLETYPE);
--TABLE BSLISPRDCUSR.L_TESTRESULT, KEYCOLS(SAMPLENO,TESTID,SAMPLETYPE,EDITSTATUS
);
TABLE BSLISPRDCUSR.OSS_CERTIFICATE_REQUESTS, KEYCOLS(CERTIFICATE_REQUEST_ID);
TABLE BSLISPRDCUSR.OSS_CERTIFICATE_REQUEST_STATUS, KEYCOLS(STATUS_ID,STATUS_NAME
);
TABLE BSLISPRDCUSR.OSS_ENCR_TRUSTPOINTS, KEYCOLS(T_ID,SUBJECT_ID);
TABLE BSLISPRDCUSR.OSS_OWNER_TYPES, KEYCOLS(OWNER_TYPE_ID,OWNER_TYPE_NAME);
TABLE BSLISPRDCUSR.OSS_SUBJECT_TYPES, KEYCOLS(SUBJECT_TYPE_ID,SUBJECT_TYPE_NAME)
;
TABLE BSLISPRDCUSR.PLAN_TABLE, KEYCOLS(STATEMENT_ID);
TABLE BSLISPRDCUSR.PLUS, KEYCOLS(HN);
TABLE BSLISPRDCUSR.PROP, KEYCOLS(MODL,SUBM);
TABLE BSLISPRDCUSR.RGHT, KEYCOLS(CLSS);
TABLE BSLISPRDCUSR.RPTS, KEYCOLS(RPRT);
TABLE BSLISPRDCUSR.SJ_CSXX, KEYCOLS(SJID,CSID);
TABLE BSLISPRDCUSR.SJ_DYXM, KEYCOLS(SJID,TESTID);
TABLE BSLISPRDCUSR.SJ_GYSXX, KEYCOLS(SJID,GYSID);
TABLE BSLISPRDCUSR.SJ_PD01, KEYCOLS(PDDH,PDRQ,CZGH);
TABLE BSLISPRDCUSR.SJ_PD02, KEYCOLS(JLXH,PDDH,SJID,KCSL,PDSL);
TABLE BSLISPRDCUSR.SJ_TMXX, KEYCOLS(RKID,SJID,DYRQ,BARCODE);
TABLE BSLISPRDCUSR.SMCLIQUE, KEYCOLS(CLIQUEID);
TABLE BSLISPRDCUSR.VLIS_HYXM, KEYCOLS(HYID,HYXM,KSDM);
TABLE bslisprdcusr.*;2014-10-03 10:23:01 INFO OGG-01815 Virtual Memory Facilities for: BR
anon alloc: MapViewOfFile anon free: UnmapViewOfFile
file alloc: MapViewOfFile file free: UnmapViewOfFile
target directories:
E:\ggsprdc\BR\EXTBL.Bounded Recovery Parameter:
Options = BRRESET
BRINTERVAL = 4HOURS
BRDIR = E:\ggsprdc2014-10-03 10:23:01 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: MapViewOfFile anon free: UnmapViewOfFile
file alloc: MapViewOfFile file free: UnmapViewOfFile
target directories:
E:\ggsprdc\dirtmp.CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE: 1G
CACHEPAGEOUTSIZE (normal): 4M
PROCESS VM AVAIL FROM OS (min): 1.57G
CACHESIZEMAX (strict force to disk): 1.41GDatabase Version:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - ProductionDatabase Language and Character Set:
NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK"
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "ZHS16GBK"2014-10-03 10:23:01 WARNING OGG-01423 No valid default archive log destination
directory found for thread 1.2014-10-03 10:23:01 INFO OGG-01513 Positioning to Sequence 525, RBA 2018254
4, SCN 0.1426831.2014-10-03 10:23:01 INFO OGG-01516 Positioned to Sequence 525, RBA 20182544
, SCN 0.1426831, 2014-10-3 上午10:22:36.2014-10-03 10:23:01 INFO OGG-01055 Recovery initialization completed for ta
rget file ./dirdat/et000007, at RBA 1080.2014-10-03 10:23:01 INFO OGG-01478 Output file ./dirdat/et is using format
RELEASE 11.2.2014-10-03 10:23:01 INFO OGG-01026 Rolling over remote file ./dirdat/et0000
07.2014-10-03 10:23:01 INFO OGG-01053 Recovery completed for target file ./dir
dat/et000008, at RBA 1080.2014-10-03 10:23:01 INFO OGG-01057 Recovery completed for all targets.***********************************************************************
** Run Time Messages **
***********************************************************************
2014-10-03 10:23:01 INFO OGG-01517 Position of first record processed Seque
nce 525, RBA 20182544, SCN 0.1426831, 2014-10-3 上午10:22:36.