Level 1 backup created when no level 0 exists
Last updated on OCTOBER 12, 2016
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.5
Information in this document applies to any platform.
If no level 0 backup is available, then the behavior depends upon the compatibility mode setting. If compatibility is >=10.0.0, RMAN copies all blocks changed since the file was created, and stores the results as a level 1 backup. In other words, the SCN at the time the incremental backup is taken is the file creation SCN. If compatibility <10.0.0, RMAN generates a level 0 backup of the file contents at the time of the backup, to be consistent with the behavior in previous releases.
It's possible to execute the following query to check whether the level 1 backup has been created using the above method:
SQL> select file#, creation_change#, incremental_change#, checkpoint_change# from
v$backup_datafile where file# >0;
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