NBU备份归档并删除时报:
RMAN-3002: failure of delete command at 07/24/2018 08:26:03
RMAN-6091: no channel allocated for maintenance (of an appropriate type)
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Incr 0 113.25M SBT_TAPE 00:08:35 01-MAR-08
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: HOT_DB_BK_LEVEL0
Handle: bk_4_1_648250152 Media:
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
5 0 Incr 1342657 01-MAR-08 /<location>/undotbs2
75 0 Incr 1342657 01-MAR-08 /<location>/USER_DAT_08_vg3_002
91 0 Incr 1342657 01-MAR-08 /<location>USER_DAT_12_vg3_002
==>The Device Type is SBT_TAPE.
To implement the solution, please execute the following steps:
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 '...';
==>Please contact your MML(Media Management Layer) vendor to get the actual tape parameters and repalce the '...' .
RMAN> delete obsolete;
If you want to delete obsolete backup sets on disk, you can use the following commands:
RMAN> allocate channel for maintenance type disk;
RMAN> delete obsolete device type disk;
解决办法:
for tape backup:
RMAN> allocate channel for maintenance device type 'sbt_tape' PARMS 'ENV=(NSR_SERVER=, NSR_CLIENT=)';
for disk backup:
RMAN> allocate channel for maintenance device type disk;
MOS文档参考:567555.1