Examine this command executed on a physical standby database to transition it to a logical standby database:
SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY prodlgsby;
Which statement is true regarding the execution of this command?
A.
FLASHBACK is automatically enabled when transitioning to the logical standby database.
B.
The Managed Recovery Process (MRPO) continues applying redo up to the SCN immediately preceding the redo corresponding to the LogMiner dictionary build.
C.
Supplemental logging will be enabled on the logical standby database when the physical database is transitioned to the logical standby database.
D.
SQL apply is automatically started when transitioning to the logical standby database.
-- To prepare the physical standby database to transition to a logical standby database:
-- - a. Issue the ALTER DATABASE RECOVER TO LOGICAL STANDBY db_name command to continue
-- - applying redo data to the physical standby database until it is ready to convert to a logical
-- - standby database. Specify a database name (db_name) to identify the new logical standby database.
-- The redo log files contain the information needed to convert your physical standby database to a
-- logical standby database. The statement applies redo data until the LogMiner dictionary is found
-- in the redo log files.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
ScottL
1 year, 3 months agoJorgeZG
1 year, 11 months ago