Heim > Datenbank > MySQL-Tutorial > GG做init data load时,报错OGG-01192,OGG-01668

GG做init data load时,报错OGG-01192,OGG-01668

WBOY
Freigeben: 2016-06-07 17:34:12
Original
1324 Leute haben es durchsucht

现象:GG做init data load时,报错OGG-01192,OGG-016682013-11-12 10:43:44 ERROR OGG-01192 Oracle GoldenGate Capture for Or

现象:
GG做init data load时,报错OGG-01192,OGG-01668
2013-11-12 10:43:44 ERROR OGG-01192 Oracle GoldenGate Capture for Oracle, ext2.prm: Trying to use RMTTASK on data types which may be written as LOB chunks (Table: 'PORTAL.UNID_PAPER').
2013-11-12 10:43:44 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext2.prm: PROCESS ABENDING.

extract ext2的配置为:
[oracle@RAC01 ogg]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.5_02 16363018 OGGCORE_11.2.1.0.6_PLATFORMS_130301.1500_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Mar 1 2013 20:01:57

Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved.
GGSCI (RAC01) 1> view param ext2

EXTRACT EXT2
USERID goldengate,password goldengate
RMTHOST 10.0.15.107 , MGRPORT 7839
RMTTASK REPLICAT, GROUP initrep
TABLE PORTAL.*;
GGSCI (RAC01) 2>

分析:
PORTAL.UNID_PAPER表包含有BLOB字段,,不能直接采用init data load的方式。
SQL> desc PORTAL.UNID_PAPER
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ID                                        NOT NULL NUMBER(38)
 SMALL_IMAGE                                        BLOB
 BIG_IMAGE                                          BLOB
 DESCRIPTION                                        VARCHAR2(100)
 
 解决方法:
 采用File to Replicat - Initial Load Techniques。
 The rmtask does not support extraction of LOB or LONG data. As an alternative, see “Loading data from file to Replicat” , use rmtfile instead.
The initial load techniques are available at Doc ID 1441172.1
Goldengate : File to Replicat - Initial Load Techniques

linux

Verwandte Etiketten:
Quelle:php.cn
Erklärung dieser Website
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn
Beliebte Tutorials
Mehr>
Neueste Downloads
Mehr>
Web-Effekte
Quellcode der Website
Website-Materialien
Frontend-Vorlage