RELOCATE_MASTERDEF Procedure

This procedure changes your master definition site to another master site in your replication 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 18-114 RELOCATE_MASTERDEF Procedure Parameters

Parameter	Description
gname	Name of the replication 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. Note: Do not set this parameter unless directed to do so by Oracle Support Services.

Exceptions

Table 18-115 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`.