Oracle Database 12c: Installation and Administration — Question 19

Your database is running in ARCHIVELOG mode. You want to take a consistent whole database backup.
Which two statements are true in this scenario? (Choose two.)

Answer options

• A. The user-managed backup consists of only formatted data blocks.
• B. The database must be shut down to take a user-managed backup.
• C. The RMAN backup contains only data files.
• D. The RMAN backup can be performed while the database is open.
• E. The database must be in MOUNT state to take RMAN backup.

Correct answer: A, B

Explanation

Option A is correct because a user-managed backup focuses on capturing only the formatted data blocks. Option B is also correct as a user-managed backup requires the database to be shut down to ensure consistency. Options C, D, and E are inaccurate; RMAN backups can include more than just data files, can be performed while the database is open, and do not require the MOUNT state.