oracle快速备份全库,做了两次rman 全库备份，如何快速删除第一次的备份？-CSDN博客

[20160728]删除备份集问题.txt

--itpub有人问的问题，链接：http://www.itpub.net/thread-2064530-1-1.html

做了两次rman 全库备份，如何快速删除第一次的备份？

或者做了三次全库备份，要删除任意一次的全库备份，如何操作？求教

有没有什么快速的办法

我觉得比较好的方法是使用tag标识：

1.测试例子：

SCOTT@book> @ &r/ver1

PORT_STRING VERSION BANNER

------------------------------ -------------- --------------------------------------------------------------------------------

x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

RMAN> backup database format '/home/oracle/backup/full0728_%U.bak' filesperset=1 tag='full0728';

RMAN> list backupset summary;

List of Backups

===============

Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag

------- -- -- - ----------- ------------------- ------- ------- ---------- ---

103 B F A DISK 2016-07-28 15:47:22 1 1 NO FULL0728

104 B F A DISK 2016-07-28 15:47:25 1 1 NO FULL0728

105 B F A DISK 2016-07-28 15:47:30 1 1 NO FULL0728

106 B F A DISK 2016-07-28 15:47:31 1 1 NO FULL0728

107 B F A DISK 2016-07-28 15:47:31 1 1 NO FULL0728

108 B F A DISK 2016-07-28 15:47:33 1 1 NO FULL0728

109 B F A DISK 2016-07-28 15:47:34 1 1 NO FULL0728

110 B F A DISK 2016-07-28 15:47:34 1 1 NO FULL0728

111 B F A DISK 2016-07-28 15:47:34 1 1 NO FULL0728

$ ls -l /home/oracle/backup/

total 2743252

-rw-r----- 1 oracle oinstall 2004213760 2016-07-28 15:47:27 full0728_6mrbrdca_1_1.bak

-rw-r----- 1 oracle oinstall 3104768 2016-07-28 15:47:22 full0728_6nrbrdca_1_1.bak

-rw-r----- 1 oracle oinstall 702005248 2016-07-28 15:47:24 full0728_6orbrdca_1_1.bak

-rw-r----- 1 oracle oinstall 72187904 2016-07-28 15:47:23 full0728_6prbrdcb_1_1.bak

-rw-r----- 1 oracle oinstall 7069696 2016-07-28 15:47:31 full0728_6qrbrdce_1_1.bak

-rw-r----- 1 oracle oinstall 1089536 2016-07-28 15:47:33 full0728_6rrbrdcl_1_1.bak

-rw-r----- 1 oracle oinstall 10190848 2016-07-28 15:47:34 full0728_6srbrdcl_1_1.bak

-rw-r----- 1 oracle oinstall 1089536 2016-07-28 15:47:34 full0728_6trbrdcm_1_1.bak

-rw-r----- 1 oracle oinstall 98304 2016-07-28 15:47:34 full0728_6urbrdcm_1_1.bak

RMAN> delete backupset tag 'FULL0728' ;

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

List of Backup Pieces

BP Key BS Key Pc# Cp# Status Device Type Piece Name

------- ------- --- --- ----------- ----------- ----------

104 103 1 1 AVAILABLE DISK /home/oracle/backup/full0728_6nrbrdca_1_1.bak

105 104 1 1 AVAILABLE DISK /home/oracle/backup/full0728_6prbrdcb_1_1.bak

106 105 1 1 AVAILABLE DISK /home/oracle/backup/full0728_6orbrdca_1_1.bak

107 106 1 1 AVAILABLE DISK /home/oracle/backup/full0728_6mrbrdca_1_1.bak

108 107 1 1 AVAILABLE DISK /home/oracle/backup/full0728_6qrbrdce_1_1.bak

109 108 1 1 AVAILABLE DISK /home/oracle/backup/full0728_6rrbrdcl_1_1.bak

110 109 1 1 AVAILABLE DISK /home/oracle/backup/full0728_6trbrdcm_1_1.bak

111 110 1 1 AVAILABLE DISK /home/oracle/backup/full0728_6urbrdcm_1_1.bak

112 111 1 1 AVAILABLE DISK /home/oracle/backup/full0728_6srbrdcl_1_1.bak

Do you really want to delete the above objects (enter YES or NO)? yes

deleted backup piece

backup piece handle=/home/oracle/backup/full0728_6nrbrdca_1_1.bak RECID=104 STAMP=918402442

deleted backup piece

backup piece handle=/home/oracle/backup/full0728_6prbrdcb_1_1.bak RECID=105 STAMP=918402443

deleted backup piece

backup piece handle=/home/oracle/backup/full0728_6orbrdca_1_1.bak RECID=106 STAMP=918402442

deleted backup piece

backup piece handle=/home/oracle/backup/full0728_6mrbrdca_1_1.bak RECID=107 STAMP=918402442

deleted backup piece

backup piece handle=/home/oracle/backup/full0728_6qrbrdce_1_1.bak RECID=108 STAMP=918402446

deleted backup piece

backup piece handle=/home/oracle/backup/full0728_6rrbrdcl_1_1.bak RECID=109 STAMP=918402453

deleted backup piece

backup piece handle=/home/oracle/backup/full0728_6trbrdcm_1_1.bak RECID=110 STAMP=918402454

deleted backup piece

backup piece handle=/home/oracle/backup/full0728_6urbrdcm_1_1.bak RECID=111 STAMP=918402454

deleted backup piece

backup piece handle=/home/oracle/backup/full0728_6srbrdcl_1_1.bak RECID=112 STAMP=918402454

Deleted 9 objects