rman 中delete 与delete force 的区别

假设你的备份集被OS命令删掉了,

这时候delete这个备份集是删不掉的,必须用delete 删除的话,先要用crosscheck 一下,标识expired 才可以

但delete force可以省略crosscheck 这一步 直接删除

delete obsolete 是根据策略来删除过期的备份 这个前天条件必须在对应介质中能找到 才可删除成功
而delete force obsolete  是强制删除 如果对应介质也找不到 也可删除成功


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
-------------------- ------ ------------------ --------------------
Backup Set           88     02-JUN-08
  Backup Piece       88     02-JUN-08          D:BACKUP2SJHUB4S_1_1
Backup Set           89     02-JUN-08
  Backup Piece       89     02-JUN-08          D:BACKUPC-799229701-20080602-0D

Backup Set           90     04-JUN-08
  Backup Piece       90     04-JUN-08          D:BACKUP2UJI2QFK_1_1
Backup Set           91     04-JUN-08
  Backup Piece       91     04-JUN-08          D:BACKUPC-799229701-20080604-00

Archive Log          255    03-JUN-08          D:ARCHPAULPUBTEST_1_14.DBF
Archive Log          256    04-JUN-08          D:ARCHPAULPUBTEST_1_15.DBF

Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=D:BACKUP2UJI2QFK_1_1 recid=90 stamp=656501236
deleted backup piece
backup piece handle=D:BACKUPC-799229701-20080604-00 recid=91 stamp=656501281
deleted archive log
archive log filename=D:ARCHPAULPUBTEST_1_14.DBF recid=255 stamp=656415230
deleted archive log
archive log filename=D:ARCHPAULPUBTEST_1_15.DBF recid=256 stamp=656498131
Deleted 4 objects

RMAN-06207: WARNING: 2 objects could not be deleted for DISK channel(s) due
RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status
List of Mismatched objects
==========================
  Object Type   Filename/Handle
--------------- ---------------------------------------------------
Backup Piece    D:BACKUP2SJHUB4S_1_1
Backup Piece    D:BACKUPC-799229701-20080602-0D


RMAN> delete force 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
-------------------- ------ ------------------ --------------------
Backup Set           88     02-JUN-08
  Backup Piece       88     02-JUN-08          D:BACKUP2SJHUB4S_1_1
Backup Set           89     02-JUN-08
  Backup Piece       89     02-JUN-08          D:BACKUPC-799229701-20080602-0D


Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=D:BACKUP2SJHUB4S_1_1 recid=88 stamp=656354460
deleted backup piece
backup piece handle=D:BACKUPC-799229701-20080602-0D recid=89 stamp=656354486
Deleted 2 objects


RMAN>

请使用浏览器的分享功能分享到微信等