Hi Folks,
We have a deployment strategy as below.
Break target dataguard setup between server A (primary) and server B (standby).
Configure GoldenGate from Source to target DB on server B (now a stand alone due 1st step).
Complete data migration and enable real time data sync from source to server B
On cutoff, stop replication on Server B. Backup DB on server B and restore on Server A, enable Goldengate replication on Server A.
So in order to achieve this, we need to redirect pump process from server B to server A while the source extract process is still running making sure not to miss data.
Is there any possible way to achieve this?
I've stopped pump process and altered server name for RMTHOST and started it to get the below error.
2016-10-11 06:33:13 INFO OGG-01226 Socket buffer size set to 27985 (flush size 27985).
2016-10-11 06:33:13 WARNING OGG-06590 The output trail file /ogg/ogg12.2/dirdat/pt000000000 is not found, rescan for previous ones.
Source Context :
SourceModule : [er.extract.recovery]
SourceID : [/scratch/aime/adestore/views/aime_adc4150408/oggcore/OpenSys/src/app/er/extract/extrecovery.cpp]
SourceFunction : [recParseLastCommitPos]
SourceLine : [697]
ThreadBacktrace : [12] elements
: [/ogg/ogg12.2/libgglog.so(CMessageContext::AddThreadContext()+0x1b) [0x7f5dd6b65f1b]]
: [/ogg/ogg12.2/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x134) [0x7f5dd6b600a4]]
: [/ogg/ogg12.2/libgglog.so(_MSG_ERR_RECOVERY_SEQLEN_MISMATCH(CSourceContext*, char const*, int, int, CMessageFactory::MessageDisposition)+
0x41) [0x7f5dd6b27606]]
: [/ogg/ogg12.2/extract() [0x5f5c41]]
: [/ogg/ogg12.2/extract(EXTRECOVERY_initialize()+0x2db) [0x5f694b]]
: [/ogg/ogg12.2/extract() [0x5f3d3b]]
: [/ogg/ogg12.2/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x60) [0x6d05b0]]
: [/ogg/ogg12.2/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x14d) [0x6d179d]]
: [/ogg/ogg12.2/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0xb1) [0x6d1881]]
: [/ogg/ogg12.2/extract(main+0x3b) [0x5f50eb]]
: [/lib64/libc.so.6(__libc_start_main+0xfd) [0x32ee01ecdd]]
: [/ogg/ogg12.2/extract() [0x563159]]
2016-10-11 06:33:13 ERROR OGG-06601 Mismatch between the length of seqno from checkpoint (9) and recovery (6) for extract trail /ogg/ogg12.2/dirdat/pt.
2016-10-11 06:33:13 ERROR OGG-01668 PROCESS ABENDING.
Any insights??
Thanks!