Which two steps must be performed before running DUPLICATE TARGET DATABASE FOR STANDBY using RMAN? (Choose two.) A. Transfer a copy of the passwordfile from the primary host to the standby host. B. Run the nid utility to modify the…

Examine the Data Guard configuration: DGMGRL> show configuration; Configuration – Animals Protection Mode: MaxAvailability Databases: dogs – Primary database cats – Physical standby database sheep – Logical standby database Fast-Start Failover: DISABLED Configuration Status: ORA-01034: ORACLE not available ORA-16625: cannot…

You must propose an Oracle Data Guard configuration for a database supporting a DSS workload that meets these permanent requirements: 1. The performance impact on the primary database should be kept to a minimum. 2. Creating and maintaining materialized views…

Which two statements are true about block media recovery in a Data Guard environment? (Choose two.) A. When using RMAN, the RECOVER CORRUPTION LIST command can automatically use blocks from flashback logs. B. A corrupt block on the primary database…

Which three are true about the rolling release upgrade method for Data Guard environments using a transient Logical Standby database? (Choose three.) A. A rolling release upgrade can be performed with the Data Guard environment in any protection mode. B.…

The Oracle database 12c Observer is currently running on host1 and you wish to have it running on host2. Examine this list of possible steps: 1) Stop the observer on host1. 2) Disable Fast-Start Failover. 3) Update the broker configuration…

Examine the Data Guard configuration: Properties: FastStartFailoverThreshold = ’30’ OperationTimeout = ’30’ TraceLevel = ‘USER’ FastStartFailoverLagLimit = ’30’ CommunicationTimeout = ‘180’ ObserverReconnect = ’10’ FastStartFailoverAutReinstate = ‘TRUE’ FastStartFailoverPmyShutdown = ‘TRUE’ BystandersFollowRoleChange = ‘all’ ObserverOverride = ‘FALSE’ Fast-Start Failover: ENABLED Threshold:…

Which three statements are true about Data Guard database modes and states? (Choose three.) A. A primary database may ship redo directly to more than mine standby databases. B. Force Logging Mode is not required for a primary database but…

Which two are true about the creation of a Data Guard Broker configuration? (Choose two.) 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…

Which three are true concerning database states after a successful switchover? (Choose three.) A. If the former primary database became a logical standby database it will be in mount state. B. The new primary database will be open read-write. C.…