设为首页 加入收藏

TOP

UseGoldengateInitialDataLoad(二)
2015-07-24 10:51:41 来源: 作者: 【 】 浏览:2
Tags:UseGoldengateInitialDataLoad
mory Facilities for: COM anon alloc: mmap(MAP_ANON) anon free: munmap file alloc: mmap(MAP_SHARED) file free: munmap target directories: /ogg/dirtmp. 2015-02-27 02:18:29 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, initload.prm: EXTRACT INITLOAD started.
查看抽取情况:

GGSCI (zbdba1) 18> info initload

EXTRACT    INITLOAD  Last Started 2015-02-27 02:18   Status RUNNING
Checkpoint Lag       Not Available
Log Read Checkpoint  Table ZBDBA.TEST
                     2015-02-27 02:19:25  Record 43671
Task                 SOURCEISTABLE


GGSCI (zbdba1) 19> info initload

EXTRACT    INITLOAD  Last Started 2015-02-27 02:18   Status RUNNING
Checkpoint Lag       Not Available
Log Read Checkpoint  Table ZBDBA.TEST
                     2015-02-27 02:19:35  Record 54025
Task                 SOURCEISTABLE


GGSCI (zbdba1) 20> !  
info initload

EXTRACT    INITLOAD  Last Started 2015-02-27 02:18   Status STOPPED
Checkpoint Lag       Not Available
Log Read Checkpoint  Table ZBDBA.TEST
                     2015-02-27 02:20:16  Record 86315
Task                 SOURCEISTABLE
发现已抽取完成

target:
查看日志:

2015-02-27 02:18:54  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, repload.prm:  REPLICAT REPLOAD starting.
2015-02-27 02:18:54  INFO    OGG-03035  Oracle GoldenGate Delivery for Oracle, repload.prm:  Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2015-02-27 02:18:55  INFO    OGG-01815  Oracle GoldenGate Delivery for Oracle, repload.prm:  Virtual Memory Facilities for: COM
    anon alloc: mmap(MAP_ANON)  anon free: munmap
    file alloc: mmap(MAP_SHARED)  file free: munmap
    target directories:
    /ogg/dirtmp.
2015-02-27 02:18:55  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, repload.prm:  REPLICAT REPLOAD started.
2015-02-27 02:18:59  WARNING OGG-00869  Oracle GoldenGate Delivery for Oracle, repload.prm:  No unique key is defined for table 'TEST'. All viable columns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be used to define the key.
2015-02-27 02:20:21  INFO    OGG-00994  Oracle GoldenGate Delivery for Oracle, repload.prm:  REPLICAT REPLOAD stopped normally.

发现repload进程已经自动启动并且复制完毕自动停止了。

查看 数据库表:

SQL> select count(1) from test;

  COUNT(1)
----------
     86315

已经完成初始化






首页 上一页 1 2 下一页 尾页 2/2/2
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇机房重构――视图 下一篇sql*loader的实验一

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

·Libevent C++ 高并发 (2025-12-26 00:49:30)
·C++ dll 设计接口时 (2025-12-26 00:49:28)
·透彻理解 C 语言指针 (2025-12-26 00:22:52)
·C语言指针详解 (经典 (2025-12-26 00:22:49)
·C 指针 | 菜鸟教程 (2025-12-26 00:22:46)