Sunday, January 29, 2023

Oracle GoldenGate 21c MA -- How to Remove a Replicat from Configuration


You want to remove a Replicat from configuration using GoldenGate 21c Microservices Architecture


1) Connect to the deployment as a privileged user:

GG (not connected) 1> connect https://localhost:34030 as sys !
Password for 'sys' at 'https://localhost:34030/gg_inst1': <enter password>

2) Log into the source database:

OGG (https://localhost:34030 gg_inst1) 2> DBLOGIN USERIDALIAS <alias>
Successfully logged into database.

3) Stop Replicat:

OGG (https://localhost:34030 gg_inst1 as <alias>@<db>) 32> stop replicat <replicat_name>
2023-01-29T10:04:26Z  INFO    OGG-08100  Replicat group
<replicat_name> is stopped.

4) Delete Replicat from configuration:

OGG (https://localhost:34030 gg_inst1 as <alias>@<db>) 59> delete replicat <replicat_name>
2023-01-29T13:06:19Z  INFO    OGG-02529  Successfully unregistered Replicat group <replicat_name> inbound server OGG$<<replicat_name>> from database
2023-01-29T13:06:19Z  INFO    OGG-08100  Replicat group
<replicat_name> deleted.

5) Check replicat has been removed from the database:

SQL> select * from dba_apply;


No comments: