Se eu estiver errado me corrijam, a política de retensão REDUNDANCY ele sempre guarda o numerop de backups + 1 que você seta na configuração, no seu caso REDUNDANCY 2, ele guarda 3 backups full.
Em Segunda-feira, 24 de Fevereiro de 2014 9:30, Ednilson Silva <[email protected]> escreveu: Pessoal, Tive alguns imprevistos aqui na empresa e acabei deixando de lado o rman, retomando fiz as config abaixo e criei dois scripts para fazer um backup diário (Segunda a Sábado) e outro semanal (Domingo) conforme ensinamentos do mestre Ederson. Algo que não entendi bem, o RMAN esta com REDUNDANCY 2, não deveria manter apenas dois backup? [root@mtzbdofv01 rman]# ls -lh -rw-r----- 1 oracle10 dba 6.8G Feb 20 10:23 DBSIM3G_3559765569_118.rman -rw-r----- 1 oracle10 dba 59M Feb 20 10:23 DBSIM3G_3559765569_119.rman -rw-r----- 1 oracle10 dba 1.6G Feb 20 20:05 DBSIM3G_3559765569_121.rman -rw-r----- 1 oracle10 dba 1003M Feb 20 20:11 DBSIM3G_3559765569_122.rman -rw-r----- 1 oracle10 dba 5.4M Feb 20 20:11 DBSIM3G_3559765569_123.rman -rw-r----- 1 oracle10 dba 1.8G Feb 21 20:05 DBSIM3G_3559765569_125.rman -rw-r----- 1 oracle10 dba 1.5G Feb 21 20:13 DBSIM3G_3559765569_126.rman -rw-r----- 1 oracle10 dba 5.4M Feb 21 20:13 DBSIM3G_3559765569_127.rman -rw-r----- 1 oracle10 dba 377M Feb 22 20:01 DBSIM3G_3559765569_129.rman -rw-r----- 1 oracle10 dba 264M Feb 22 20:05 DBSIM3G_3559765569_130.rman -rw-r----- 1 oracle10 dba 3.8M Feb 22 20:05 DBSIM3G_3559765569_131.rman -rw-r----- 1 oracle10 dba 150M Feb 23 10:00 DBSIM3G_3559765569_133.rman -rw-r----- 1 oracle10 dba 6.7G Feb 23 10:23 DBSIM3G_3559765569_134.rman -rw-r----- 1 oracle10 dba 5.3M Feb 23 10:23 DBSIM3G_3559765569_135.rman -rw-r----- 1 oracle10 dba 13M Feb 23 10:23 snapcf_dbSim3g.f -rw-r----- 1 oracle10 dba 13M Feb 23 10:23 DBSIM3G_c-3559765569-20140223-00.cf ----------------------------------------------------------------------------------------- CONFIG RMAN RMAN> show all; using target database control file instead of recovery catalog RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REDUNDANCY 2; CONFIGURE BACKUP OPTIMIZATION ON; CONFIGURE DEFAULT DEVICE TYPE TO DISK; CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/d01/backup/dbSim3g/rman/%d_%F.cf'; CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COMPRESSED BACKUPSET; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/d01/backup/dbSim3g/rman/%d_%I_%s.rman'; 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 '/d01/backup/dbSim3g/rman/snapcf_dbSim3g.f'; ----------------------------------------------------------------------------------------- BACKUP DIARIO ORACLE_SID=dbSim3g ORACLE_HOME=/d01/app/oracle/product/10gR2 PATH=/d01/app/oracle/product/10gR2/bin rman target=/ log=/d01/backup/dbSim3g/logs/backup_diario.log << EOF RUN { crosscheck archivelog all; BACKUP incremental level 1 DATABASE PLUS ARCHIVELOG; } EXIT; EOF ----------------------------------------------------------------------------------------- BACKUP SEMANAL ORACLE_SID=dbSim3g ORACLE_HOME=/d01/app/oracle/product/10gR2 PATH=/d01/app/oracle/product/10gR2/bin rman target=/ log=/d01/backup/dbSim3g/logs/backup_semanal.log << EOF RUN { crosscheck archivelog all; crosscheck backup; BACKUP AS COMPRESSED BACKUPSET incremental level 0 DATABASE PLUS ARCHIVELOG delete all input; delete noprompt obsolete; } EXIT; EOF Grato Ednilson Silva
