Adding Remaining Grants to the Upstream and Downstream Recovery Appliance

This task grants access to VPC users on both the upstream and downstream Recovery Appliances.

1. On RAHADR1, add the grant access to the one remaining VPC users.

   SQL> exec dbms_ra.grant_db_access(
   username => 'HADR_COMMON_VPCUSER',
   db_unique_name => 'cdb122dr');
   
   PL/SQL procedure successfully completed.

2. On RAHADR2, add the grant access to the two remaining VPC users. These users are pre-setup in the event that backups failover, due to RAHADR1 not being available.

   SQL> exec dbms_ra.grant_db_access(
   username => 'HADR_LOCAL_VPCUSER',
   db_unique_name => 'cdb122dr');
   
   PL/SQL procedure successfully completed.
   
   SQL> exec dbms_ra.grant_db_access(
   username => 'HADR_COMMON_VPCUSER',
   db_unique_name => 'cdb122dr');
   
   PL/SQL procedure successfully completed.

3. Verify the credentials are working correctly by logging into each target using only the credential alias. On each host run:

   $ sqlplus /@dr_rahadr2
   
   $ sqlplus /@dr_rahadr