Oracle Database Administration II — Question 38

Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)

Answer options

• A. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in the MOUNT state.
• B. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in MOUNT state.
• C. An Oracle database can be restored from backup files copied using O/S utilities.
• D. Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.
• E. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.
• F. Oracle archive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.
• G. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in OPEN state.

Correct answer: C, D, E

Explanation

Option C is correct because an Oracle database can indeed be restored from backup files that were copied using O/S utilities. Option D is accurate as Oracle data file backups made with O/S utilities can be registered in the RMAN catalog as IMAGE COPIES. Option E is also correct since backing up in NOARCHIVELOG mode requires the database instance to be shut down. The other options either incorrectly state the state of the database required for backups or do not align with RMAN practices.