Which two are true about the creation of a Data Guard Broker configuration?

Which two are true about the creation of a Data Guard Broker configuration? A. In a broker configuration, the primary database name must match the DB_UNIQUE_NAME value in the database initialization parameter file. B. A primary database profile may be added to the configuration prior to creating the primary database. C. A standby database profile […]

Read More

Which two are true about the output of this DGMGRL command?

You have a Data Guard Broker configuration called ‘Somewhere’ as shown:DGMGRL> show configuration;Configuration –SomewhereProtection Mode: MaxPerformanceDatabases:Nearby-Primary databaseFS-Far SyncFarout-Physical standby databaseFast-Start Failover: DISABLEDConfiguration Status: SUCCESSYou then run this command:DGMGRL> SHOW DATABASE ‘Nearby’ ‘InconsistentProperties’;Which two are true about the output of this DGMGRL command? A. A far sync instance cannot have inconsistent properties because it has no […]

Read More

Which two Data Guard features require the use of flashback database by the broker?

Which two Data Guard features require the use of flashback database by the broker? A. Read-Mostly physical standby implementations B. Far Sync Instances C. Fast-Start Failover D. Real Time Query E. Snapshot Standby databases Explanation:C: Prerequisites that must be met before the broker allows you to enable fast-start failover include: EnableFlashback Database and set up […]

Read More

Which two would you recommend to avoid this error?

Your Data Guard environment consists of these components and settings:1. A primary database2. A remote physical standby database3. Real-time query is enabled.4. The redo transport mode is set to SYNC.5. The protection mode is set to Maximum Availability.You notice that queries executed on the physical standby database receive errors:ORA- 03172: STANDBY_MAX_DATA_DELAY of 15 seconds exceeded.Which […]

Read More

Identify two possible reasons for this error.

Examine the Data Guard configuration:DGMGRL > show configuration;Configuration-AnimalsProtection Mode: MaxAvailabilityDatabases:dogs- Primary databasedogsfsl –Far Syncsheep- Physical standby databaseFast-Start Failover: DISABLEDConfiguration Status:SUCCESSAn attempt to enable fast-start failover raises an eror:DGMGRL> enable fast_start failover;Error: ORA-16693: requirements not met for enabling fast-start failoverFailed.Identify two possible reasons for this error. A. The FastStartFailoverTarget property is not set on Sheep. B. […]

Read More

Which two are true about rolling release upgrades in a Data Guard environment?

Which two are true about rolling release upgrades in a Data Guard environment? A. The background process DMON must be enabled on the primary and standby databases during a rolling release upgrade procedure. B. A physical standby database can be converted to a logical standby database temporarily. C. Rolling release upgrades require the background process […]

Read More

which state should the target database be?

You must manually reinstate a database using DGMGRL.To which database should you connect with DGMGRL before issuing the REINSTATE command and in whichstate should the target database be? A. The target database should be in NOMOUNT state and DGMGRL should be connected to any database that is a member of the configuration. B. The target […]

Read More

Which solution is correct for these requirements?

Your expertise is requested for these customer requirements:1. The Data Guard environment must be in maximum protection mode.2. Reports must be offloaded to a physical standby database.3. There must be no lag between the primary and standby databases that affect the reports produced.4. The primary database must be resilient in case of a single network […]

Read More