With the Integrated Capture introduced from 188.8.131.52 version, Oracle GoldenGate uses LogMiner to capture the data from the Database. So, the LogMining actually will be performed by reading the archivelog files. So, it is very important to have idea on the steps to identify the Archivelog that is currently being used by Capture process. Below are the details,
- Issue the command “info extract <extract_name>, showch
- This command gives the details of Recovery Check point, meaning, the position of oldest Unprocessed Transaction in Database.
Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
Timestamp: 2017-01-30 06:36:14.000000
SCN: 2449.173246264 (10518548154168)
2. The SCN (System Change Number) in the above o/p is “10518548154168″
3. Consider the above mentioned SCN # and query “v$archived_log” table to get the details of Archivelog in use,
set pagesize 200
set lines 200
set long 200
col first_change# for 9999999999
col next_change# for 9999999999
alter session set nls_date_format=’DD-MON-RRRR HH24:MI:SS’;
select name, thread#, sequence#, status, first_time, next_time, first_change#, next_change# from v$archived_log where 10518548154168 between first_change# and next_change#;
The o/p of the above statement provides the details of Archivelog in use.