RMAN-03002 and RMAN-06091 Errors when Deleting Obsolete Backups

When I attempting to delete obsolete backups from RMAN using the following command, the following error was occuring.

RMAN> delete obsolete;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 02/04/2018 20:28:22
RMAN-06091: no channel allocated for maintenance (of an appropriate type)

So Tape channel had not being allocated when attempt to delete obsolete backup on tape.

Please run the following commands to delete obsolete backup sets on both disk and tape:

RMAN> allocate channel for maintenance type disk;
RMAN> allocate channel for maintenance device type ‘sbt_tape’ PARMS ‘…’;
RMAN> delete obsolete;

If you want to delete only obsolete backup sets on disk, you must use the following command.

RMAN> allocate channel for maintenance type disk;
RMAN> delete obsolete device type disk;

Advertisement

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s