warning Details:
WARNING OGG-02901 Replication of UDT and ANYDATA from redo logs is not su
pported with the Oracle compatible parameter setting. Using fetch instead.
Solution:
Add below parameter to extract process
TRANLOGOPTIONS NOUSENATIVEOBJSUPPORT
==> stop and start extract process:
GGSCI (source.example.com) 23> view report EXTRACT1
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 01:10:08
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
Starting at 2019-06-15 07:02:49
***********************************************************************
Operating System Version:
Linux
Version #2 SMP Mon Sep 24 14:45:01 PDT 2018, Release 4.14.35-1818.3.3.el7uek.x86_64
Node: source.example.com
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 13653
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2019-06-15 07:02:49 INFO OGG-03059 Operating system character set identified as UTF-8.
2019-06-15 07:02:49 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing
.
EXTRACT extract1
USERIDALIAS srcdb DOMAIN admin
2019-06-15 07:02:50 INFO OGG-03522 Setting session time zone to source database time zone
'GMT'.
TRANLOGOPTIONS NOUSENATIVEOBJSUPPORT
EXTTRAIL ./dirdat/aa
TABLE hr.EMPLOYEES;
TABLE hr.DEPARTMENTS;
2019-06-15 07:02:50 INFO OGG-01815 Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ggs/BR/EXTRACT1.
Bounded Recovery Parameter:
BRINTERVAL = 4HOURS
BRDIR = /u01/ggs
2019-06-15 07:02:50 INFO OGG-01851 filecaching started: thread ID: 139794004834048.
2019-06-15 07:02:50 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/u01/ggs/dirtmp.
CACHEMGR virtual memory values (may have been adjusted)
CACHEPAGEOUTSIZE (default): 8M
PROCESS VM AVAIL FROM OS (min): 128G
CACHESIZEMAX (strict force to disk): 96G
Database Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
Database Language and Character Set:
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "WE8MSWIN1252"
2019-06-15 07:02:51 INFO OGG-02248 Logmining server DDL filtering enabled.
2019-06-15 07:02:53 INFO OGG-02068 Integrated capture successfully attached to logmining s
erver OGG$CAP_EXTRACT1 using OGGCapture API.
2019-06-15 07:02:53 INFO OGG-02089 Source redo compatibility version is: 11.2.0.4.0.
2019-06-15 07:02:53 INFO OGG-02086 Integrated Dictionary will be used.
2019-06-15 07:02:53 INFO OGG-01055 Recovery initialization completed for target file ./dir
dat/aa000000003, at RBA 1474.
2019-06-15 07:02:53 INFO OGG-01478 Output file ./dirdat/aa is using format RELEASE 12.2.
2019-06-15 07:02:53 INFO OGG-01026 Rolling over remote file ./dirdat/aa000000003.
2019-06-15 07:02:53 INFO OGG-01053 Recovery completed for target file ./dirdat/aa000000004
, at RBA 1474.
2019-06-15 07:02:53 INFO OGG-01057 Recovery completed for all targets.
***********************************************************************
** Run Time Messages **
***********************************************************************
No comments:
Post a Comment