Hi,
When i check goldengate if it is syncronized or not, I have seen that Goldengate is abended.
details of error are as follows.
Source Context :
SourceModule : [gglib.ggdatasource.DataSource]
SourceID : [/scratch/aime/adestore/views/aime_adc4150330/oggcore/OpenSys/src/gglib/ggdatasource/DataSource.cpp]
SourceFunction : [establishStartPoint]
SourceLine : [175]
ThreadBacktrace : [11] elements
: [/ggateb01/GoldenGate12_2/libgglog.so(CMessageContext::AddThreadContext()+0x1b) [0x7f55b258666b]]
: [/ggateb01/GoldenGate12_2/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x134) [0x7f55b2580734]]
: [/ggateb01/GoldenGate12_2/libgglog.so(_MSG_ERR_CHECKPOINT_GENERIC(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x30)
[0x7f55b256dd09]]
: [/ggateb01/GoldenGate12_2/extract(ggs::gglib::ggdatasource::DataSource::establishStartPoint(time_elt_def&, time_elt_def&)+0xef) [0x88c2ff]]
: [/ggateb01/GoldenGate12_2/extract() [0x5f64d1]]
: [/ggateb01/GoldenGate12_2/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x60) [0x6d3f70]]
: [/ggateb01/GoldenGate12_2/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x14d) [0x
6d51ed]]
: [/ggateb01/GoldenGate12_2/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0xb1) [0x6d52d1]]
: [/ggateb01/GoldenGate12_2/extract(main+0x3b) [0x5f794b]]
: [/lib64/libc.so.6(__libc_start_main+0x100) [0x335421ed20]]
: [/ggateb01/GoldenGate12_2/extract() [0x564899]]
2020-04-29 10:59:38 ERROR OGG-00446 No valid log files for current redo sequence 103693, thread 1, error retrieving redo file name for sequence 103693, archived =
0, use_alternate = 0Not able to establish initial position for begin time 2020-04-29 10:58:58.000000.
2020-04-29 10:59:38 ERROR OGG-01668 PROCESS ABENDING.
If your problem has not solved even if Archivelog exists in the ASM diskgroup, then add the following TRANLOGOPTIONS option into Parameter file to find Archivelog in the Oracle ASM Diskgroup.
You should create goldengate user in the ASM Instance to be connected.
This is the second case for this error.
TRANLOGOPTIONS ASMUSER goldengate@ASM, ASMPASSWORD goldengate123
When I add the following parameter into Parameter file, my problem has been solved.
ASM TNS Alias details are as follows. You should add the ASM Instance TNS entry to the tnsnames.ora as follows.
ASM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.63.34 )(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = +ASM) ) )
If your problem is not related with the ASM Instance and TRANLOGOPTIONS ASMUSER don’t solve your problem, then check the following case.
I have checked related sequence of Archivelog, it exists in the database. If it doesn’t exist, then restore the related archivelogs from backup.
If you don’t know how to restore archivelog from Backup, then read the following article.
https://ittutorial.org/oracle-rman-recovery-manager-restore-recover-tutorials-5-restore-tablespace-archivelog-and-datafile/
If Related archivelog exists and Goldengate still gives same error, then reset Goldengate like following.
GGSCI (MehmetSalih) 15> ALTER EXTRACT EXT01, BEGIN 2019-03-19:16:54:00
EXTRACT altered.
GGSCI (MehmetSalih) 16> info EXT01
EXTRACT EXT01 Initialized 2019-03-19 21:51 Status STOPPED
Checkpoint Lag 04:57:32 (updated 00:00:04 ago)
Log Read Checkpoint Oracle Redo Logs
2019-03-19 16:54:00 Thread 1, Seqno 0, RBA 0
Log Read Checkpoint Oracle Redo Logs
2019-03-19 16:54:00 Thread 2, Seqno 0, RBA 0
Goldengate is reset and I have changed extract process to one minute ago from current time.
Now I have started extract process again like following.
GGSCI (MehmetSalih) 17> start EXT01
Sending START request to MANAGER ...
EXTRACT EXT01 starting
GGSCI (MehmetSalih) 18> info EXT01
EXTRACT EXT01 Initialized 2019-03-19 21:51 Status RUNNING
Checkpoint Lag 04:57:32 (updated 00:00:14 ago)
Log Read Checkpoint Oracle Redo Logs
2019-03-19 16:54:00 Thread 1, Seqno 0, RBA 0
Log Read Checkpoint Oracle Redo Logs
2019-03-19 16:54:00 Thread 2, Seqno 0, RBA 0
GGSCI (MehmetSalih) 19> !
info EXT01
EXTRACT EXT01 Last Started 2019-03-19 21:52 Status RUNNING
Checkpoint Lag 04:58:00 (updated 00:00:01 ago)
Log Read Checkpoint Oracle Redo Logs
2019-03-19 16:54:00 Thread 1, Seqno 254559, RBA 73163792
Log Read Checkpoint Oracle Redo Logs
2019-03-19 16:54:00 Thread 2, Seqno 225018, RBA 90979344
GGSCI (MehmetSalih) 36> !
info *
EXTRACT PUMP01 Last Started 2019-03-19 21:53 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:03 ago)
Log Read Checkpoint File /u01/Goldengate/dirdat/lt059996
2019-03-19 22:04:10.000000 RBA 11741117
EXTRACT EXT01 Last Started 2019-03-19 21:52 Status RUNNING
Checkpoint Lag 00:00:06 (updated 00:00:07 ago)
Log Read Checkpoint Oracle Redo Logs
2019-03-19 22:04:04 Thread 1, Seqno 254588, RBA 8173632
Log Read Checkpoint Oracle Redo Logs
2019-03-19 22:04:06 Thread 2, Seqno 225039, RBA 327184
GGSCI (MehmetSalih) 37>
Goldengate has been syncronized like above.
Do you want to learn Oracle Goldengate, then read the following articles.
https://ittutorial.org/goldengate-tutorials-oracle-for-beginners/