RUN {
    CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    CONFIGURE COMPRESSION ALGORITHM 'BASIC';

    # Full backup COMPRESSED + Archive logs (șterge logs după backup)
    # FORMAT: L0_<dbname>_<YYYYMMDD>_<set#>_<piece#>
    # Files will be stored in recovery area for easier transfer to DR
    BACKUP AS COMPRESSED BACKUPSET
        INCREMENTAL LEVEL 0
        TAG 'DAILY_FULL_COMPRESSED'
        FORMAT 'C:\Users\oracle\recovery_area\ROA\autobackup\L0_%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 Control File
    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;

    # Cleanup old backups (păstrează ultimele 2 - REDUNDANCY 2)
    DELETE NOPROMPT OBSOLETE;
}
