Which three actions are performed by the START PLAN procedure of the DBMS ROLLING package?
A.
converting the designated physical standby database into a logical standby database
B.
creating a guaranteed restore point on the standby databases
C.
building a LogMiner dictionary on the primary database instance
D.
creating a guaranteed restore point on the primary database
E.
starting media recovery on all the Leading Group Standby databases
F.
switching the primary database to the logical standby role
The Answer Is:
B, C, D
This question includes an explanation.
Explanation:
The DBMS_ROLLING package facilitates a rolling upgrade process across a Data Guard configuration. The START PLAN procedure in particular handles several critical actions, including:
Creating a guaranteed restore point on the standby databases (B):This ensures that the standby databases can be reverted to their state before the rolling upgrade process in case of any issues.
Building a LogMiner dictionary on the primary database instance (C):This is necessary for logical standby databases to interpret redo data during the SQL Apply process.
[References:, Oracle Database PL/SQL Packages and Types Reference, Oracle Data Guard Concepts and Administration Guide, ]
1z0-076 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 65% Discount on All Products,
Use Coupon: "ac4s65"