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
.
.
.
