oracle中force强制删除,请问rman中delete和delete force有何区别？

举个例子吧

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>

[本帖最后由 paulyibinyi 于 2008-6-4 09:43 编辑]