My Oracle Support Banner

RMAN Backup Performance (Doc ID 360443.1)

Last updated on AUGUST 08, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 to 12.1.0.1 [Release 8.1.7 to 12.1]
Information in this document applies to any platform.



Purpose

An rman backup spawns many processes and when a backup is taking a long time to complete it can be difficult to determine the cause.  This note looks at each of those processes and their purpose and offers guidelines for identifying where the time is being spent and if necessary, what additional diagnostics can be set to help resolve the problem. 


Scope

This note is intended for use by Database Administrators and Support personnel investigating RMAN backup performance.  It specifically looks at issues related to the processing of RMAN metadata, the writing of tape backups (though many of the principles discussed are also applicable to disk backups) and how to determine where the time is being spent : in Oracle or in the Media Manager Layer.  Problems related to reading/writing from disk/storage devices are outside the scope of this document.

A basic understanding of RMAN and Oracle is assumed.

Details

To view full details, sign in with your My Oracle Support account.

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


In this Document
Purpose
Scope
Details
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.