My Oracle Support Banner

RMAN incremental backup does not appear to create a level 0 if no previous level 0 exists (Doc ID 1372616.1)

Last updated on NOVEMBER 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.


When creating incremental backups, if no incremental level 0 exists the rman online documentation states:

"A level 0 backup must exist for each data file in the BACKUP command as the base backup for an incremental strategy.  Level 0 backups must not have status UNAVAILABLE.  If no level 0 backup exists, then RMAN makes a level 0 backup automatically."

Yet the backup log shows:

Starting backup at 01-nov-11 14:48:11
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting compressed incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set

This suggests that rman is creating an incremental backup rather than an automatic level 0 as the documentation specifies.


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

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