Identifying the Archivelog, a GoldenGate process is currently using in Oracle

With the Integrated Capture introduced from 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,

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




This entry was posted in Oracle Database, Oracle Golden Gate. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s