Situation:
Mirroring failed. It is a bookmarking method. The error messages are as following:
I referred to the IBM support website. (InfoSphere Change Data Capture for Oracle Replication - A fatal error has been encountered while processing a redo log...Redo log file information not found. (ibm.com))
- Verify if this redo log exists or not
select name, thread#, sequence#, status, first_time, next_time,
first_change#, next_change#
from gv$archived_log
where 51575650509 between first_change# and next_change#;
Yes. It exists.
- Verify that you have no aged/orphaned transactions in the database for
this SCN 51575650509. If there are any consider ending these transactions.
SELECT START_DATE,START_TIME,TO_CHAR(START_SCN),START_SCNB,XID
FROM V$TRANSACTION ORDER BY START_DATE, START_TIME;
There is no transaction.
- If you have Test subscriptions or tables which are not currently
being mirrored and are in a Mirror/Park status these should be set to
Refresh/Park
All subscriptions are in method mirror and status active.
Refresh is not an option for my case. The database user have "alter any table" privileges. Anyone know about this issues? Please help me if anyone have any idea. Thank you.
------------------------------
dataicons
------------------------------
#DataIntegration#DataReplication