RMAN-06091: no channel allocated for maintenance (of an appropriate type)

Se você está tentando apagar o backup dos archivelogs e está recebendo o erro RMAN-06091: no channel allocated for maintenance (of an appropriate type). Ou se seu script de backup começou a dar o erro. Siga esse tutorial:

RMAN-03002: failure of delete command at 09/04/2018 14:15:18
RMAN-06091: no channel allocated for maintenance (of an appropriate type)

Saiba que deletar os backups obsoletos pode resolver o problema acima. Vamos então para as soluções:

Resolver problema para backup em TAPE (Fita):

RMAN> allocate channel for maintenance device type 'sbt_tape' PARMS 'ENV=(NSR_SERVER=, NSR_CLIENT=)'; 
RMAN> delete obsolete; 
RMAN> crosscheck archivelog all; 
RMAN> delete archivelog all backed up 2 times to sba_tape; 
RMAN> crosscheck archivelog all;

Resolver problema para backup em disco:

RMAN> allocate channel for maintenance device type disk; 
RMAN> delete obsolete device type disk; 
RMAN> crosscheck archivelog all; 
RMAN> delete archivelog all backed up 2 times to sba_tape; 
RMAN> crosscheck archivelog all;

Ao executar os comandos acima, encontramos em alguns casos os erros: RMAN-03002 and RMAN-06091 when Deleting Obsolete Backups (Doc ID 567555.1)

Caso o procedimento falhe, tente as soluções de contorno abaixo:

run{
allocate channel ch1 type 'sbt_tape' parms 'ENV=(NSR_SERVER=, NSR_CLIENT=)';
backup archivelog all format 'arc_%t_%p_%u';
backup current controlfile format 'ctrl_%t_%s_%p_%u_%c';
release channel ch1;
allocate channel ch2 type disk;
delete noprompt archivelog all backed up 2 times to device type sbt_tape;
crosscheck archivelog all;
release channel ch2;
}

Para comandos de crosscheck e delete, você precisa de um disk channel. Esse é um erro conhecido e você pode encontrar mais informações aqui. Seguem os bugs relacionados ao RMAN-06091:

• RMAN Backup Returns RMAN-06091: No Channel Allocated For Maintenance (of An Appropriate Type) After Applying July (DBPSU/BP/RU) (Doc ID 2428682.1)
• Bug 28432129: RMAN-06091: no channel allocated for maintenance (of an appropriate type) after installing July 2018 (DBPSU/BP/RU) (Note 28432129.8)
• Bug:30298575 DELETE NOPROMPT OBSOLETE FAILURE FOR BACKUPS CONFIGURED USING BKUP_API ON OCI EXACS
• Bug 28432129 – RMAN-06091: no channel allocated for maintenance (of an appropriate type) after installing July 2018 (DBPSU/BP/RU) (Doc ID 28432129.8)

Uma das mensagens de erro do RMAN-06091:

RMAN>delete obsolete;
...
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 02/07/2020 09:55:39
RMAN-06091: no channel allocated for maintenance (of an appropriate type)

Soluções de contorno

Adicione um disk maintenance channel para deletar backups obsoletos no disco:

run {
ALLOCATE CHANNEL ch1 DEVICE TYPE DISK;
backup incremental level 1 database include current controlfile;
release channel ch1;
}
 
crosscheck backup;
 
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
DELETE NOPROMPT OBSOLETE;
RELEASE CHANNEL;

Adicione um tape maintenance channel para deletar backups obsoletos em fita:

run {
ALLOCATE CHANNEL ch1 DEVICE TYPE 'SBT_TAPE' PARMS '...';
backup incremental level 1 database include current controlfile;
release channel ch1;
}
 
crosscheck backup;
 
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE 'SBT_TAPE' PARMS '...';
DELETE NOPROMPT OBSOLETE;
RELEASE CHANNEL;