RMAN-06091

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

NOTE     : As with any code, ensure to test this script in a development environment before attempting to run it in production.

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


Example

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of delete command at 09/05/2018 02:07:25

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



Details



Backups failing due to the following when running any of the following options with "delete obsolete"



RMAN> delete obsolete;

RMAN> delete noprompt obsolete;

RMAN> delete force obsolete;





Solution====> :



Run the following to specify the device type , in this example use device type disk

if baclup on disk use below command

RMAN> delete noprompt obsolete device type disk;

if backup on Tape use below command RMAN> allocate channel for maintenance device type 'sbt_tape' PARMS "XYz";

If the above fails, allocate the appropriate channel for maintenance , perform the appropriate crosschecks and delete option.
In this example the device type disk was allocated for maintenance
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;

RUN
{
report obsolete;
CROSSCHECK BACKUP;
CROSSCHECK COPY;
DELETE EXPIRED BACKUP;
DELETE EXPIRED COPY;
delete obsolete;
}

release channel;

Ref: Encountered RMAN-03002 and RMAN-06091 when Deleting Obsolete Backups [ID 567555.1]