RMAN Restore Performance on non-ASM filesystems (Doc ID 1561238.1)

Last updated on AUGUST 18, 2016

Applies to:

Oracle Database - Enterprise Edition
Information in this document applies to any platform.

Symptoms

Using RMAN in 11g Release 2 to create clone database or restore the database can be slower when restoring to a non-ASM filesystem.  
Tests have been conducted using databases which are 100G+ and backups compressed using 'BASIC' compression.  

The test executed the duplicate command using 10gR2 and 11gR2.  
The Oracle10g duplication completed in minutes where the 11g duplication in some cases took over 2 hours.  
The expectation is the restore performance will be similar.

Changes

 Oracle Database 11g Release 2

All RMAN I/O operations with ASM files select an optimal buffer size and count based on the allocation unit (AU) size and disk count of the ASM disk group.

Additional parameters are introduced to give more fine-grained control over RMAN buffer allocations. Although these parameters are supported for all RMAN operations, they are primarily intended for use in non-ASM systems, since RMAN operations in ASM will automatically select an optimal buffer configuration.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms