Oracle iDataAgent

You can improve the performance of backup and restore operations by modifying the following parameters for Oracle iDataAgent:

Parameter	Default Value	Description
Number of data files and archive files to be included in each RMAN backup set	32	Increase the value of this parameter for faster backups. However, increasing the value in this parameter will create additional CPU overhead in order to optimize the population of the Archive file. The granular restore of individual table spaces and data files will be slower.
Number of open data files that can be read by RMAN during the backup	8	Reduce the value of this parameter for faster backup and less system load on the Oracle server.
Buffer size used by Oracle agent to transfer data to a storage media	1048576	Increase the value of this parameter for faster tape drives or disk libraries. For Example: For SDLT or LTO tape drives, a minimum value of 1048576 (1MB) is recommended.

Parameter

Default Value

Description

Number of data files and archive files to be included in each RMAN backup set

Increase the value of this parameter for faster backups. However, increasing the value in this parameter will create additional CPU overhead in order to optimize the population of the Archive file. The granular restore of individual table spaces and data files will be slower.

Number of open data files that can be read by RMAN during the backup

Reduce the value of this parameter for faster backup and less system load on the Oracle server.

Buffer size used by Oracle agent to transfer data to a storage media

1048576

Increase the value of this parameter for faster tape drives or disk libraries.

For Example: For SDLT or LTO tape drives, a minimum value of 1048576 (1MB) is recommended.

For more information on how to setup these parameters, refer to Enhancing Backup Performance.

Also, if you are experiencing performance issues during backup, you can troubleshoot them by enabling logging of performance details in the log files. These performance counters contain information that help in resolving the performance related issues during backups. See Troubleshooting Performance Issues for more information.