1Z0-076: Oracle Database 19c: Data Guard AdministrationDemo

By Oracle · Question Mode

QuestionQ1

Performing Role Transitions

Examine the following command, which is run on a physical standby database to convert it to a logical standby database:

SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY prodlgsby;

Which two statements are true about executing this command?

Choose two
  • A The Managed Recovery Process (MRP0) continues applying redo data to the physical standby database until it is ready for conversion to a logical standby database.
  • B SQL apply is automatically started when transitioning to the logical standby database.
  • C Supplemental logging will be enabled on the logical standby database when the physical standby database is transitioned to the logical standby database.
  • D The DBID of the database is changed.
  • E FLASHBACK is automatically enabled when transitioning the logical standby database.
  • F It will automatically start redo apply.
Explanation

ALTER DATABASE RECOVER TO LOGICAL STANDBY continues applying redo on the physical standby until the required LogMiner dictionary is located, which is performed by managed recovery. Without the KEEP IDENTITY clause, the conversion also changes the database DBID. SQL Apply is started separately after conversion; supplemental logging and Flashback are not automatically enabled by this statement.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!