Starting with Shareplex 8.6 and up, it is possible to replicate from multiple PDB sources. This solution illustrates the basic steps involved in setting up replication involving 2 PDB sources.
For the sake of simplicity, say there are two PDB sources named PDB1 and PDB2. Here are the steps involved in activating a config which will capture changes from these two datasources:
Set the correct environment for PDB1 which includes among others, ORACLE_HOME, ORACLE_SID, SP_COP_TPORT, SP_COP_UPORT and SP_SYS_VARDIR and run ora_setup for PDB1, if not already done.
Set the correct environment for PDB2 which includes among others, ORACLE_HOME, ORACLE_SID, SP_COP_TPORT, SP_COP_UPORT and SP_SYS_VARDIR and run ora_setup for PDB2, if not already done.
Start Shareplex.
While retaining the values for the environment variables SP_COP_TPORT, SP_COP_UPORT and SP_SYS_VARDIR, set the ORACLE_HOME and ORACLE_SID for PDB1 and activate the config.
Once activation finishes, retain the values for SP_COP_TPORT, SP_COP_UPORT and SP_SYS_VARDIR but set the ORACLE_HOME and ORACLE_SID for PDB2 and activate the config.
From this point on, you will see two active config file. Also, "status" will show two sets of Capture, Read and Export processes and "qstatus" will show two Capture and Export queues. The following example of the qstatus output shows two Capture queues:
sp_ctrl (server_name:2100)> qstatus
Queues Statistics for server_name
Name: o.PDB1 (Capture queue)
Number of messages: 2 (Age 0 min; Size 2 mb)
Backlog (messages): 0 (Age 0 min)
Name: o.PDB2 (Capture queue)
Number of messages: 0 (Age 0 min; Size 5 mb)
Backlog (messages): 0 (Age 0 min)
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center