Oracle Database Administration 2019 Certified Professional — Question 43

You administer a RAC database that currently runs on a four-node cluster but which has three instances.
Which two statements are always true about redo logs for this RAC database? (Choose two.)

Answer options

• A. A thread of redo must be created before starting a fourth instance if a thread is not already available.
• B. A thread of redo is automatically dropped when an instance is removed from a RAC database by using SRVCTL.
• C. All the instances must have the same number of redo log groups and each group must have the same number of redo log members.
• D. A redo log group added using ALTER DATABASE ADD LOGFILE without the INSTANCE clause is added to each instance.
• E. A thread of redo must contain at least two log groups before it can be enabled.

Correct answer: A, E

Explanation

Option A is correct because a new redo thread is necessary for an additional instance if one does not already exist. Option E is also correct as a redo thread requires at least two log groups to be functional. Options B, C, and D are incorrect because they do not reflect the requirements and behaviors of redo logs in a RAC environment.