2012-11-24 - 11-25 11gR2 "Backup and Recovery User's Guide" page 425 - 442

 

 

Tuning RMAN Backup Performance -- RMAN的性能调优
Step 1: Remove the RATE Parameter from Channel Settings
As explained in "RATE Channel Parameter" on page 22-5, the RATE parameter on a
channel is intended to reduce, rather than increase, backup throughput so that more
disk bandwidth is available for other database operations. If the backup is not
streaming to tape, then confirm that the RATE parameter is not set.
-- RATE参数，更多时候用来减少RMAN的THROUGHPUT

 

Step 2: If You Use Synchronous Disk I/O, Set DBWR_IO_SLAVES
As explained in "Synchronous and Asynchronous Disk I/O" on page 22-5, some
operating systems support native asynchronous I/O. If and only if your disk does not
support asynchronous I/O, then set DBWR_IO_SLAVES. Any nonzero value for DBWR_
IO_SLAVES causes a fixed number of disk I/O slaves to be used for backup and
restore, which simulates asynchronous I/O.
-- 设置DBWR_IO_SLAVES，当你使用同步IO特性的时候

 

Step 3: If You Fail to Allocate Shared Memory, Set LARGE_POOL_SIZE
Set the LARGE_POOL_SIZE initialization parameter if the database reports an error in
the alert log stating that it does not have enough memory and that it will not start I/O
slaves. The message should resemble the following:
ksfqxcre: failure to allocate shared memory means sync I/O will be used whenever
async I/O to file not supported natively
The large pool is used for RMAN and for other purposes, so its total size should
accommodate all uses. This is especially true if DBWR_IO_SLAVES has been set and the
DBWR process needs buffers.
-- 设置LARGE_POOL_SIZE
LARGE_POOL_SIZE = number_of_allocated_channels *
(16 MB + ( 4 * size_of_tape_buffer ) )

Step 4: Tune the Read, Write, and Copy Phases
Using Backup Validation To Distinguish Between Read and Write Bottlenecks
One reliable way to determine whether the output device or input disk I/O is the
bottleneck in a given backup job is to compare the time required to run backup tasks
with the time required to run BACKUP VALIDATE of the same tasks. BACKUP
VALIDATE of a backup performs the same disk reads as a real backup but performs no
I/O to an output device.
-- BACKUP与BACKUP VALIDATE去比较，看是写瓶颈还是读瓶颈

 

Compare the backup times for the validation and real backup.
If the time for the BACKUP VALIDATE to tape is about the same as the time for a
real backup to tape, then reading from disk is the likely bottleneck.
-- 读瓶颈
If the time for the BACKUP VALIDATE to tape is significantly less than the time for
a real backup to tape, then writing to the output device is the likely bottleneck.
-- 写瓶颈