Thursday 13 November 2014

ANS1126E (RC27) The file space cannot be deleted because this node does not have permission to delete archived or backed up data.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on ORA_MAINT_SBT_TAPE_1 channel at 11/13/2014 12:32:22
ORA-19509: failed to delete sequential file, handle="ntpnen1m_1_1", parms=""
ORA-27027: sbtremove2 returned error
ORA-19511: Error received from media manager layer, error text:
   ANS1126E (RC27)   The file space cannot be deleted because this node does not have
permission to delete archived or backed up data.

The above error has happened in the during running delete obsolete command in the rman.

The reason :
=============
We had rman configured to tape in one server(for ex. 192.18.1.1), where the repository holds the backup information that has taken to tape.

but we had moved the database from 192.18.1.1 to 192.18.1.2 server using rman backup, where we tried to clear the rman repository using delete obsolete.

As new node has no delete permission to node filespace of 192.18.1.1 in tsm storage.


resolution:
============
We need to provide the delete permission to the new node.

Enter into tsm server and check the node name of 192.18.1.2 for eg: TsmnewNode

run the below tsm command to provide permission:

tsm>update node TsmnewNode backdel=y

then run the delete obsolete rman command to delete the rman repository catalog info.