Oracle Database 12c: Advanced Administration — Question 13

Your database supports an online transaction processing (OLTP) workload and it needs to be up 24 x 7. You want to perform a complete database backup by using RMAN.
Identify the minimum requirement for accomplishing the task.

Answer options

• A. An RMAN channel must be configured to device-type disk.
• B. The database must be configured in ARCHIVELOG mode.
• C. Redo log groups must have at least two members each.
• D. All tablespaces in the database must be locally managed.

Correct answer: C

Explanation

The correct answer is C because having at least two members in each redo log group ensures that there is redundancy and prevents data loss during a backup. Option A is not required for RMAN to perform a backup, as it can use different device types. Option B is necessary for point-in-time recovery but not specifically for a complete backup. Option D relates to tablespace management but does not affect the ability to perform a backup.