Skip to main content

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

Updated over 8 months ago

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

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

  2. 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;

See also

Did this answer your question?