API to Retrieve runtime Replication Parameters
We often get thousands of replication conflits/errors at current system. A resolution is generally looking at EM console and resolving each error manually. Please see examples below.
Average Amount of Time to Apply Transactions at Remote Sites
SELECT substr(DBLINK,1,25), AVG_LATENCY “Average Latency”
FROM DEFSCHEDULE
WHERE upper(DBLINK) like ‘&1′;
Delete MASTER Node: Rollback ADD_NEW_MASTERS Procedure
I am trying to add a new master database into existing replication cluster using API DBMS_REPCAT.ADD_MASTER_DATABASE. The system returned error : ORA-23493: “REPC.US.ORACLE.COM” is not a new site for extension request “57C8B3C5C100528AE0440060B0C193C6″ Read more…
Replication SQL Scripts
Count of Objects replicated in Database
SELECT base_sname “OWNER”, COUNT (UNIQUE base_oname) NUMBER_OF_OBJECTS
FROM REPCAT$_GENERATED
GROUP BY base_sname;
Push Replication Group to NORMAL Status in an Exceptional Case
The dbms_repcat.resume_master_activity() package has an override parameter that defaults to FALSE. This parameter can be set to TRUE to allow the
group to become normal even if there are pending admin requests in DBA_REPCATLOG for this group.
Monitoring the Deferred Transactions Queue
-
Listing the Number of Deferred Transactions for Each Destination Master Site
Oracle Advanced Replication :Monitoring Administrative Requests
1. Listing General Information About Administrative Requests at the Master
2. Determining the Cause of Administrative Request Errors at the Master
3. Listing Information About the Job that Executes Administrative Requests at the Master
List General Information About Master Groups & replication activity
You can retrieve following details :
- The number of unpropagated deferred transaction-destination pairs. Each deferred transaction can have multiple destinations to which it will be propagated, and each destination is a single deferred transaction-destination pair.
- The number of deferred transaction errors (error transactions) for each master group
- The number of administrative requests for each master group
- The number of administrative request errors for each master group
Oracle Advanced Replication | Listing the Master Sites Participating in a Master Group
COLUMN GNAME HEADING ‘Master Group’ FORMAT A20
COLUMN DBLINK HEADING ‘Sites’ FORMAT A25
COLUMN MASTERDEF HEADING ‘Master|Definition|Site?’ FORMAT A10
Dynamic Replication Views
DBA_REPCATLOG describes the status for all asynchronous administrative requests and all error messages in the database.
Oracle Advanced Replication | Remove or Delete Master Site from a Master Group
Executed At: Master Definition Site
Replication Status: Quiesced
Step 1 Connect to the master definition site as the replication administrator.
Oracle Advanced Replication – Administration Tasks (Concepts/no SQL)
- Suspending Master Activity
- Resume Master Activity
- Applying Administration Tasks
- Applying Transactions
- Removing Transactions
- Removing Errors
- Drop Replication Object
Oracle Advanced Replication | Relocating Master Definition Site
I have a live 4 node 4 way cluster between repA,repAA,repB & repBB instances. The node repA is Master which I want to move to repAA.
Add new Node without Quiescing (RMAN SCN Method)
Task: We have a working setup of 4 node 4 way replication cluster built on Advanced/MultiMaster replication. 2 nodes out of these 4 nodes should be moved to a different physical location without a downtime.