The Copy results in “Capture is not yet replicating the most recent activation Re-issue this command when capture's replication is current” (4330465)

When copy is issued, it exits with the following messages:

sp_ctrl>copy "OWNER"."TABLE_NAME"

   Capture is not yet replicating the most recent activation

   Re-issue this command when capture's replication is current

Capture is behind Oracle and there is another activation command issued during the time Capture is behind. So you will need to let Capture catch up with Oracle and then re-issue the command. The following illustrates how to determine if the Capture is behind Oracle. You can issue “show capture detail” to get stats on current redo log being processed by Oracle (termed here as “Oracle current redo log”) and the current redo log being processed by Capture (termed here as “Capture current redo log”). As you can see, Capture is behind Oracle by 20 logs in this example. Once both these values are identical or very close, you should be able to issue the Copy. Here is the command shown for single instance Oracle:        

sp_ctrl> show capture detail

Host: hostname

                           Operations

Source     Status            Captured Since

---------- --------------- ---------- ------------------

o.sourceSID Running                  0 10-Oct-07 05:02:07

   Oracle current redo log          : 100

   Capture current redo log         : 80

.

.

.