show config gives the following error
Capture is not yet replicating the most recent activation Re-issue this command when capture's replication is current
The capture process is still processing information based on a previous activation, therefore does not have the current information pertaining to the current activation. This can be caused by:
1. Skipping message in the redo log or moving the seqno / offset for capture within the internal Shareplex database tables.
2. Backlog of messages in the capture queue. Therefore capture is still processing the messages pertaining to the old activation.
3. Incorrect information in the SharePlex internal database tables
This can be fixed by activating the currently active config. This will update the internal SharePlex table (shareplex_actid table) with the current actid and also flush the activation marker to capture, which places a message in the capture queue to update the information in the "show config" output.
sp_ctrl (oel5u7x64:8606)> show config
Capture is not yet replicating the most recent activation
Re-issue this command when capture's replication is current
sp_ctrl (oel5u7x64:8606)> lstatus
System is used as a source machine
Replication Configurations:
Replication active from "chainer_local.conf", actid 40, for sid o.stock1 since 31-Oct-12 04:52:32
sp_ctrl (oel5u7x64:8606)> activate config chainer_local.conf
sp_ctrl (oel5u7x64:8606)> lstatus
System is used as a source machine
Replication Configurations:
Replication active from "chainer_local.conf", actid 41, for sid o.stock1 since 31-Oct-12 04:55:46
sp_ctrl (oel5u7x64:8606)> show config
Tables Replicating with Key:
"KDILLON"."CHAINER" KEY: PK_NUM
Tables Replicating with no key:
"KDILLON"."FOO"
File Name :chainer_local.conf
Datasource :stock1
Activated :31-Oct-12 04:55:46
Actid :41
Total Objects :2
Total Objects Replicating :2
Total Objects Not Replicating :0
View config summary in /splex/vardir/log/stock1_config_log
sp_ctrl (oel5u7x64:8606)>
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center