RUN {
    # Incremental Level 1 CUMULATIVE backup
    # Backup doar modificările de la ultimul Level 0 (full backup de la 02:00 AM)
    # FORMAT: L1_<dbname>_<YYYYMMDD>_<set#>_<piece#>
    # Files will be stored in recovery area for easier transfer to DR
    BACKUP AS COMPRESSED BACKUPSET
        INCREMENTAL LEVEL 1 CUMULATIVE
        TAG 'MIDDAY_INCREMENTAL'
        FORMAT 'C:\Users\oracle\recovery_area\ROA\autobackup\L1_%d_%T_%s_%p.BKP'
        DATABASE
        PLUS ARCHIVELOG DELETE INPUT
        FORMAT 'C:\Users\oracle\recovery_area\ROA\autobackup\ARC_%d_%T_%s_%p.BKP';

    # Backup SPFILE și controlfile (pentru siguranță)
    BACKUP AS COMPRESSED BACKUPSET
        TAG 'SPFILE_BACKUP'
        FORMAT 'C:\Users\oracle\recovery_area\ROA\autobackup\SPFILE_%d_%T_%s_%p.BKP'
        SPFILE;
    
    BACKUP
        TAG 'CONTROLFILE_BACKUP'
        FORMAT 'C:\Users\oracle\recovery_area\ROA\autobackup\CF_%d_%T_%s_%p.BKP'
        CURRENT CONTROLFILE;

    # NU ștergem obsolete aici - se face la full backup
}
