High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center