Oracle Database 12c: Installation and Administration — Question 22

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. RMAN backups contain only data files.
• B. The database instance must be shut down to take a user-managed consistent backup.
• C. Consistent RMAN backups can be taken while the database is open.
• D. User-managed backups only contain formatted data blocks.
• E. The database must be in MOUNT state to take consistent RMAN backups.

Correct answer: B, E

Explanation

Option B is correct because a user-managed consistent backup requires the database to be offline to ensure data integrity. Option E is also correct as consistent RMAN backups require the database to be in MOUNT state. Options A, C, and D are incorrect as they do not reflect the requirements for achieving a consistent backup in ARCHIVELOG mode.