Replication Management API Reference, 103 of 179

RELOCATE_MASTERDEF procedure

This procedure changes your master definition site to another master site in your replicated environment.

It is not necessary for either the old or new master definition site to be available when you call RELOCATE_MASTERDEF. In a planned reconfiguration, you should invoke RELOCATE_MASTERDEF with NOTIFY_MASTERS set to TRUE and INCLUDE_OLD_MASTERDEF set to TRUE.

Syntax

DBMS_REPCAT.RELOCATE_MASTERDEF (
   gname                  IN   VARCHAR2, 
   old_masterdef          IN   VARCHAR2, 
   new_masterdef          IN   VARCHAR2, 
   notify_masters         IN   BOOLEAN    := TRUE,
   include_old_masterdef  IN   BOOLEAN    := TRUE,
   require_flavor_change  IN   BOOLEAN    := FALSE);

Parameters

Table 8-186 RELOCATE_MASTERDEF Procedure Parameters (Page 1 of 2)

Parameter	Description
gname	Name of the object group whose master definition you want to relocate.
old_masterdef	Fully qualified database name of the current master definition site.
new_masterdef	Fully qualified database name of the existing master site that you want to make the new master definition site.
notify_masters	If this is `TRUE`, then the procedure synchronously multicasts the change to all masters (including `OLD_MASTERDEF` only if `INCLUDE_OLD_MASTERDEF` is `TRUE`). If any master does not make the change, then roll back the changes at all masters. If just the master definition site fails, then you should invoke `RELOCATE_MASTERDEF` with `NOTIFY_MASTERS` set to `TRUE` and `INCLUDE_OLD_MASTERDEF` set to `FALSE`. If several master sites and the master definition site fail, then the administrator should invoke `RELOCATE_MASTERDEF` at each operational master with `NOTIFY_MASTERS` set to `FALSE`.
include_old_ masterdef	If `NOTIFY_MASTERS` is `TRUE` and if `INCLUDE_OLD_MASTERDEF` is also `TRUE`, then the old master definition site is also notified of the change.
require_flavor_ change	This parameter is for internal use only. Do not set this parameter unless directed to do so by Oracle Worldwide Support.

Exceptions

Table 8-187 RELOCATE_MASTERDEF Procedure Exceptions

Exception	Description
nonmaster	`NEW_MASTERDEF` is not a master site or the invocation site is not a master site.
nonmasterdef	`OLD_MASTERDEF` is not the master definition site.
commfailure	At least one master site is not accessible and `NOTIFY_MASTERS` is `TRUE`.