Problem description

Oracle incremental data file backup fails with the "RMAN Backup has failed. Please check RMAN logs for more details" error.

Cause

The incremental-start System Change Number (SCN), which was specified when starting an incremental data file backup, is less than the data file's creation SCN. An SCN is a logical, internal time stamp used by the Oracle Database.

Traceback

Follow the instructions provided in the Logs article to retrieve job logs.

Check the Failed_<YYYYMMDD>_<timestamp>_RMAN_UID_xx.log file.

channel ORA_DISK_1: starting incremental level 1 datafile backup set
    channel ORA_DISK_1: specifying datafile(s) in backup set
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/30/2021 22:39:15
    ORA-19645: datafile 69: incremental-start SCN is prior to creation SCN 6244106499081

Resolution

Modify the command used for backup in the script. Specify a larger incremental-start SCN as compared to the data file's creation SCN.

Example command :

BACKUP INCREMENTAL LEVEL 1 DATABASE;

Problem description

Cause

Traceback

Resolution

See also