SPECIFY_NEW_MASTERS Procedure

This procedure specifies the master sites you intend to add to an existing replication group without quiescing the group. This procedure must be run at the master definition site of the specified master group.

If necessary, this procedure creates an extension_id that tracks the process of adding new master sites to a master group. You use this extension_id in the other procedures that you run at various stages in the process. You can view information about the extension_id in the DBA_REPSITES_NEW and DBA_REPEXTENSIONS data dictionary views.

This procedure adds the new master sites to the DBA_REPSITES_NEW data dictionary view for the specified replication group. This procedure can be run any number of times for a given replication group. If it is run more than once, then it replaces any masters in the local DBA_REPSITES_NEW data dictionary view for the specified replication group with the masters specified in the master_list/master_table parameters.

You must run this procedure before you run the ADD_NEW_MASTERS procedure. No new master sites are added to the master group until you run the ADD_NEW_MASTERS procedure.

See Also:

"ADD_NEW_MASTERS Procedure"
"Adding New Master Sites" for more information about adding master sites to a master group

Syntax

DBMS_REPCAT.SPECIFY_NEW_MASTERS (
   gname           IN    VARCHAR2,
   { master_list   IN    VARCHAR2 
 | master_table  IN   DBMS_UTILITY.DBLINK_ARRAY});

Note:

This procedure is overloaded. The master_list and master_table parameters are mutually exclusive.

Parameters

Table 18-130 SPECIFY_NEW_MASTERS Procedure Parameters

Parameter Description

Parameter	Description
gname	Master group to which you are adding new master sites.
master_list	A comma-delimited list of new master sites that you want to add to the master group. List only the new master sites, not the existing master sites. Do not put any spaces between site names. If `master_list` is `NULL`, all master sites for the given replication group are removed from the `DBA_REPSITES_NEW` data dictionary view. Specify `NULL` to indicate that the master group is not being extended.
master_table	A table that lists the new master sites that you want to add to the master group. In the table, list only the new master sites, not the existing master sites. The first master site should be at position 1, the second at position 2, and so on. If the table is empty, then all master sites for the specified replication group are removed from the `DBA_REPSITES_NEW` data dictionary view. Use an empty table to indicate that the master group is not being extended.

gname

Master group to which you are adding new master sites.

master_list

A comma-delimited list of new master sites that you want to add to the master group. List only the new master sites, not the existing master sites. Do not put any spaces between site names.

If master_list is NULL, all master sites for the given replication group are removed from the DBA_REPSITES_NEW data dictionary view. Specify NULL to indicate that the master group is not being extended.

master_table

A table that lists the new master sites that you want to add to the master group. In the table, list only the new master sites, not the existing master sites. The first master site should be at position 1, the second at position 2, and so on.

If the table is empty, then all master sites for the specified replication group are removed from the DBA_REPSITES_NEW data dictionary view. Use an empty table to indicate that the master group is not being extended.

Exceptions

Table 18-131 SPECIFY_NEW_MASTERS Procedure Exceptions

Exception	Description
duplicaterepgroup	A master site that you are attempting to add is already part of the master group.
nonmasterdef	Invocation site is not the master definition site.
propmodenotallowed	Synchronous propagation mode not allowed for this operation. Only asynchronous propagation mode is allowed.
extstinapp	Extension request with status not allowed. There must either be no `extension_id` for the master group or the `extension_id` status must be `READY`. You can view the status for each `extension_id` at a master site in the `DBA_REPEXTENSIONS` data dictionary view.
dbnotcompatible	Feature is incompatible with database version. All databases must be at 9.0.1 or higher compatibility level.
notsamecq	Master groups do not have the same connection qualifier.