Push Replication Group to NORMAL Status in an Exceptional Case

Posted By Sagar Patil

The dbms_repcat.resume_master_activity() package has an override parameter that defaults to FALSE. This parameter can be set to TRUE to allow the
group to become normal even if there are pending admin requests in DBA_REPCATLOG for this group.

This override should ONLY be used in extreme emergency situations, and ONLY when the ramifications and resolution of operating the replicated environment when those pending admin requests have not been applied are fully understood and acceptable. This parameter should not be used until you have contacted Oracle Support Services and addressed the situation. Use of this parameter can result in an invalidation of your replication environment, requiring the environment to be rebuild and / or resynchronised.

Leave a Reply

You must be logged in to post a comment.

Top of Page

Top menu