Name

DBMS_OFFLINE_OG.RESUME_SUBSET_OF_MASTERS

Synopsis

Call this procedure from the master definition site to allow propagation of replication activity among all master sites except the site indicated by the new_site parameter. Upon successful completion, the status of gname is NORMAL in all master sites except for new_site, where the group is still quiesced.

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

Parameters are identical to those given for the BEGIN_INSTANTIATION procedure.

Exceptions

Exception Name

Number

Description

badargument

–23430

Group gname is NULL or ' ‘.

missingrepgroup

–23373

Group gname does not exist.

nonmasterdef

–23312

Routine is not being called from master definition site.

sitealreadyexists

–23432

new_site already exists.

wrongstate

–23431

Group gname is not in NORMAL state at the master definition site.

Restrictions

  • This procedure must be run from the master definition site.

  • Group gname must be in the quiesced state at the master definition site.

Get Oracle Distributed Systems now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial