|
EXTENSION_ID
|
RAW(16)
|
NOT NULL
|
The identifier for a current pending request to add master databases to a master group without quiesce. |
|
REQUEST
|
VARCHAR2(15)
|
- |
Extension request type. Currently, the only possible value is ADD_NEW_MASTERS, which indicates a request to add new master sites to a master group without quiescing. |
|
MASTERDEF
|
VARCHAR2(128)
|
- |
The global name of the master definition site of the master groups to which new master sites are being added. |
|
EXPORT_REQUIRED
|
VARCHAR2(3)
|
- |
YES indicates that one or more new master sites will be added using export/import of either the entire database or at the table level.
NO indicates that all new master sites will be added using change-based recovery.
|
|
REPCATLOG_ID
|
NUMBER
|
- |
Identifier of replication catalog records related to a replication extension, on which the master definition site is waiting. This value is only meaningful at the master definition site. |
|
EXTENSION_STATUS
|
VARCHAR2(13)
|
- |
Status of each replication extension. This value is only meaningful at the master definition site.
The possible values are:
READY: The extension request has been created and is ready.
STOPPING: The new master sites have been added to the master group and the master definition site is attempting to stop propagation from existing masters to new master sites and to the master definition site.
EXPORTING: The propagation of deferred transactions has been stopped from existing master sites to new master sites and to the master definition site. The master definition site is waiting for the export to finish.
INSTANTIATING: The DBMS_REPCAT.RESUME_PROPAGATION_TO_MDEF procedure has been invoked (if export was used), and the master definition site is waiting for the new masters to instantiate.
ERROR: An error occurred during the execution of this extension request.
|
|
FLASHBACK_SCN
|
NUMBER
|
- |
The system change number (SCN) that must be used during export or change-based recovery when the new master sites are added. The new master sites must be consistent with the SCN listed. |
|
BREAK_TRANS_TO_MASTERDEF
|
VARCHAR2(3)
|
- |
This value is meaningful only if EXPORT_REQUIRED is TRUE.
If BREAK_TRANS_TO_MASTERDEF is TRUE, then existing masters may continue to propagate their deferred transactions to the master definition site for replication groups that are not adding master sites. Deferred transactions for replication groups that are adding master sites cannot be propagated until the export completes.
If BREAK_TRANS_TO_MASTERDEF is FALSE, then existing masters cannot propagate any deferred transactions to the master definition site. |
|
BREAK_TRANS_TO_NEW_MASTERS
|
VARCHAR2(3)
|
- |
If BREAK_TRANS_TO_NEW_MASTERS is TRUE, then existing master sites may continue to propagate deferred transactions to the new master sites for replication groups that are not adding master sites.
If BREAK_TRANS_TO_NEW_MASTERS is FALSE, then propagation of deferred transaction queues to the new masters is disabled. |
|
PERCENTAGE_FOR_CATCHUP_MDEF
|
NUMBER
|
- |
This value is meaningful only if BREAK_TRANS_TO_MASTERDEF is TRUE.
The percentage of propagation resources that should be used for catching up propagation to the master definition site. |
|
CYCLE_SECONDS_MDEF
|
NUMBER
|
- |
This value is meaningful when PERCENTAGE_FOR_CATCHUP_MDEF is both meaningful and is a value between 10 and 90, inclusive. In this case, propagation to the master definition site alternates between replication groups that are not being extended and replication groups that are being extended, with one push to each during each cycle. This value indicates the length of the cycle in seconds. |
|
PERCENTAGE_FOR_CATCHUP_NEW
|
NUMBER
|
- |
This value is meaningful only if BREAK_TRANS_TO_NEW_MASTERS is TRUE.
The percentage of propagation resources that should be used for catching up propagation to new master sites. |
|
CYCLE_SECONDS_NEW
|
NUMBER
|
- |
This value is meaningful when PERCENTAGE_FOR_CATCHUP_NEW is both meaningful and is a value between 10 and 90, inclusive. In this case, propagation to a new master alternates between replication groups that are not being extended and replication groups that are being extended, with one push to each during each cycle. This value indicates the length of the cycle in seconds. |
