RMAN Incremental Level 1 Backup Keeps Taking Level 0 Backup Despite The Level 0 Backup Present. (Doc ID 1499126.1)

Last updated on OCTOBER 16, 2012

Applies to:

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

Symptoms

When running level 1 backup after a successful level 0 backup getting messages in the backup log and the incremental level 1 backup ends up taking a level 0 backup. 

Messages are like this:
no parent backup or copy of datafile 49 found
no parent backup or copy of datafile 155 found
no parent backup or copy of datafile 40 found
no parent backup or copy of datafile 28 found

 

Incremental level 0 backup script:
BACKUP INCREMENTAL LEVEL 0 CUMULATIVE DATABASE INCLUDE CURRENT CONTROLFILE SKIP INACCESSIBLE FILESPERSET 5 FORMAT '/recovery/WEEKLY_20121001_db_%d_%U' TAG='WEEKLY' keep until time 'trunc(sysdate)+7';


Incremental level 1 backup script:
BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE INCLUDE CURRENT CONTROLFILE SKIP INACCESSIBLE FILESPERSET 5 FORMAT '/recovery/DAILY_20121001_db_%d_%U' TAG='DAILY' keep until time 'trunc(sysdate)+1';

 

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