Which three are true about the rolling release upgrade method for Data Guard environments using a transient Logical Standby database? (Choose three.)
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 with the new observer hostname.
4) Enable Fast-Start Failover.
5) Start the Observer on host2.
Which contains the minimum required steps to move the observer to host2?
Which three are true concerning database states after a successful switchover? (Choose three.)
You edit the DGConnectIdentifier database property using the edit database set property DGMGRL command.
Which two are effects of this change? (Choose two.)
B: The DGConnectIdentifier configurable database property specifies the connection identifier the broker uses when making connections to a database.
The value of this property is specified in the SERVICE attribute of the LOG_ARCHIVE_DEST_n parameter when the broker configures redo transport services on the primary database.
A: The connect identifier for a database must allow all other databases in the configuration to reach it.
References:
https://docs.oracle.com/cd/E11882_01/server.112/e40771/dbpropref.htm#DGBKR870
You must configure an Oracle Data Guard environment consisting of:
1. A primary database
2. One Physical Standby Database
3. One Logical Standby Database
You must meet these requirements:
1. Primary database availability should not be compromised by the availability of the standby databases.
2. Under normal operations, transactions executed on the primary database should not commit before redo is written to disk on both the primary database and at least one standby database.
Which redo transport mode and which protection mode would you configure to meet these requirements?
The Maximum Availability protection mode provides the highest level of data protection that is possible without compromising the availability of a primary database. Transactions do not commit until all redo data needed to recover those transactions has been written to the online redo log and to at least one synchronized standby database. If the primary database cannot write its redo stream to at least one synchronized standby database, it operates as if it were in maximum performance mode to preserve primary database availability until it is again able to write its redo stream to a synchronized standby database.
This mode ensures that no data loss will occur if the primary database fails, but only if a second fault does not prevent a complete set of redo data from being sent from the primary database to at least one standby database.
When a transport is performed using SYNC/AFFIRM, the primary performs write operations and waits for acknowledgment that the redo has been transmitted synchronously to the physical standby and written to disk. A SYNC/AFFIRM transport provides an additional protection benefit at the expense of a performance impact caused by the time required to complete the I/O to the standby redo log.
