Oracle version: 11.2.0.4
Platform : RHEL/Oracle Linux 6.4, 6.5
How can I delete multiple backup pieces in one go? As I understand, the DELETE command doesn't work directly with backup pieces.
RMAN> delete noprompt backup '/ora_bkp/RMAN/ORCL/ORCL_1er5qrgs_1_1' ;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "single-quoted-string": expecting one of: "backed, completed, controlfile, device, for, like, of, tag, ;"
RMAN-01007: at line 1 column 24 file: standard input
I tried putting several tag numbers as comma separated values. But, it didn't work as shown below.
RMAN> list backup summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
37 B A A DISK 17-MAY-16 1 1 NO TAG20160517T115601
41 B A A DISK 17-MAY-16 1 1 NO TAG20160517T121614
42 B 0 A DISK 17-MAY-16 1 1 NO DAILYFULL
43 B 0 A DISK 17-MAY-16 1 1 NO DAILYFULL
44 B A A DISK 17-MAY-16 1 1 NO TAG20160517T122026
45 B A A DISK 17-MAY-16 1 1 NO TAG20160517T150458
RMAN> delete noprompt backup tag=TAG20160517T115601,TAG20160517T121614;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "comma": expecting one of: "backed, completed, device, for, like, tag, ;"
RMAN-01007: at line 1 column 46 file: standard input
RMAN> exit