This discussion is archived
4 Replies Latest reply: Apr 18, 2013 12:08 PM by 970775 RSS

RMAN fails to delete obsolete backup in OSB

800104 Newbie
Currently Being Moderated
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..

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points