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.
|
|
|