Oracle Database 12c: Advanced Administration — Question 155

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 answers B, C, and D are effective in optimizing backup performance. Setting the dbwr_io_slaves parameter helps manage I/O more efficiently, configuring the large pool improves memory management for backups, and removing the rate parameter allows for more flexible channel allocation. Options A, E, and F do not directly enhance backup performance in the same way, making them less relevant for this scenario.