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

Last updated on MARCH 14, 2023

Applies to:

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 '/<path>/WEEKLY_YYYYMMDD_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 '/<path>/DAILY_YYYYMMDD_db_%d_%U' TAG='DAILY' keep until time 'trunc(sysdate)+1';

Changes

Cause

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