Skip Headers

Oracle® Database Advanced Replication Management API Reference
10g Release 1 (10.1)

Part Number B10733-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to current chapter
Up
Go to next page
Next
View PDF

RESUME_SUBSET_OF_MASTERS Procedure

When you add a new master site to a master group by performing an offline instantiation of a master site, it may take some time to complete the offline instantiation process. This procedure resumes replication activity at all existing sites, except the new site, during offline instantiation of a master group. You typically execute this procedure after executing the DBMS_OFFLINE_OG.BEGIN_INSTANTIATION procedure. You must call this procedure from the master definition site.


Note:

This procedure is used to perform an offline instantiation of a master table in a multimaster replication environment.

This procedure should not be confused with the procedures in the DBMS_REPCAT_INSTANTIATE package (used for instantiating a deployment template). See the documentation for this package for more information about its use.


See Also:

"Adding New Master Sites with Offline Instantiation Using Export/Import" for information about adding a new master site to a master group by performing an offline instantiation of a master site

Syntax

DBMS_OFFLINE_OG.RESUME_SUBSET_OF_MASTERS (
   gname     IN  VARCHAR2,
   new_site  IN  VARCHAR2
   override  IN  BOOLEAN := false);

Parameters

Table 15-10 RESUME_SUBSET_OF_MASTERS Procedure Parameters
Parameter Description
gname

Name of the replication 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 replication group.

override

If this is true, then any pending RepCat administrative requests are ignored and normal replication activity is restored at each master as quickly as possible. The override parameter should be set to true only in emergency situations.

If this is false, then normal replication activity is restored at each master only when there is no pending RepCat administrative request for gname at that master.

Exceptions

Table 15-11 RESUME_SUBSET_OF_MASTERS Procedure Exceptions
Exception Description
badargument

NULL or empty string for replication group or new master site name.

dbms_repcat.nonmasterdef

This procedure must be called from the master definition site.

unknownsite

Specified site is not recognized by replication group.

wrongstate

Status of master definition site must be quiesced.

dbms_repcat.missingrepgroup

gname does not exist as a master group.