oracle rman delete backupset,rman delete backup问题

谢谢大家的回答, 现总结如下:

物理文件不存在:

1. crosscheck backup;   -- Flags:

2. delete expired backup, --Flags:

物理文件存在:

delete obsolete; 不仅删除过期备份集也同时删除control file 中的备份记录. 因为我看到控制文件变小了. catelog库没有测试

-----------test---------------------------------------------------

1.

RMAN> list expired backup;

specification does not match any backup in the repository

2.

将备份文件 ARCH_B1_1027_1_20120229 改名成 ARCH_B1_1027_1_20120229.bak

3.

crosscheck backup;

4.

RMAN> list expired backup;

List of Backup Sets

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

BS Key  Size       Device Type Elapsed Time Completion Time

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

1023    12.27M     DISK        00:00:02     29-FEB-12

BP Key: 1739   Status: EXPIRED  Compressed: NO  Tag: ARCHIVE ALL BACKUP

Piece Name: D:\TMP\ARCH_B1_1027_1_20120229

List of Archived Logs in backup set 1023

Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

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

1    101     4690974    29-FEB-12 4700404    29-FEB-12

5.

RMAN> delete expired backup;

using channel ORA_DISK_1

List of Backup Pieces

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

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

1739    1023    1   1   EXPIRED     DISK        D:\TMP\ARCH_B1_1027_1_20120229

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