RMAN incremental level 1 backup larger than previous incremental level 0 backup
Last updated on JANUARY 02, 2018
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***
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.
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