rman 中delete 与delete force 的区别

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

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

但delete force可以省略crosscheck 这一步 直接删除ITPUB个人空间M4n!?6wU

delete obsolete 是根据策略来删除过期的备份 这个前天条件必须在对应介质中能找到 才可删除成功ITPUB个人空间I2A!B5w1E7J)n
而delete force obsolete  是强制删除 如果对应介质也找不到 也可删除成功ITPUB个人空间
d[a |~

t9Zd
mOO0ITPUB个人空间*?nIf l3y
g2Qu
RMAN> delete obsolete;ITPUB个人空间#V1h:B%dA r$D4~

7d:Fd%P7_8`/x0RMAN retention policy will be applied to the command
*? g~6J^
q/|q0RMAN retention policy is set to redundancy 1ITPUB个人空间 wt'x1Ew$a
using channel ORA_DISK_1
#i$W M*s/sq{_0Deleting the following obsolete backups and copies:
q+m X&f%Qe)h s(G0Type                 Key    Completion Time    Filename/Handle
V"Ag&M V_Ie0-------------------- ------ ------------------ --------------------ITPUB个人空间en{;i-f B x&I
Backup Set           88     02-JUN-08ITPUB个人空间q9_)K+OR"\#o
  Backup Piece       88     02-JUN-08          D:BACKUP2SJHUB4S_1_1ITPUB个人空间VUt5g,p3y5SI
Backup Set           89     02-JUN-08
\G/TJUb0  Backup Piece       89     02-JUN-08          D:BACKUPC-799229701-20080602-0D
&N+X0f]-ok7|V0ITPUB个人空间We9OGQ&F
Backup Set           90     04-JUN-08ITPUB个人空间6wI^U{n?,hyk6_+p
  Backup Piece       90     04-JUN-08          D:BACKUP2UJI2QFK_1_1ITPUB个人空间3O_}+x:tfG T9Q
Backup Set           91     04-JUN-08
\.Q FG(`3N:Iw0  Backup Piece       91     04-JUN-08          D:BACKUPC-799229701-20080604-00ITPUB个人空间 @rV,ar@)X:A

m#do8g`0Archive Log          255    03-JUN-08          D:ARCHPAULPUBTEST_1_14.DBF
a mX-mE XCj*ss8z7s0Archive Log          256    04-JUN-08          D:ARCHPAULPUBTEST_1_15.DBFITPUB个人空间f#j.A0a_n
ITPUB个人空间cg'jW"U g
Do you really want to delete the above objects (enter YES or NO)? yes
V*SaYaqU0deleted backup piece
.p9Eb)bg0eBs0backup piece handle=D:BACKUP2UJI2QFK_1_1 recid=90 stamp=656501236
P~Ml9g4R0}0deleted backup pieceITPUB个人空间7_z0a?K
backup piece handle=D:BACKUPC-799229701-20080604-00 recid=91 stamp=656501281
Px`2s/?"{"r0deleted archive logITPUB个人空间3^~D;R3gB8W:F
archive log filename=D:ARCHPAULPUBTEST_1_14.DBF recid=255 stamp=656415230
9bbde [&DJ0deleted archive log
?nmqD(X0archive log filename=D:ARCHPAULPUBTEST_1_15.DBF recid=256 stamp=656498131
G}3NiLJ%@2~1J0Deleted 4 objectsITPUB个人空间.uvoN9U
ITPUB个人空间A;H,w%O kL.}b aUw/I
RMAN-06207:WARNING: 2 objects could not be deleted for DISK channel(s) due
Ug/Z1hBX2p@O1s0RMAN-06208:         to mismatched status.  Use CROSSCHECK command to fix statusITPUB个人空间/dHEk(W2~0g
List of Mismatched objects
]6|5k8Sh q t'a0==========================
1\Z1u'@C0  Object Type   Filename/Handle
aT%Y2ob?D${e;CD,F0--------------- ---------------------------------------------------ITPUB个人空间 iWE%r X*A8K
Backup Piece    D:BACKUP2SJHUB4S_1_1
?Dh!z _6x;O$~0Backup Piece    D:BACKUPC-799229701-20080602-0DITPUB个人空间;K!y6eD5z_zU
ITPUB个人空间DH;sx8`zj0|

)ZA"c@+rg.zd0RMAN> delete force obsolete;ITPUB个人空间b p!KRR"Cz@
ITPUB个人空间Y[E7J|7K1N
RMAN retention policy will be applied to the commandITPUB个人空间{+e
[N$}}Rr
RMAN retention policy is set to redundancy 1
5i4p@j"k$k/`&lVRW]0using channel ORA_DISK_1
%N&N"oeKH(R9g L0Deleting the following obsolete backups and copies:
,N zJOXD[dF0Type                 Key    Completion Time    Filename/Handle
!V3S.wX~Hz0-------------------- ------ ------------------ --------------------ITPUB个人空间)c*W{e%[o
Backup Set           88     02-JUN-08ITPUB个人空间:[$un{ Ya } W
  Backup Piece       88     02-JUN-08          D:BACKUP2SJHUB4S_1_1ITPUB个人空间 U6|WmX]k
Backup Set           89     02-JUN-08ITPUB个人空间7io9`m{)vR+KV
  Backup Piece       89     02-JUN-08          D:BACKUPC-799229701-20080602-0DITPUB个人空间Co3]vh7xP A

8N`EH}.j/A*PsU0ITPUB个人空间8rI:tD-d
Do you really want to delete the above objects (enter YES or NO)? yesITPUB个人空间 j#l&wPH$Bz%j
deleted backup piece
Dc Z ]+R#|m
v2E%@d0backup piece handle=D:BACKUP2SJHUB4S_1_1 recid=88 stamp=656354460ITPUB个人空间8U xE#U-Jq~
deleted backup pieceITPUB个人空间o]:hURsF1?'@
backup piece handle=D:BACKUPC-799229701-20080602-0D recid=89 stamp=656354486ITPUB个人空间5K1B(\"Sb|
Deleted 2 objects
Y"{&R;uJupaB0
:i#~i X{M
G}6P0
m"_]{&z6NT _0RMAN>ITPUB个人空间7Mi K%E@{b5i:xf6r