Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_OFFLINE_OG.RESUME_SUBSET_OF_MASTERS

Purpose

To resume replication activity at all existing sites except the new site during offline instantiation of a replicated object group. You must call this procedure from the master definition site. For additional information, refer to

Syntax

The parameters for the RESUME_SUBSET_OF_MASTERS procedure are described in Table 12 - 46, and the exceptions are listed in Table 12 - 47. The syntax for this procedure is shown below.

DBMS_OFFLINE_OG.RESUME_SUBSET_OF_MASTERS( 
     gname     IN  VARCHAR2,
     new_site  IN  VARCHAR2)

Parameter Description
gname The name of the object group that you are replicating to the new site.
new_site The fully qualified database name of the new site to which you are replicating the object group.

Table 12 - 46. Parameters for RESUME_SUBSET_OF_MASTERS

Exception Description
23430 badargument Null or empty string for object group or new master site name.
nonmasterdef This procedure must be called from the master definition site.
23434 unknownsite Given site is not recognized by object group.
23431 wrongstate Status of master definition site must be QUIESCED.
missingrepgroup GNAME does not exist as a replicated object group.

Table 12 - 47. Exceptions for RESUME_SUBSET_OF_MASTERS

Parameter	Description
`gname`	The name of the object group that you are replicating to the new site.
`new_site`	The fully qualified database name of the new site to which you are replicating the object group.

Exception	Description
23430 badargument	Null or empty string for object group or new master site name.
nonmasterdef	This procedure must be called from the master definition site.
23434 unknownsite	Given site is not recognized by object group.
23431 wrongstate	Status of master definition site must be QUIESCED.
missingrepgroup	GNAME does not exist as a replicated object group.