Which two statements are true regarding undo management in the RAC environment?

Which two statements are true regarding undo management in the RAC environment?

Which two statements are true regarding undo management in the RAC environment?

A.
You can use Automatic Undo Management (AUM) in some of the instances and manual undo
management in the rest of the instances in a RAC database.

B.
In a policy-managed RAC database, Oracle automatically allocates the undo tablespace even
the Oracle Managed Files (OMF) is disabled in a database.

C.
In a policy-managed RAC database, Oracle automatically allocates the undo tablespace if the
database is OMF enabled.

D.
You can dynamically switch undo tablespace assignments by executing the ALTER SYSTEM
SET UNDO_TABLESPACE statement from any instance in a administrator managed database.

Explanation:
You assign undo tablespaces in your Oracle RAC administrator-managed database
by specifying a different value for the UNDO_TABLESPACE parameter for each instance in your
SPFILE or individual PFILEs. For policy-managed databases, Oracle automatically allocates the
undo tablespace when the instance starts if you have Oracle Managed Files enabled.
You can switch from using one undo tablespace to another. Because the UNDO_TABLESPACE
initialization parameter is a dynamic parameter, the ALTER SYSTEM SET statement can be used
to assign a new undo tablespace.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

A is wrong. for RAC, all instances must have the same value for UNDO_MANAGEMENT
B is wrong. policy-managed + OMF leads to undo tablespace auto creation
C is right.
D is right.

So C.D. are correct