Which two statements are true regarding Data Guard Broker?

• A.It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby.
• B.It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.
• C.It can be used to perform failovers and switchovers.
• D.It can be used to create and manage standby databases.
• E.It can be used to monitor redo transport and log apply services.

Comment: *

Name: *

Email: *

Verification: *

Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?

• A.To start SQL apply on a logical standby database, a TNS entry enabling connectivity to the primary
  database instance must be defined on the logical standby database host.
• B.To enable Reatime Query on a physical standby database, a TNS entry enabling connectivity to the
  standby database instance must be defined on the primary database host.
• C.A TNS entry or entries enabling connectivity to standby database instance(s) must be defined on the
  primary database host.
• D.A TNS enabling connectivity to the primary database instance must be defined on each of the standby
  database hosts.
• E.the LOCALJJSTERNER initialization parameter must be set to the listener used to register theprimary
  database instance.

Comment: *

Name: *

Email: *

Verification: *

You administer a Data Guard environment consisting of a primary and three physical standby databases.
One physical standby database is used for disaster recovery, one is used for reporting, and one is used as a replica for testing.
The standby database used for testing is occasionally converted into a snapshot standby database and then converted back to a physical standby.
The physical standby database is the only standby that is a mandatory destination.
The broker configuration operates in MAXIMUM PERFORMANCE mode.
Which ARCHIVELOG DELETION POLICY should be set, so that archive logs generated on the primary database are not deleted before they are consumed appropriately on each of the standby databases, but which allows them to be deleted form the primary as soon as it is safe to do so?

• A.CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
• B.CONFIGURE ACHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
• C.CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;
• D.CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO STANDBY;
• E.CONFIGURE ACHIVELOG DELETION POLICY TO NONE;

Comment: *

Name: *

Email: *

Verification: *

Examine the Data Guard configuration:
DGMGRL> show configuration:
Configuration-Animals
Protection Mode: MaxAvailability
Databases:
Sheep- Primary database
Warning: ORA-16817: unsynchronized fast-start failover configuration
Dogs - (*) Physical standby database (disabled)
ORA- 16661: the standby database needs to be reinstated
Fast-Start Failover: ENABLED
Configuration Status:
WARNING
And the fast-start failover configuration:
DGMGRL> show fast_start failover;
Fast-Start Failover: ENABLED
Threshold : 30 seconds
Target: dogs
Observer : 017.example.com
Lag Limit: 30 seconds (not in use)
Shutdown Primary: TRUE
Auto-reinstate: TRUE
Observer Reconnect: 10 seconds
Observer Override: FALSE
Configurable Failover Conditions
Health Conditions:
Corrupted Controlfile YES
Corrupted Dictionary YES
Inaccessible Logfile NO
Stuck Archiver NO
Datafile Offline YES
Oracle error Conditions:
ORA-01578: ORACLE data block corrupted (file # %s, block # %s)
And finally the reason for the fail over:
SQL> select last_failover_reason from v$fs_failover_stats;
LAST_FAILOVER_REASON
ORA-01578: ORACLE data block corrupted (file # %s, block # %s)
Identify the task, or sequence of tasks, to bring the configuration into the SUCCESS state.

• A.Bring Dogs to the NOMOUNT state and let the broker reinstate Dogs automatically.
• B.MOUNT DOGS and issue "reinstate database dogs:" at the DGMGRL prompt while connected to Dogs.
• C.MOUNT DOGS and issue "reinstate database dogs:" at the DGMGRL prompt while connected to Sheep.
• D.Open Dogs and let the broker reinstate Dogs automatically.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about Data Guard configurations? (Choose three.)

• A.All databases in one Data Guard environment must have the same database name.
• B.VALID_FOR is a LOG_ARCHIVE_DEST_N attribute that enables DB role change operations without having to modify LOG_ARCHIVE_DEST_n when performing switchovers or failovers.
• C.For Standard Edition, LOG_ARCHIVE_DUPLEX_DEST is used to configure redo transport, from the primary to the standby database.
• D.When using the Data Guard Broker, an spfile is not required.
• E.Up to 30 physical standby databases may exist within one configuration.
• F.The Oracle recommendation for the number of standby redo log groups per thread is one more than the number of online redo log groups per thread.

Comment: *

Name: *

Email: *

Verification: *