Upgrade Oracle DBA 11g to Oracle Database 12c — Question 46

A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance?

Answer options

• A. Set the backup_tape_io_slaves parameter to true.
• B. Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.
• C. Configure large pool if not already done.
• D. Remove the rate parameter, if specified, in the allocate channel command.
• E. Always use RMAN compression for tape backups rather than the compression provided by media manager.
• F. Always use synchronous I/O for the database.

Correct answer: B, C, D

Explanation

The correct actions to improve backup performance include setting dbwr_io_slaves to a nonzero value to enhance I/O operations during synchronous I/O, configuring a large pool to optimize memory usage, and removing the rate parameter to prevent throttling of backup performance. Options A, E, and F do not directly contribute to improving the backup performance in the context provided.