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…
Choose your answer, then check it against the explanation.
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).
Question 14 of 25
Keep practicing
Take the free 1Z0-076 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-076 practice questions
- Question 2You created two remote physical standby databases using SQL and RMAN. The primary databas…
- Question 3Examine the Data Guard configuration: DGMGRL> show configuration; Configuration - Animals…
- Question 4Your expertise is requested for these customer requirements: The Data Guard environment m…
- Question 5Which THREE steps are prerequisites for the creation of a physical standby database on a …
- Question 6You must design an Oracle Data Guard configuration for a DSS database that meets these pe…
- Question 7Which THREE are among the various tasks performed by the Data Guard Monitor (DMON) proces…
