Oracle Exam 1Z0-076 Topic 1 Question 10 Discussion

For seamless client redirection in a Data Guard environment, the following steps should be taken:

Create a database service on the primary database that is started automatically by a trigger when the database role is PRIMARY (B): This ensures that the service is only available on the primary database and is automatically started after a role transition due to switchover or failover.

Modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name (B): Client applications use the connection descriptors that include all potential primary hosts (i.e., the current primary and all standbys). This enables clients to connect to whichever database is currently acting as the primary using the service name. Reference:

Oracle Data Guard Concepts and Administration Guide

Oracle Real Application Clusters Administration and Deployment Guide