1z0-066 Oracle Database 12c: Data Guard Administration

Loading demo links...

Showing 4–6 of 10 questions

Question 4

Your Data Guard environment consists of these components and settings:

1. A primary database supporting an OLTP workload

2. A remote physical standby database

3. Real-time query is enabled

4. The redo transport mode is set to SYNC.

5. The protection mode is set to Maximum Availability.

Which two are true regarding the DelayMins Database Property for the standby database? (Choose two.)

Select all that apply, then click Submit answer.

  • It can only be enabled for a configuration in Maximum Performance mode.

  • It allows user errors on the primary to be recovered by using the physical standby database.

  • It enables you to bypass the default network timeout interval specified for the standby redo transport destination.

  • It can only be enabled for a configuration in Maximum Availability mode.

  • It allows logical corruptions on the primary to be recovered by using the physical standby database.

  • It specifies a delay before the primary ships redo to the standby destination having DelayMins set.

Question 5

Attempting to start the observer raises an error:

DGMGRL> start observer;

DGM-16954: Unable to open and lock the Observer configuration file Failed.

Identify two possible ways to start the observer successfully. (Choose two.)

Select all that apply, then click Submit answer.

  • Set the ObserverOverride property to TRUE before starting the observer.

  • Create a broker configuration and enable Fast-Start Failover before starting the observer.

  • Start the observer using a different observer configuration file.

  • Start the observer in a different working directory.

  • Enable Fast-Start Failover before starting the observer.

Question 6

You administer a Data Guard environment consisting of a primary database 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?

Select an option, then click Submit answer.

  • CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;

  • CONFIGURE ACHIVELOG DELETION POLICY TO APPLIED ON STANDBY;

  • CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;

  • CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO STANDBY;

  • CONFIGURE ACHIVELOG DELETION POLICY TO NONE;