Veritas NetBackup™ Appliance Capacity Planning and Performance Tuning Guide
- About this Guide
- Section I. Capacity planning
- Section II. Best Practices
- Section III. Performance tuning
- Section IV. Quick reference to Capacity planning and Performance tuning
About Oracle backup and restore performance tuning
When you are backing up or restoring a large database on 53xx, the following tuning can substantially improve Oracle backup and restore performance:
Set "ORACLE_OVERRIED_DATA_MOVEMENT = 1".
This setting disables the default proxy based mode when MSDP media is used. The parameter is set in the
bp.conf
file of NetBackup client under the directory/usr/openv/netbackup
.NBU_Client# cd /usr/openv/netbackup/
NBU_Client# more bp.conf
SERVER = nburdb01-bond0 SERVER = nbapp577-bond0 CLIENT_NAME = nburdb05-bond0 CONNECT_OPTIONS = localhost 1 0 2 ORACLE_OVERRIDE_DATA_MOVEMENT = 1
In stream-based mode, restore and backup can be processed in multiple parallel streams. With up to 12 mounted file system in 53xx and multiple RMAN channel configured, the Oracle backup/restore can improve substantially. In an internal test, stream-based mode outperforms proxy mode by over 300%.
Optimal Database storage layout: With the above tuning, 53xx Appliance can process substantial amount of Oracle data. However, to achieve the desired backup and restore performance, the I/O subsystem on the Oracle client must be able to perform at the same level. For example, to backup a 25TB database within 10 hours, the oracle client must be able to read at least 2.5TB of data per hour and the network must be able to transmit at least 2.5TB of backup data.
Choose appropriate RMAN setting: Default RMAN backup sets maxopenfiles=8, which can create high I/O contention on the Oracle client. When maxopenfiles=8 occurs in combination with 20 RMAN channels, there could be 160 parallel reads (8 * 20) on any given time during backup. To reduce the I/O contention, lowering the value of
maxopenfile
parameter can help improve overall performance. Internal tests with maxopenfiles=1 yield better performance than the default.