Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT.RESUME_MASTER_ACTIVITY

Purpose

To resume normal replication activity after quiescing a replicated environment. For additional information, refer to

Syntax

The parameters for the RESUME_MASTER_ACTIVITY procedure are described in Table 12 - 165, and the exceptions are listed in Table 12 - 166. The syntax for this procedure is shown below:

DBMS_REPCAT.RESUME_MASTER_ACTIVITY(
	gname 		IN 	VARCHAR2, 
	override 		IN 	BOOLEAN := FALSE)

Parameter Description
gname The name of the replicated object group.
override If override is TRUE, it ignores any pending RepCat administration requests and restores normal replication activity at each master as quickly as possible. This should be considered only in emergency situations. If override is FALSE, it restores normal replication activity at each master only when there is no pending RepCat administration request for GNAME at that master.

Table 12 - 165. Parameters for RESUME_MASTER_ACTIVITY

Exception Description
nonmasterdef The invocation site is not the master definition site.
notquiesced The replicated object group is not quiescing or quiesced.
commfailure At least one master site is not accessible.

Table 12 - 166. Exceptions for RESUME_MASTER_ACTIVITY

Parameter	Description
`gname`	The name of the replicated object group.
`override`	If override is TRUE, it ignores any pending RepCat administration requests and restores normal replication activity at each master as quickly as possible. This should be considered only in emergency situations. If override is FALSE, it restores normal replication activity at each master only when there is no pending RepCat administration request for GNAME at that master.

Exception	Description
nonmasterdef	The invocation site is not the master definition site.
notquiesced	The replicated object group is not quiescing or quiesced.
commfailure	At least one master site is not accessible.