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


When backing up archive logs, RMAN script ended with below errors. actually backup finished successfully. but when delete backed up archive logs, RMAN ended with error because of obsolete backups.

This error is related with the reported in Bug 28391990, which has been superseded by the fix of unpublished Bug 28432129:

Bug 28432129: RMAN-06091: no channel allocated for maintenance (of an appropriate type) after installing July 2018 (DBPSU/BP/RU) (Note 28432129.8)
Fixed Version : 19.1

 Error:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 01/06/2024 08:27:46
RMAN-06091: no channel allocated for maintenance (of an appropriate type)

 Solution:

We should delete the obsolete backups as follows.

 

If you are using the Tape backup, then run the following commands.


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

RMAN> crosscheck archivelog all;

 

If you are using the Disk backup, then run the following commands.

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

RMAN> crosscheck archivelog all;




If you like please follow and comment