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.)
You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2. Three Physical Standby Databases
You must meet these requirements:
1. A designated physical standby database should become the primary database automatically whenever the primary database fails.
2. The chosen protection mode should provide the highest level of protection possible without violating the other requirement.
Which redo transport mode and protection mode would you configure to meet these requirements?
A Data Guard environment has this configuration and these attributes:
1. The primary database prima is in the local region.
2. A physical standby database physt1 is in the local region.
3. A physical standby database physt2 is in a remote region.
4. The primary ships redo to physt1.
5. physt1 ships redo physt2.
6. physt1 and physt2 have Real-Time Query enabled.
A sequence has been created with this SQL statement in the primary database:
CREATE SEQUENCE a NOCACHE SESSION:
Which two statements are true? (Choose two.)
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
Which three will be true after a successful failover to Cats? (Choose three.)
Copyright © 2021-2024 CertsTopics. All Rights Reserved
