Rman Delete obsolete taking time in 10.2.0.4.0
Rman target and the catalog are in 10.2.0.4.0 version. The backups are performed to tape and the PARALLELISM is set to 12.
When a delete obsolete command is executed, there are about 120 backups identified for deletion. This takes a very long time. When checked for the debug trace, we see that there are 3 channels performing the delete operation and each channel is processing all the 120 backup pieces.
Here are the excerpts from the debug trace.
DBGPLSQL: channel ORA_SBT_TAPE_1: processing (file/handle= FULL_ONLINE_DB_11333_1_674532090,recid=22556 , old_status=A, hdl_isdisk=0, devicetype=SBT_TAPE) [17:09:10.060] (change)
DBGPLSQL: channel ORA_SBT_TAPE_1: force: 0 [17:09:10.060] (change)
When a delete obsolete command is executed, there are about 120 backups identified for deletion. This takes a very long time. When checked for the debug trace, we see that there are 3 channels performing the delete operation and each channel is processing all the 120 backup pieces.
Here are the excerpts from the debug trace.
DBGPLSQL: channel ORA_SBT_TAPE_1: processing (file/handle= FULL_ONLINE_DB_11333_1_674532090,recid=22556 , old_status=A, hdl_isdisk=0, devicetype=SBT_TAPE) [17:09:10.060] (change)
DBGPLSQL: channel ORA_SBT_TAPE_1: force: 0 [17:09:10.060] (change)
0