Oracle8i Supplied Packages Reference
Release 8.1.5
A68001-01

Library
Product
Contents
Index

Prev Next

21
DBMS_OFFLINE_OG

The DBMS_OFFLINE_OG package contains public APIs for offline instantiation of master groups.

Note:

These procedures are used in performing an offline instantiation of a master table in a multimaster replication environment.

These procedure should not be confused with the procedures in the DBMS_OFFLINE_SNAPSHOT package (used for performing an offline instantiation of a snapshot) or with the procedures in the DBMS_REPCAT_INSTANTIATE package (used for instantiating a deployment template). See these respective packages for more information on their usage.  

Summary of Subprograms

Table 21-1 DBMS_OFFLINE_OG Package Subprograms
Subprogram  Description  
BEGIN_INSTANTIATION 
procedure
 

Starts offline instantiation of a replicated object group.  

 
BEGIN_LOAD procedure
 

Disables triggers while data is imported to new master site as part of offline instantiation.  

 
END_INSTANTIATION 
procedure
 

Completes offline instantiation of a replicated object group.  

 
END_LOAD procedure
 

Re-enables triggers after importing data to new master site as part of offline instantiation.  

 
RESUME_SUBSET_OF_MASTERS 
procedure
 

Resumes replication activity at all existing sites except the new site during offline instantiation of a replicated object group.  

BEGIN_INSTANTIATION procedure

This procedure starts offline instantiation of a replicated master group. You must call this procedure from the master definition site.

Syntax

DBMS_OFFLINE_OG.BEGIN_INSTANTIATION (
   gname     IN   VARCHAR2,
   new_site  IN   VARCHAR2,
   fname     IN   VARCHAR2);

Parameters

Table 21-2 BEGIN_INSTANTIATION Procedure Parameters
Parameter  Description  
gname
 

Name of the object group that you want to replicate to the new site.  

 
new_site
 

The fully qualified database name of the new site to which you want to replicate the object group.  

 
fname
 

This system parameter is for internal use only. Do not set the parameter unless so directed by Oracle Worldwide Support.  

Exceptions

Table 21-3 BEGIN_INSTANTIATION Procedure Exceptions
Exception  Description  
badargument
 

NULL or empty string for object group or new master site name.  

 
dbms_repcat. 
nonmasterdef
 

This procedure must be called from the master definition site.  

 
sitealreadyexists
 

Given site is already a master site for this object group.  

 
wrongstate
 

Status of master definition site must be QUIESCED.  

 
dbms_repcat. 
missingrepgroup
 

gname does not exist as a replicated master group.  

 
dbms_repcat.missing_
flavor
 

If you receive this exception, contact Oracle Worldwide Support.  

BEGIN_LOAD procedure

This procedure disables triggers while data is imported to new master site as part of offline instantiation. You must call this procedure from the new master site.

Syntax

DBMS_OFFLINE_OG.BEGIN_LOAD (
   gname     IN   VARCHAR2,
   new_site  IN   VARCHAR2);

Parameters

Table 21-4 BEGIN_LOAD Procedure Parameters
Parameter  Description  
gname
 

Name of the object group whose members you are importing.  

 
new_site
 

The fully qualified database name of the new site at which you will be importing the object group members.  

Exceptions

Table 21-5 BEGIN_LOAD Procedure Exceptions
Exception  Description  
badargument
 

Null or empty string for object group or new master site name.  

 
wrongsite
 

This procedure must be called from the new master site.  

 
unknownsite
 

Given site is not recognized by object group.  

 
wrongstate
 

Status of the new master site must be QUIESCED.  

 
dbms_repcat. 
missingrepgroup
 

gname does not exist as a replicated master group.  

END_INSTANTIATION procedure

This procedure completes offline instantiation of a replicated master group. You must call this procedure from the master definition site.

Syntax

DBMS_OFFLINE_OG.END_INSTANTIATION (
   gname     IN  VARCHAR2,
   new_site  IN  VARCHAR2);

Parameters

Table 21-6 END_INSTANTIATION Procedure Parameters
Parameter  Description  
gname
 

Name of the object group that you are replicating to the new site.  

 
new_site
 

The fully qualified database name of the new site to which you are replicating the object group.  

Exceptions

Table 21-7 END_INSTANTIATION Procedure Exceptions
Exception  Description  
badargument
 

Null or empty string for object group or new master site name.  

 
dbms_repcat. 
nonmasterdef
 

This procedure must be called from the master definition site.  

 
unknownsite
 

Given site is not recognized by object group.  

 
wrongstate
 

Status of master definition site must be QUIESCED.  

 
dbms_repcat. 
missingrepgroup
 

gname does not exist as a replicated master group.  

END_LOAD procedure

This procedure re-enables triggers after importing data to new master site as part of offline instantiation. You must call this procedure from the new master site.

Syntax

DBMS_OFFLINE_OG.END_LOAD (
   gname     IN   VARCHAR2,
   new_site  IN   VARCHAR2,
   fname     IN   VARCHAR2);

Parameters

Table 21-8 END_LOAD Procedure Parameters
Parameter  Description  
gname
 

Name of the object group whose members you have finished importing.  

 
new_site
 

The fully qualified database name of the new site at which you have imported the object group members.  

 
fname
 

This system parameter is for internal use only. Do not set the parameter unless so directed by Oracle Worldwide Support.  

Exceptions

Table 21-9 END_LOAD Procedure Exceptions
Exception  Description  
badargument
 

NULL or empty string for object group or new master site name.  

 
wrongsite
 

This procedure must be called from the new master site.  

 
unknownsite
 

Given site is not recognized by object group.  

 
wrongstate
 

Status of the new master site must be QUIESCED.  

 
dbms_repcat. 
missingrepgroup
 

gname does not exist as a replicated master group.  

 
dbms_repcat.flavor_
noobject
 

If you receive this exception, contact Oracle Worldwide Support.  

 
dbms_repcat.flavor_
contains
 

If you receive this exception, contact Oracle Worldwide Support.  

RESUME_SUBSET_OF_MASTERS procedure

This procedure resumes replication activity at all existing sites except the new site during offline instantiation of a replicated master group. You must call this procedure from the master definition site.

Syntax

DBMS_OFFLINE_OG.RESUME_SUBSET_OF_MASTERS (
   gname     IN  VARCHAR2,
   new_site  IN  VARCHAR2,
   override  IN  BOOLEAN := FALSE);

Parameters

Table 21-10 RESUME_SUBSET_OF_MASTERS Procedure Parameters
Parameter  Description  
gname
 

Name of the object group that you are replicating to the new site.  

 
new_site
 

The fully qualified database name of the new site to which you are replicating the object group.  

 
override
 

If this is TRUE, then it ignores any pending RepCat administration requests and restores normal replication activity at each master as quickly as possible. This should be considered only in emergency situations.

If this is FALSE, then it restores normal replication activity at each master only when there is no pending RepCat administration request for gname at that master.  

Exceptions

Table 21-11 RESUME_SUBSET_OF_MASTERS Procedure Exceptions
Exception  Description  
badargument
 

NULL or empty string for object group or new master site name.  

 
dbms_repcat. 
nonmasterdef
 

This procedure must be called from the master definition site.  

 
unknownsite
 

Given site is not recognized by object group.  

 
wrongstate
 

Status of master definition site must be QUIESCED.  

 
dbms_repcat. 
missingrepgroup
 

gname does not exist as a replicated master group.  


Prev
Next
Oracle
Copyright © 1999 Oracle Corporation.
All Rights Reserved.

Library
Product
Contents
Index