Last updated on SEPTEMBER 12, 2015
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2 and laterInformation in this document applies to any platform.
Symptoms
When splitting off an unavailable destination from a Streams configuration, the capture is cloned incorrectly. This results in the capture state similar to 'WAITING FOR DICTIONARY REDO: SCN 2978120959117'.
++ CAPTURE STATISTICS ++
SELECT SUBSTR(s.PROGRAM,INSTR(S.PROGRAM,'(')+1,4) PROCESS_NAME,
c.CAPTURE_NAME,c.STATE
FROM gV$STREAMS_CAPTURE c, gV$SESSION s
WHERE c.SID = s.SID AND c.SERIAL# = s.SERIAL#;
Capture Process: CP03
Capture Name: CLONED$_<CAPTURE_NAME>_<###>
STATE: WAITING FOR DICTIONARY REDO: FIRST SCN 2978120959117
SELECT SUBSTR(s.PROGRAM,INSTR(S.PROGRAM,'(')+1,4) PROCESS_NAME,
c.CAPTURE_NAME,c.STATE
FROM gV$STREAMS_CAPTURE c, gV$SESSION s
WHERE c.SID = s.SID AND c.SERIAL# = s.SERIAL#;
Capture Process: CP03
Capture Name: CLONED$_<CAPTURE_NAME>_<###>
STATE: WAITING FOR DICTIONARY REDO: FIRST SCN 2978120959117
Changes
An unavailable destination has been split from a Streams configuration, this process results in the capture being cloned. When the cloned capture is created this problem can be encountered.
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms