You are required to change the Data Guard Configuration protection mode from MAXPERFORMANCE to MAXAVAJLABILITY using Enterprise Manager Cloud Control
Which two are true about this change?

• A.If the primary database cannot write its redo to at least one synchronized standby database, then the protection level remains unchanged.
• B.Fast start failover can be enabled when making the chance.
• C.Real time apply will be automatically turned on.
• D.The primary database instance will remain up and running, if it cannot write redo to at least one synchronized standby database.
• E.Transactions will not commit until all redo data needed to recover those transactions are written to the online redo log, and to the standby redo log on at least one synchronizes standby database.

Comment: *

Name: *

Email: *

Verification: *

You must design an Oracle Data Guard configuration for an OLTP database that meets these permanent
requirements:
1 . Data loss is not permitted.
2 . Read-only applications should not connect to the primary database instance.
Additionally, there are these requirements, only one of which is ever done at any one time:
1 . It should be possible to apply designated patches with a minimum amount of downtime.
2 . Upgrading to a new database release should be performed with the least possible amount of downtime.
3 . New application software releases should be tested against an exact and up-to-date replica of the
primary database.
Which configuration meets these requirements with the fewest databases?

• A.a primary database with one logical and two physical standby databases
• B.a primary database with one logical standby database
• C.a primary database with two physical standby databases
• D.a primary database with three physical standby databases
• E.a primary database with one physical standby database
• F.a primary database with one logical and one physical standby database

Comment: *

Name: *

Email: *

Verification: *

Which two are prerequisites for configuring flashback database for Oracle 12c databases, in a Data Guard environment?

• A.A flash recovery area must be configured.
• B.The database must be in MOUNT state.
• C.The database must be in ARCHIVELOG mode.
• D.A far sync instance must be configured to flash back a standby when the primary has been flashed back.
• E.The Data Guard Broker must be used.

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 Hearth Conditions: Corrupted Controlfile 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.MOUNT DOGS and issue "reinstate database dogs:" at the DGMGRL prompt while connected to Sheep
• B.MOUNT DOGS and issue ''reinstate database dogs:" at the DGMGRL prompt while connected to Dogs.
• C.Bring Dogs to the NOMOUNT state and let the broker reinstate Dogs automatically.
• D.Open Dogs and let the broker reinstate Dogs automatically.

Comment: *

Name: *

Email: *

Verification: *

Which three are required in order to use Real-Time Query without lagging behind the primary? (Choose three.)

• A.There must be standby redo logs on the standby database.
• B.There must be standby redo logs on the primary database.
• C.The primary must ship redo asynchronously.
• D.COMPATIBLE must be set to 11.1.0 or higher.
• E.Real-Time apply must be enabled on the standby.

Comment: *

Name: *

Email: *

Verification: *