Database Software

All,

I'm doing testing of Streams in a 10g Rel 2 environment and have some very specific questions about the archive log files that I cannot find answers to in the documentation, Technet or on MetaLink. I have two capture processes on the Source DB server. Both capture processes have the checkpoint_retention_time set = 3 (days). The questions are based on what I am seeing in the DBA_REGISTERED_ARCHIVED_LOG view. In this view I see two row for each registered log file, one for each capture.

Question 1) If the retention period is the same why does the same log file show itself as purgeable for one capture but not the other? The following day the log file shows purgeable for both

Question 2) What exactly drives when purgeable becomes YES? There are several date fields in the view, which one is the driver? Is it 3 days from when the REQUIRED_CHECKPOINT_SCN from DBA_CAPTURE is => to the NEXT_SCN value?

Question 3) The only registered log file that has the LogMiner Data Dictionary now shows as purgeable. If I use RMAN to backup and move offline or delete this log file is there some process that will build a new LogMiner Data Dictionary or do I have to review this manually and make sure I rerun DBMS_CAPTURE_ADM.BUILD before I run RMAN?

If this is all explained in the documentation a reference to which book and chapter would be greatly appreciated. If not, what is your experience with how this works?

Thanks in advance,
Bob S.