Database Software

Dear Team,

I am very newer in Golden Gate. Going thru with the blog and trying to learn.

http://www.pythian.com/news/7959/oracle-goldengate-installation-part-1/

I was trying to extract from the Oracle tables at the time of extraction
it’s giving error which are:-

1. 2011-02-01 10:20:16 ERROR OGG-00685 begin time Jan 28, 2011 1:48:12 PM prior to oldest log in log history. Last SQL executed <SELECT 1 FROM dual WHERE TO_DATE(:begin_time,'YYYY-MM-DD HH24:MI:SS') < (SELECT MIN(first time) FROM v$log_history WHERE thread# = :ora_thread)>.

2. 2011-02-01 10:20:16 ERROR OGG-01668 PROCESS ABENDING.

Configuration details are available in detail in Ext1.rpt. Please provide the solution for the same.

Thanks & Regards
______________________________________________________
Pramod Gaikwad


log file details are:-


***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 11.1.1.0.0 Build 078
Windows (optimized), Oracle 10 on Jul 28 2010 15:50:58

Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.


Starting at 2011-02-01 10:20:14
***********************************************************************

Operating System Version:
Microsoft Windows XP Professional, on x86
Version 5.1 (Build 2600: Service Pack 3)

Process id: 1064

Description:

***********************************************************************
** Running with the following parameters **
***********************************************************************
extract ext1

userid ggate, password ********

rmthost INFVA04159.vshodc.lntinfotech.com, mgrport 7809

rmttrail /goldenGate/dirdat

ddl include mapped objname sender.*;

table sender.*;


2011-02-01 10:20:14 INFO OGG-01635 BOUNDED RECOVERY: reset to initial or altered checkpoint.

Bounded Recovery Parameter:
Options = BRRESET
BRINTERVAL = 4HOURS
BRDIR = C:\GoldenGate

CACHEMGR virtual memory values (may have been adjusted)
CACHEBUFFERSIZE: 64K
CACHESIZE: 1G
CACHEBUFFERSIZE (soft max): 4M
CACHEPAGEOUTSIZE (normal): 4M
PROCESS VM AVAIL FROM OS (min): 1.81G
CACHESIZEMAX (strict force to disk): 1.59G

Database Version:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

Database Language and Character Set:
NLS_LANG environment variable specified has invalid format, default value will be used.
NLS_LANG environment variable not set, using default value AMERICAN_AMERICA.US7ASCII.
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "WE8MSWIN1252"

Warning: your NLS_LANG setting does not match database server language setting.
Please refer to user manual for more information.

2011-02-01 10:20:15 WARNING OGG-01423 No valid default archive log destination directory found for thread 1.

2011-02-01 10:20:15 INFO OGG-01515 Positioning to begin time Jan 28, 2011 1:48:12 PM.

Source Context :
SourceModule : [er.redo.ora.metathr]
SourceID : [er/redo/oracle/ocimetathr.c]
SourceFunction : [OCIMETATHR_get_sequence]
SourceLine : [771]

2011-02-01 10:20:16 ERROR OGG-00685 begin time Jan 28, 2011 1:48:12 PM prior to oldest log in log history. Last SQL executed <SELECT 1 FROM dual WHERE TO_DATE(:begin_time,'YYYY-MM-DD HH24:MI:SS') < (SELECT MIN(first_time) FROM v$log_history WHERE thread# = :ora_thread)>.

2011-02-01 10:20:16 ERROR OGG-01668 PROCESS ABENDING.

Edited by: user2855889 on Feb 1, 2011 1:33 AM