You missed some Downstream archived log?
Is this archived log on Downstream area either it’s not read by Logminer.
Try to run to the hills or read GrepOra posts.
In alert log is tracing like these:
ORA-00317: file type 0 in header is not log file
ORA-00334: archived log: '/oracle/dowstream-archive/2_136361_87643997.dbf'
LOGMINER: Error 317 encountered, failed to read corrupt logfile /oracle/dowstream-archive/2_136361_87643997.dbf
LOGMINER: Encountered error 1291 while adding logfile /oracle/dowstream-archive/2_136361_87643997.dbf to session 1
Copy the archived log from RMAN to Downstream, register logical logfile. Wait for while to Logimer start to provide LCR GoldenGate Integrated Extracts to Logminer new registered archived log.
Try register achived log on Dowstream database as below:
ALTER DATABASE REGISTER LOGFILE '/oracle/dowstream-archive/2_136361_87643997.dbf' FOR 'OGG$CAP_EXT_1';
ALTER DATABASE REGISTER LOGFILE '/oracle/dowstream-archive/2_136361_87643997.dbf' FOR 'OGG$CAP_EXT_2';
#Export ORACLE_SID of container DATABASE, – my Container DB is “cdb01”.
[oracle@greporalab]$ export ORACLE_SID=cdb01
[oracle@greporalab]$ sqlplus / as sysdba
#Change to CONTAINER’s ROOT session.
SQL> alter session set container=CDB$ROOT;
#Create user and ADD Roles.
Now GoldenGate developments is easy friendly.
Cheers for Oracle Demo that include first mapping.
Oracle GoldenGate Studio Highligts:
- Separating Logical from the fisical
- One project contain many solutions
- A Solutions contain one logical design and many Physical Deployments
- You can AUTOMAP table mappings – drag and drop optional columns
- Easy deployments
- Easy to setup DB connections
AYE! GoldenGate 12.3 is now released!
What it brings?
– Support for Oracle Database 22.214.171.124
– Microservices Architecture
– Parallel Replicat
– Automatic Conflict-Detection-Resolution (CDR) without application changes
– Procedural Replication to enable simpler application migrations and upgrades
– Database Sharding
– Fast Start Capture
Let’s test this new features 🙂
GoldenGate Integrated Extract bring some advantages to business and to the administrator.
It also bring new things to Database and DBA 🙂
Have you debug GoldenGate operations on Database?
I have it, so I’ll show the tricks.
After GoldenGate upgrade GoldenGate from 12.1 to 12.2, replicat abend with error:
ERROR OGG-00446 No data selecting position from checkpoint table GGATE.CHECKPOINTTABLE for group ‘R_CRM’, key 2028080425 (0x78e20d29), SQL .
ERROR OGG-01668 PROCESS ABENDING.
It appears replicat is not registered on CHECKPOINTTABLE (is’t true, it’s registered)
As a workaround you can ALTER the replicat to the same checkpoint location when you do an INFO REP , DETAIL and then START.
GGSCI (labp.grepora.net) 27> info R_CRM
REPLICAT R_CRM Last Started 2017-05-09 13:03 Status STOPPED
Checkpoint Lag 00:00:00 (updated 02:40:11 ago)
Log Read Checkpoint File ./dirdat/s5000609
2017-07-04 10:51:44.035765 RBA 98381832
GGSCI (labp.grepora.net) 28> alter R_CRM extseqno 00609 extrba 98381832
2017-07-04 14:44:39 INFO OGG-06594 Replicat R_CRMhas been altered through GGSCI. Even the start up position might be updated, duplicate suppression remains active in next startup. To override duplicate suppression, start R_CRM with NOFILTERDUPTRANSACTIONS option.
GGSCI (labp.grepora.net) 29> start R_CRM
Sending START request to MANAGER ...
REPLICAT R_CRM starting
Having this error? Probably something like this:
ORA-00600: internal error code, arguments: , [0x7F0315C53788], , , , , , , , , , 
This is a known error. The best match on MOS is GoldenGate 12c IntRep Crash W/ ORA-600 [kghfrmrg:nxt] ;ORA-600[kghfrh:ds]; ORA 600 ;  (Doc ID 1666909.1)