Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Capture process is not mining online log

joelsMar 15 2011 — edited Mar 17 2011

Hi all,

I configured streams replication but one of the DB's capture process is not working properly.
The status was 'WAITING FOR REDO: LAST SCN MINED', then I tested the streams by updating a record in the replicated table and status went back to 'WAITING FOR REDO: LAST SCN MINED'.

After much investigation, I think i know what's the cause.
the capture process is not mining the online redo log. I know this because the last line of the alert logs is

LOGMINER: End mining logfile: /oracle/flash_recovery_area/LASSTREAM/archivelog/2011_03_15/o1_mf_1_16_6qy863kd_.arc

Whereas the other database's alert log is showing

LOGMINER: Begin mining logfile for session 1 thread 1 sequence 6, /oradata/LASTEST/redo/redo03.log

Anyone knows how to make the capture process mines the online redo log as well?

Thanks.
-Joel

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 14 2011

Added on Mar 15 2011

#performance-availability, #streams

4 comments

711 views