[LuizVaz]

Ao executar o comando abaixo no RMAN (windows), aparece o erro RMAN-08137 no passo em que os arquivos são deletados.

 
C:\>rman target=/
run {
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
crosscheck backup of database;
delete expired backup of database;
crosscheck backup of archivelog all;
delete expired backup of archivelog all;
delete archivelog until time 'sysdate -7';
delete obsolete;
}

O problema é que os arquivos não foram marcados como backup.
Por algum motivo algum arquivo não está no disco ou local original.
Como o backup não encontrou, eles continuam marcados como necessários.

Isso pode ser verificado usando o comando abaixo:

 
RMAN> backup ARCHIVELOG UNTIL TIME 'sysdate-7' not backed up 1 times;
Starting backup at 24-OCT-09
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=117 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 10/24/2009 15:46:36
RMAN-06059: expected archived log not found, lost of archived log compromises re
coverability
ORA-19625: error identifying file E:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\AR
CHIVELOG\2009_02_19\O1_MF_1_860_4STHO6DP_.ARC
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

Para resolver, o RMAN precisa verificar os archives:

 
 
RMAN> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

RMAN> CROSSCHECK ARCHIVELOG ALL;
ou
RMAN> CROSSCHECK ARCHIVELOG ALL COMPLETED AFTER 'SYSDATE-7';

RMAN> CROSSCHECK BACKUP;
RMAN> CROSSCHECK COPY;
RMAN> CROSSCHECK backup of database;
RMAN> CROSSCHECK backup of controlfile;
RMAN> CROSSCHECK BACKUP COMPLETED AFTER 'SYSDATE-7';

Após isso podemos excluir os desnecessários:

 
RMAN> DELETE EXPIRED ARCHIVELOG ALL;
RMAN> CHANGE ARCHIVELOG UNTIL TIME 'SYSDATE-7' DELETE;

Mas se você ainda receber alguma mensagem de erro, você tem que voltar o backup dos arquivos para o disco e efetuar novamente o crosscheck.

 
RMAN-08137: WARNING: archived log not deleted as it is still needed
archived log file name=E:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\20
09_10_13\O1_MF_1_2617_5FBD5GV1_.ARC thread=1 sequence=2617
 
RMAN> CROSSCHECK ARCHIVELOG SEQUENCE 2617;
 
RMAN> crosscheck archivelog sequence 2617;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=110 device type=DISK
validation succeeded for archived log
archived log file name=E:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\20
09_10_13\O1_MF_1_2617_5FBD5GV1_.ARC RECID=5140 STAMP=700182022
validation succeeded for archived log
archived log file name=E:\APP\ADMINISTRATOR\PRODUCT\11.1.0\DB_1\RDBMS\ARC02617_0
669143587.001 RECID=5139 STAMP=700182022
Crosschecked 2 objects
 
RMAN> backup ARCHIVELOG UNTIL TIME 'sysdate-7' not backed up 1 times;
Starting backup at 24-OCT-09
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=2617 RECID=5139 STAMP=700182022
channel ORA_DISK_1: starting piece 1 at 24-OCT-09

Agora, após terminar o backup, podemos excluir os archivelogs.


LuizVaz.