RMAN incremental level 1 backup larger than previous incremental level 0 backup (Doc ID 465420.1)

Last updated on NOVEMBER 29, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 29-Nov-2013***


Symptoms

RMAN level 1 incremental backups are larger than the level 0 incremental backup. Even after taking a new level 0 incremental backup followed immediately by a new level 1 incremental backup,  the level 1 incremental backup is significantly larger than the level 0 incremental backup. The size difference is that their level 0 incremental backup is 2.4GB and the level 1 incremental backup is 10.7GB.

Backup scripts for the level 0 incremental and level 1 incremental are as follows:


BACKUP INCREMENTAL LEVEL 0 DATABASE PLUS ARCHIVELOG;

BACKUP INCREMENTAL LEVEL 1 DATABASE PLUS ARCHIVELOG;

 

There are no errors during either backup.

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