Backup de Archive Log

[rmanParticipante]

@felipeg

Segue o script de backup FULL implementado diariamente via CRON.


connect target /
SPOOL log to /oracle/backup1/backupRMAN/smt/backup_FULL_RMAN_$DATA/LOG_BKP_RMAN.log;
run {
DELETE NOPROMPT EXPIRED BACKUP;
DELETE NOPROMPT obsolete device type disk;
CROSSCHECK BACKUP;
CROSSCHECK COPY;
CROSSCHECK archivelog all;
CROSSCHECK backup of database;
CROSSCHECK backup of archivelog all;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oracle/backup1/backupRMAN/smt/backup_FULL_RMAN_$DATA/controlfile.ctl%F';
allocate channel d1 type disk format '/oracle/backup1/backupRMAN/smt/backup_FULL_RMAN_$DATA/bkp_%U';
backup as compressed backupset format '/oracle/backup1/backupRMAN/smt/backup_FULL_RMAN_$DATA/backupfull%d_%T_%U.dbf' database;
backup as compressed backupset format '/oracle/backup1/backupRMAN/smt/backup_FULL_RMAN_$DATA/Archivelog_%d_%u.arc' archivelog all;
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
release channel d1;}
SPOOL log off;
exit


Segue as configurações permanentes:


RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oracle/backup1/backupRMAN/smt/backup_FULL_RMAN_301111/controlfile.ctl%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/app/product/10.2.0/smt/dbs/snapcf_smt.f'; # default


Não consegui identificar onde é definido a politica de retenção do archive log. Mas que eles estão sendo apagado eu tenho certeza.