Skip to main content
All CollectionsKnowledge BaseEnterprise WorkloadsTroubleshooting - Enterprise Workloads
Oracle incremental data file backup fails with the "RMAN Backup has failed. Please check RMAN logs for more details" error
Oracle incremental data file backup fails with the "RMAN Backup has failed. Please check RMAN logs for more details" error
Updated over a week 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?