RMAN有没有只删除备份集的命令

显示全部楼层 · 2007-9-26 18:42:10

delete obsolete; 会把很多过期的东西给删了。虽然我每天都做全备，可不希望它把控制文件，归档日志文件给删了。
delete obsolete of backupset 命令呢？

千问 · 2007-9-26 18:42:10

Delete命令可以用来删除指定的备份或者用来删除废弃或者是过期的备份集
如删除指定的备份集与备份片
RMAN> DELETE BACKUPPIECE 101;
RMAN> DELETE CONTROLFILECOPY '/tmp/control01.ctl';
RMAN> DELETE BACKUP OF TABLESPACE users DEVICE TYPE sbt;
删除过期或者废弃了的备份
RMAN> DELETE EXPIRED BACKUP;
RMAN> DELETE NOPROMPT OBSOLETE;
RMAN> DELETE OBSOLETE REDUNDANCY = 3;
RMAN> DELETE OBSOLETE RECOVERY WINDOW OF 7 DAYS;
删除指定的备份归档
RMAN> DELETE NOPROMPT ARCHIVELOG UNTIL SEQUENCE = 300;

千问 · 2007-9-26 18:42:10

delete noprompt backupset completed before 'sysdate-7'; 删除当前系统时间7天前的backupset

千问 · 2007-9-26 18:42:10

那么 delete backupset 可不可以逻辑和物理一起删除备份集呢？删除默认过期的备份集？

千问 · 2007-9-26 18:42:10

原帖由 zengmuansha 于 2008-4-10 09:56 发表
那么 delete backupset 可不可以逻辑和物理一起删除备份集呢？删除默认过期的备份集？
逻辑和物理一起删除

千问 · 2007-9-26 18:42:10

delete 全集,不错的.