I have a downstream Streams replication set up between Oracle 9i (source) and Oracle 11g (destination). The process is still in developlment stage, so the whole setup is not stable yet.

Sometimes my apply procedure at destination database fails. Say, with a error like this:

APPLY_NAME                     STATUS   RULE_SET_NAME                  ERROR_MESSAGE
------------------------------ -------- ------------------------------ ----------------------------------------
DWH_APPLY_SUN                  ABORTED  RULESET_APPLY_LCR_SUN          ORA-26808: Apply process AS0K died unexp
                                                                       ORA-25455: evaluation error for rule set
                                                                       : STRMADMIN.RULESET_APPLY_LCR_SUN, evalu
                                                                       ation context: SYS.STREAMS$_EVALUATION_C
                                                                       ORA-00600: internal error code, argument
                                                                       s: [knlqany2lcr235], [22629], [ORA-22629
                                                                       : OCIAnyData is null
                                                                       ], [], [], [], [], [], [], [], [], []

I need to know the last source database SCN it was able to apply before failing.

DBA_APPLY.MAX_APPLIED_MESSAGE_NUMBER shows me something only in case apply process is stopped normally.

Any ideas?

1 Answer 1


Found it.

Low-Watermark and High-Watermark for an Apply Process

The low-watermark for an apply process is the system change number (SCN) up to which all LCRs have been applied. That is, LCRs that were committed at an SCN less than or equal to the low-watermark number have definitely been applied, but some LCRs that were committed with a higher SCN also might have been applied. The low-watermark SCN for an apply process is equivalent to the applied SCN for a capture process.

The high-watermark for an apply process is the SCN beyond which no LCRs have been applied. That is, no LCRs that were committed with an SCN greater than the high-watermark have been applied.

You can view the low-watermark and high-watermark for one or more apply processes by querying the V$STREAMS_APPLY_COORDINATOR and ALL_APPLY_ PROGRESS data dictionary views.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.