Oracle Exam 1Z0-076 Topic 1 Question 10 Discussion

Actual exam question for Oracle's 1Z0-076 exam

Question #: 10
Topic #: 1

Your Data Guard environment has two remote physical standby databases.

Client applications use the local naming method to connect to the primary database instance.

You want applications to automatically connect to the new primary database instance in case of a switchover or a failover.

Which set of actions will fulfill this requirement?

ASet the LOCAL_LISTENER parameter for all the database instance to register services with the default listener on the primary database host.

BCreate a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.

CSet DB_NAME and DB_UNIQUE_NAME identically on all databases; modify the connection descriptors on client applications to include all the standby hosts and connect to the database instance using that service name.

DSet the INSTANCE NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name.

Show Suggested Answer

Suggested Answer: B

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

by Lonna at May 23, 2024, 05:22 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-076 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Odette

6 months ago

Ah, the joys of Data Guard! I bet the exam writers were chuckling as they came up with this one. Option B is the way to go, no doubt about it.

upvoted 0 times

...

Sheron

6 months ago

This question is a piece of cake! Option B is the clear winner. Honestly, who even considers using the same INSTANCE_NAME across all databases? That's just bizarre.

upvoted 0 times

...

Benedict

6 months ago

Option C is interesting, but it might be overkill. Keeping the DB_NAME and DB_UNIQUE_NAME the same across all databases seems like a lot of work.

upvoted 0 times

Rosalyn

5 months ago

C) Set DB_NAME and DB_UNIQUE_NAME identically on all databases; modify the connection descriptors on client applications to include all the standby hosts and connect to the database instance using that service name.

upvoted 0 times

...

Gilbert

5 months ago

B) Create a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.

upvoted 0 times

...

Clorinda

5 months ago

A) Set the LOCAL_LISTENER parameter for all the database instance to register services with the default listener on the primary database host.

upvoted 0 times

...

6 months ago

I agree, option B is the best choice for ensuring automatic connection to the new primary database.

upvoted 0 times

...