1Z0-076 practice question 14 of 25

Your Data Guard environment contains a four-instance RAC primary database whose SID is PROD and a RAC physical standby database whose std is…

Your Data Guard environment contains a four-instance RAC primary database whose SID is PROD and a RAC physical standby database whose std is PROD_SBY. Examine the command executed on a node of the primary database cluster to create a service OLTPWORKLOAD that the applications will use to connect to the database when it is in the FRlMARYTclatabase role: srvctl add service -db PROD -service oltpworkload -role PRIMARY -failovertype SESSION - failovermethod BASIC -failoverdelay 10 -failoverretry 150 The service is then started Consider this list of tasks: 1. On a node of the standby database cluster execute: srvctl add service -db PROD_SBY -service oltpworkload -role PRIMARY -failovertype SESSION - failovermethod BASIC -failoverdelay 10 -failoverretry 150 2. On the primary database, create the oltpworkload database service using the dbms_service.create_service procedure. 3. Configure tap for clients in the tnsnames.ora files. 4. Make sure clients use the OLTPWORKLOAD service to connect to the database instances. 5. On the standby database, create the oltpworkload database service using the dbms_service.create_servi;l procedure. Identify the required steps to configure and use Transparent Application Failover (taf).

Answer options

A: 4

B: 2,3,4

C: 5

D: 1.4 Correct answer

E: 3,4

F: 1,3,4

Correct Answer:

D. 1.4

Explanation

The OLTPWORKLOAD service is already created and started on the primary.
1) The same service must exist on the physical standby and be marked –role PRIMARY so that it will start automatically when that standby becomes the primary.
4) Client connect strings must be changed (or verified) so that they use the OLTPWORKLOAD service; then OCI will transparently request TAF using the server-side failover attributes specified with srvctl. No DBMSSERVICE call is needed, and no special TNS entry beyond pointing to the service is required.

Why Incorrect

A. Step 4 alone does not create the service on the standby, so TAF cannot start there.
B. Uses DBMSSERVICE rather than srvctl and omits creating the service on the standby cluster; incomplete.
C. Only creates the service on the standby; primary and clients remain unprepared.
E. Defines TNS names but never creates service on standby, so failover fails.
F. Adds service on standby but omits ensuring clients actually use it.

References

1. Oracle Grid Infrastructure & RAC Admin Guide 19c, Sec. 6.3.4 “Creating Role-based Services with SRVCTL” (E96216-29, p. 6-19).

2. Oracle Database Net Services Administrator’s Guide 19c, Sec. 10.2 “Transparent Application Failover with Server-Side Configuration” (E96243-24, p. 10-3).

3. Oracle Maximum Availability Architecture—“Data Guard Services Best Practices for RAC” white paper, v19c, p. 14-15 (Oracle Corp.).

Keep practicing

Take the free 1Z0-076 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test