Oracle Database Administration II — Question 56

The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode.
Which two are true about using RMAN to perform an open database back up of this tablespace? (Choose two.)

Answer options

• A. Backups must be done incrementally.
• B. Backups must be contained in backup sets.
• C. Backups can be taken only if the database is in ARCHIVELOG mode.
• D. Backups can be done incrementally.
• E. The database must be registered in an RMAN catalog.
• F. Only consistent backups can be created.

Correct answer: C, D

Explanation

The correct answers are C and D because RMAN can perform backups while the database is in ARCHIVELOG mode, allowing for incremental backups. Options A and E are incorrect as RMAN does not require backups to be incremental or the database to be registered in a catalog for open backups, while F is incorrect as RMAN can create inconsistent backups if needed.