April 1999
Intermediate to advanced
552 pages
15h 39m
English
Content preview from Oracle Distributed Systems
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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.