ITPub博客

首页 > 数据库 > Oracle > Backup And Recovery User's Guide-从RMAN开始-维护RMAN备份-删除过期的备份

Backup And Recovery User's Guide-从RMAN开始-维护RMAN备份-删除过期的备份

原创 Oracle 作者:luisedalian 时间:2014-02-13 17:27:37 0 删除 编辑

DELETE命令会从磁盘或磁带删除备份和拷贝,在控制文件库中更新文件的状态为DELETED

(如果使用catalog,还会从recovery catalog中删除相应的记录)

如果你是交互地执行RMAN,并且没有指定NOMPROMPT选项,则DELETE命令会显示文件列表,在删除之前要求确认。

RMAN> delete obsolete;

 

RMAN retention policy will be applied to the command

RMAN retention policy is set to redundancy 1

using channel ORA_DISK_1

Deleting the following obsolete backups and copies:

Type                 Key    Completion Time    Filename/Handle

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

Archive Log          1      06-JUL-13          /u01/app/oracle/fast_recovery_area/TESTDB12/archivelog/2013_07_06/o1_mf_1_9_8xkf4h9k_.arc

Backup Set           1      06-JUL-13        

  Backup Piece       1      06-JUL-13          /u01/app/oracle/fast_recovery_area/TESTDB12/backupset/2013_07_06/o1_mf_nnndf_TAG20130706T192144_8xk9n8of_.bkp

Backup Set           3      06-JUL-13        

  Backup Piece       3      06-JUL-13          /u01/app/oracle/fast_recovery_area/TESTDB12/backupset/2013_07_06/o1_mf_annnn_TAG20130706T202136_8xkf4jno_.bkp

 

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

deleted archived log

archived log file name=/u01/app/oracle/fast_recovery_area/TESTDB12/archivelog/2013_07_06/o1_mf_1_9_8xkf4h9k_.arc RECID=1 STAMP=820095695

deleted backup piece

backup piece handle=/u01/app/oracle/fast_recovery_area/TESTDB12/backupset/2013_07_06/o1_mf_nnndf_TAG20130706T192144_8xk9n8of_.bkp RECID=1 STAMP=820092104

deleted backup piece

backup piece handle=/u01/app/oracle/fast_recovery_area/TESTDB12/backupset/2013_07_06/o1_mf_annnn_TAG20130706T202136_8xkf4jno_.bkp RECID=3 STAMP=820095696

Deleted 3 objects

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17013648/viewspace-1081008/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2012-02-06

  • 博文量
    1986
  • 访问量
    5649665