GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

ogg-00446 : golden gate extract error

edited May 19, 2015 11:41PM in GoldenGate, Streams and Distributed Database (MOSC) 5 commentsAnswered

Getting following error when try to start extract process. Pump and Replicate are not yet started.

2015-05-05 16:22:35  ERROR   OGG-00446  error retrieving redo log sequence for begin time 2015-05-05 16:15:51.000000 Not able to establish initial position for begin time 2015-05-05 16:15:51.000000.

ASM connecting string:

TRANLOGOPTIONS ASMUSER sys@ASM, ASMPASSWORD ****

EORA01.PRM:

EXTRACT EORA01

SETENV (ORACLE_SID="oradev_1")

SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0.4/dbhome_1")

USERID ggadmin, PASSWORD ggadmin

TRANLOGOPTIONS ASMUSER sys@ASM, ASMPASSWORD ****

EXTTRAIL ./dirdat/lt

DYNAMICRESOLUTION

TABLE SOURCE.TCUSTMER;

TABLE SOURCE.TCUSTORD;

Archive files are stored in FRA.


Details of 'view report eora01':

CACHEMGR virtual memory values (may have been adjusted)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center