Error Starting GG Extract Using ADG Database. (Doc ID 2210263.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.1.5 and later
Information in this document applies to any platform.

Goal

 User was trying a ADG mining with below params but filing:

 

EXTRACT eiad1ir
SETENV (ORACLE_HOME = "/u01/app/oracle/product/12.1.0.2/dbhome_1")
USERIDALIAS ggextract@IPRDAPP_DG
TRANLOGOPTIONS MINEFROMACTIVEDG
RMTHOST rmt.serv, mgrport 9002
RMTTRAIL ./dirdat/wert/rt
TABLE XXXX.*;

2016-11-23 15:49:23 INFO OGG-01515 Positioning to begin time Nov 23, 2016 3:49:11 PM.

Source Context :
SourceModule : [er.common]
SourceID : [/scratch/mmar/view_storage/mmar_20635622_sparc/oggcore/OpenSys/src/app/er/common.cpp]
SourceFunction : [extract_start_point]
SourceLine : [2429]

2016-11-23 15:49:46 ERROR OGG-00446 error 2 (No such file or directory) opening redo log +DATA_AV2/IPRDAPP_DG/ONLINELOG/group_13.283.919118071 for sequence 1275Not able to establish initial position for begin time 2016-11-23 15:49:11.000000.

2016-11-23 15:49:46 ERROR OGG-01668 PROCESS ABENDING.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms