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;
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]
