Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Any way to delete multiple backup pieces in one go?

TomMay 17 2016 — edited May 19 2016

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 16 2016
Added on May 17 2016
9 comments
3,050 views