Home » Server Options » Replication » ogg-00446 : golden gate extract error (Golden Gate)
ogg-00446 : golden gate extract error [message #637037] Thu, 07 May 2015 16:24
jayeshkgarg@yahoo.com
Messages: 1
Registered: May 2015
Junior Member
This question is Not Answered.(Mark as assumed answered)
2913088
Newbie
2913088 May 7, 2015 11:36 AM
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)
CACHESIZE: 64G
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"


Maximum supported ASM read buffer size is 4096 KB


Maximum supported ASM read buffer size is 4096 KB


2015-05-05 16:22:13 INFO OGG-00546 Default thread stack size: 8388608.


2015-05-05 16:22:13 INFO OGG-01515 Positioning to begin time May 5, 2015 4:15:51 PM.


2015-05-05 16:22:15 INFO OGG-01516 Positioned to (Thread 1) Sequence 31, RBA 8467968, SCN 0.0, May 5, 2015 4:15:51 PM.


2015-05-05 16:22:15 INFO OGG-01515 Positioning to begin time May 5, 2015 4:15:51 PM.


Source Context :
SourceModule : [er.common]
SourceID : [/scratch/aime1/adestore/views/aime1_adc4150384/oggcore/OpenSys/src/app/er/common.cpp]
SourceFunction : [extract_start_point]
SourceLine : [2394]
ThreadBacktrace : [11] elements
: [/dev/shm/GGEXTR/GG/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7f3371cf4dce]]
: [/dev/shm/GGEXTR/GG/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x340) [0x7f3371cefae0]]
: [/dev/shm/GGEXTR/GG/libgglog.so(_MSG_ERR_CHECKPOINT_GENERIC(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x31) [0x7f3371cda991]]
: [/dev/shm/GGEXTR/GG/extract(extract_start_point(time_elt_def*, time_elt_def*)+0x118) [0x5864a8]]
: [/dev/shm/GGEXTR/GG/extract(extract_main(int, char**)+0x2c3) [0x5b6953]]
: [/dev/shm/GGEXTR/GG/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x4f) [0x6a1e2f]]
: [/dev/shm/GGEXTR/GG/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x104) [0x6a2334]]
: [/dev/shm/GGEXTR/GG/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x8b) [0x6a26fb]]
: [/dev/shm/GGEXTR/GG/extract(main+0x3f) [0x5b643f]]
: [/lib64/libc.so.6(__libc_start_main+0xf4) [0x3d0561d994]]
: [/dev/shm/GGEXTR/GG/extract [0x52ad09]]


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


2015-05-05 16:22:35 ERROR OGG-01668 PROCESS ABENDING.
Previous Topic: OGG start PUMP after SCN
Next Topic: OGG archive log only - log compatibility
Goto Forum:
  


Current Time: Tue Nov 21 06:11:03 CST 2017

Total time taken to generate the page: 0.01674 seconds