Active Data Guard DML Redirection in a pluggable database
Hi
I'm testing Active Data Guard DML Redirection feature in my test pluggable database. On the CDB level this feature works automatically. However, to use the DML redirection from a PDB it is required to create a database link ADGREDIRECT as recommended in the Doc ID 2980532.1. However if global_name contains a domain, this domain is also appended to the ADGREDIRECT db link. And it is required that this db link does not contain the domain part, otherwise the redirection fails.
There is a workaround to update the global_name and restart the instance as per Doc ID 2737943.1. Then it is possible to create the database link 'ADGREDIRECT' and change global_name back.