Which three are true concerning database states after a successful switchover?

Correct Answer for the Question – Which three are true concerning database states after a successful switchover? is given below Which three are true concerning database states after a successful switchover? (Choose three.)References: https://docs.oracle.com/database/121/SBYDB/pre12_role_trans.htm#SBYDB5212 If the former primary database became a logical standby database it will be in mount state. The new primary database will be … Read more

Which three of these steps must be performed on the primary database after the file has been backed up using RMAN on the physical standby database?

Correct Answer for the Question – Which three of these steps must be performed on the primary database after the file has been backed up using RMAN on the physical standby database? is given below You must use a physical standby database file to recover a data file on a primary database in a Data Guard … Read more

Which two are true about the output of this DGMGRL command?

Correct Answer for the Question – Which two are true about the output of this DGMGRL command? is given below A far sync instance cannot have inconsistent properties because it has no database. It shows all properties whose broker configuration values for database Nearby are inconsistent with the broker configuration values for database Farout. It shows … Read more

Which two are true about offloading backups to a physical standby database in a Data Guard environment?

Correct Answer for the Question – Which two are true about offloading backups to a physical standby database in a Data Guard environment? is given below The standby database must be registered in an RMAN catalog after the primary database has been registered. The standby database cannot be registered in an RMAN catalog if the primary … Read more

Which two are true about management of a far sync instance when using the Data Guard Broker?

Correct Answer for the Question – Which two are true about management of a far sync instance when using the Data Guard Broker? is given below A far sync instance is in a disabled state in the broker configuration immediately after adding it. A far sync instance that has its RedoRoutes property set may not be … Read more

Which contains the minimum required steps to move the observer to host2?

Correct Answer for the Question – Which contains the minimum required steps to move the observer to host2? is given below Execute only task 5. Execute tasks 1, 3, and 5. Execute tasks 1, 2, 3, 4, and 5. Execute tasks 1 and 5. Correct Answer The Correct Answer for this Question is Execute tasks 1 … Read more

Which will automatically redirect clients to the new primary database in case of a switchover or failover?

Correct Answer for the Question – Which will automatically redirect clients to the new primary database in case of a switchover or failover? is given below Create a database service on the standby databases; automate the start of the service after a role change, and modify the connection description on the clients to use that service. … Read more

Which four statements are true regarding SQL Apply filters for a logical standby database?

Correct Answer for the Question – Which four statements are true regarding SQL Apply filters for a logical standby database? is given below Which four statements are true regarding SQL Apply filters for a logical standby database?A: The DDL fires DML triggers defined on the target table. Since the triggered DMLs occur in the same transaction … Read more

Which three are benefits of using the Data Guard Broker to manage standby databases?

Correct Answer for the Question – Which three are benefits of using the Data Guard Broker to manage standby databases? is given below Which three are benefits of using the Data Guard Broker to manage standby databases?BE: The broker simplifies switchovers and failovers by allowing you to invoke them using a single key click in Oracle … Read more