Loading questions...
Updated
Which two steps must be performed before running DUPLICATE TARGET DATABASE FOR STANDBY using RMAN? (Choose two.)
Which two are true about Data Guard Broker configuration parameter administration? (Choose two.)
Which three are true regarding prerequisites for a logical standby database as a disaster recovery solution? (Choose three.)
Examine this command executed on a physical standby database to transition it to a logical standby database:
SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY prodlgsby;
Which statement is true regarding the execution of this command?
Which two are true concerning the configuring of Flashback database in a Data Guard environment? (Choose two.)
Which two statements are true about Far Sync instances? (Choose two.)
Your Data Guard environment has a remote physical standby database with real-time query enabled, which is used for reporting, and a logical standby database used for DSS reporting.
Switchovers or failovers are possible due to testing or in case of a disaster.
Clients use local TNSNAMES.ORA files to define connection strings to the database instances.
Which three will prevent clients from connecting to the wrong database instances? (Choose three.)
You created the PRODSBY1 physical standby database for the PROD primary database using SQL and RMAN.
You are planning to create a Data Guard Broker configuration.
You execute the command:
DGMGRL> CREATE CONFIGURATION ‘DGConfig’ AS
> PRIMARY DATABASE IS ‘PROD’
> CONNECT IDENTIFIER IS PROD;
Which three statements are true regarding the execution of the command? (Choose three.)
Which three are true about using Flashback database through role transitions in a Data Guard environment? (Choose three.)
Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration Animals -
Protection Mode: MaxAvailability
Databases:
dogs- Primary database
cats- Snapshot standby database
sheep- Snapshot standby database
Fast-Start Failover: DISABLED -
Configuration Status:
ORA-01034: ORACLE not available -
ORA-16625: cannot reach database "dogs"
DGM-17017: unable to determine configuration status
You wish to perform a failover to Sheep.
Which command, or sequence of commands, should you issue to the broker before executing "failover to sheep", using the broker?
Which three are true about the use of the VALID_FOR clause of the LOG_ARCHIVE_DEST_N parameter, in determining whether archive logs should be written to a particular destination by a database in a Data Guard environment? (Choose three.)
Which three are true about disabling of the Data Guard Broker management of databases in a configuration and the effects of doing this? (Choose three.)
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 reasons for this error.
Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration Animals -
Protection Mode: MaxAvailability
Databases:
dogs- Primary database
sheep- (*) Physical standby database
cats- Physical standby database
Fast-Start Failover: ENABLED -
Configuration Status:
SUCCESS -
What happens if you issue "switchover" to sheep;" at the DGMGRL prompt?
A data file on one of your physical standby databases has been accidentally deleted and you must restore and recover it.
All the archive logs required for recovery are still on disk in the directory pointed to by the log_archive_dest_1 parameter.
Which three steps must be performed to restore the missing file and recover the standby database while it is in the MOUNT state?
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?
Which four factors can influence the rate of SQL apply on a logical standby database?
Which two are true about database roles in an Oracle Data Guard Configuration?
There are currently 6 APPLIER and 6 PREPARER processes running and no idle APPLIER processes on your logical standby database.
The MAX_SERVERS SQL apply parameter and number of archiver processes are both set to 12.
Identify two changes, each of which would allow you to increase the number of APPLIER processes.
Create a free account to unlock all questions for this exam.
Log In / Sign UpWhich two statements are true for Data Guard environments with multi-tenant databases?
You must configure an Oracle Data Guard environment consisting of: