The following messages are seen in sp_ctrl interface when trying to activate a config with a "live" option:
sp_ctrl> activate config <config_name> live
WARNING, not all objects activated successfully. Check activation log.'
The activation log (*rmp* log) shows a table failing with ORA-1562:
.
.
[4] 05/07 16:14:00 Analyze failed for "owner"."table_name" with ORA-1562
[4] 05/07 16:14:00 NOT replicating "owner"."table_name" (209 out of 299
complete)
.
.
Â
Inadequate sizing of rollback segments.
During a busy time on source database, if live activation is performed, tables can fail with ORA-1562. This is due to more schema components added to rollback segment space than they can fit. Activate the failed tables once again or activate them during lean period. Since this is live activation which is typically performed during the composite tasks of first time sync and activation, the target can wait and be recovered once the activation completes on source for all tables.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center