My Oracle Support Banner

RMAN Full Database Backup Takes 6 Times Longer Than Expected (Doc ID 2856405.1)

Last updated on JUNE 13, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

RMAN backup to disk through the following command takes 2 days to complete:
backup as backupset incremental level 0 section size 32g database plus archivelog section size 32g DELETE ALL INPUT;

While on another server with same OS and RDBMS version and similar hardwares (even less CPUs), 
RMAN backup takes 6 hours to complete. 

Part of sample script:


Adding the VALIDATE option to the RMAN command according to note RMAN Performance Troubleshooting (Doc ID 1326686.1),
and with 4 disk channels allocated makes not much difference in performance.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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