Online Access Free 1Z0-066 Exam Questions

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? (Choose three.)

• A.Restore the datafile by using the RMAN RESTORE DATAFILE command.
• B.Recover the datafile by using the RMAN RECOVER DATAFILE command
• C.Recover the database by using the RMAN RECOVER DATABASE command.
• D.Stop the redo apply.
• E.Restart the redo apply.

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. (Choose two.)

• A.There is already an observer running for this Data Guard configuration.
• B.The broker configuration has not yet been created.
• C.The observer configuration file is marked read-only.
• D.There is another observer running for a Data Guard configuration which uses the same observer configuration file.
• E.Fast-Start Failover is not yet enabled for this 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. (Choose two.)

• A.Increase the value for the MAX_SERVERS SQL apply parameter.
• B.Increase the PARALLEL_MAX_SERVER initialization parameter
• C.Increase the PROCESSES initialization parameter
• D.Decrease the number of PREPARER processes
• E.Decrease the number of archiver processes on the standby database.
• F.Increase the RECOVERY_PARALLELISM initialization parameter

Which two are true about database roles in an Oracle Data Guard Configuration? (Choose two.)

• A.A configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade.
• B.A Logical Standby Database can be converted to a Snapshot Standby Database.
• C.A Physical Standby Database can be converted into a Logical Standby Database.
• D.A Snapshot Standby Database can be a fast-start failover target.
• E.A Logical Standby Database can cascade redo to a terminal destination.

Which three are true concerning Automatic Block Media Recovery in a Data Guard environment when running an application as an ordinary Oracle user? (Choose three.)

• A.Real Time Query must be enabled on the physical standby database.
• B.Real Time Query must be enabled on the primary database.
• C.If a physically corrupt block is discovered on the primary database, then a valid block image from a physical standby database is retrieved.
• D.If a physically corrupt block is discovered on a primary database, then a valid block image from the logically standby database is retrieved.
• E.If a physically corrupt block is discovered on a logical standby database, then a valid block image from the primary database is retrieved.
• F.If a physically corrupt block is discovered on a physical standby database, then a valid block image from the primary database is retrieved.