Oracle incremental data file backup fails with the "RMAN Backup has failed. Please check RMAN logs for more details" error
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;