Oracle Database 12c: Advanced Administration — Question 10

Which two can be backed up by using RMAN in a database that is in ARCHIVELOG mode?

Answer options

• A. online redo log files while the database is open
• B. data files while the database is open
• C. PFILE and password file in MOUNT state
• D. data blocks in data files that have changed since the previous backup
• E. data files while the database is in NOMOUNT state

Correct answer: A, B

Explanation

The correct answers are A and B because RMAN can back up online redo log files and data files when the database is open in ARCHIVELOG mode. Options C, D, and E are incorrect because PFILE and password files cannot be backed up in this manner, and data files cannot be backed up in NOMOUNT state, nor can RMAN specifically back up only the changed data blocks.