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;