4 Replies Latest reply: Apr 18, 2013 2:08 PM by user9344546 RSS

    RMAN fails to delete obsolete backup in OSB

    800104
      Hi All,

      I am trying to delete my obsolete backups through RMAN and I get this error:

      ORA-19511: Error received from media manager layer, error text:
      sbt__rpc_cat_delete: delete failed for piece 0hmlsu6q_1_2 (Oracle Secure Backup error: user does not have sufficient rights)


      I am not clear why Oracle Secure backup throws error that the user does not have sufficient rights./.


      Below are the commands that I am using in the script:

      3> ALLOCATE CHANNEL TAPE01 DEVICE TYPE SBT_TAPE;
      4> CROSSCHECK BACKUP;
      5> CROSSCHECK ARCHIVELOG ALL;
      6> CROSSCHECK COPY;
      7> report obsolete recovery window of 60 days device type
      8> report obsolete recovery window of 7 days device type disk
      9> delete noprompt obsolete recovery window of 60 days device type SBT_TAPE;
      10> delete noprompt obsolete recovery window of 7 days device type DISK;


      Any help is appreciated..

      Thanks..