ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RMAN-06207和RMAN-06208

RMAN-06207和RMAN-06208

原创 Linux操作系统 作者:jichenghan 时间:2009-02-23 13:36:38 0 删除 编辑

由于备份文件被手工删除,导致了这个小bug的产生。

 

 

昨天发现备份空间马上就要满了,而备份正在进行之中,于是手工删除了几个RMAN的备份文件。

随后删除过期对象的时候出现了RMAN-06207RMAN-06208错误:

RMAN> delete obsolete;

RMAN retention policy will be applied to the commandITPUB个人空间\]5W'q w!tz
RMAN retention policy is set to recovery window of 14 daysITPUB个人空间"brb1d k
Deleting the following obsolete backups and copies:
|h+_g7T_-O*E0Type                 Key    Completion Time    Filename/Handle
\X%X5KJuo;A0-------------------- ------ ------------------ --------------------
/nO(?h0T hlS0Backup Set           1611   14-AUG-08        
2~Vu+Z |H0  Backup Piece       1611   14-AUG-08          /data1/backup/jiangsu/20080814_iljnvkad_1_1ITPUB个人空间cVxKd^A
Backup Set           1612   14-AUG-08        ITPUB个人空间o8GqO4Ea7j;G Y*vFT
  Backup Piece       1612   14-AUG-08          /data1/backup/jiangsu/20080814_imjnvkad_1_1

RMAN-06207: WARNING: 2 objects could not be deleted for DISK channel(s) due
@R#P%}'tn0RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix statusITPUB个人空间-Mg_ C{G
RMAN-06210: List of Mismatched objectsITPUB个人空间 ~(x6u\ U
RMAN-06211: ==========================
9Q`%i'E(WFme @0RMAN-06212:   Object Type   Filename/Handle
MsE"t`2?2hB:mP0RMAN-06213: --------------- ---------------------------------------------------ITPUB个人空间jB%ne[.e]
RMAN-06214: Backup Piece    /data1/backup/jiangsu/20080814_iljnvkad_1_1
0KV0WqVMxy5S0RMAN-06214: Backup Piece    /data1/backup/jiangsu/20080814_imjnvkad_1_1

如果只是产生这个错误并不奇怪,奇怪的是进行CROSSCHECK检查的时候,根本就不检查这个备份:

RMAN> crosscheck backup;

using channel ORA_DISK_1
(w?`A1dr0crosschecked backup piece: found to be 'AVAILABLE'
+t+]#}?]*yB#z0backup piece handle=/data1/backup/jiangsu/20080901_m3jpgk19_1_1 recid=1700 stamp=664293417ITPUB个人空间"I@U Uq mF5w6z
crosschecked backup piece: found to be 'AVAILABLE'
Z2^ V M:N;S4E0backup piece handle=/data1/backup/jiangsu/20080901_m2jpgk18_1_1 recid=1701 stamp=664293417
P4`*jq v0crosschecked backup piece: found to be 'AVAILABLE'ITPUB个人空间-oz}*kVb
backup piece handle=/data1/backup/jiangsu/20080901_c-499478642-20080901-00 recid=1702 stamp=664294238ITPUB个人空间[(qdKY}*oh
crosschecked backup piece: found to be 'AVAILABLE'ITPUB个人空间JrO0t9N&z,H
backup piece handle=/data1/backup/jiangsu/20080902_m5jphne8_1_1 recid=1703 stamp=664329673ITPUB个人空间TR$FOHN
crosschecked backup piece: found to be 'AVAILABLE'
'eb'ETY!K4\6G8@y0backup piece handle=/data1/backup/jiangsu/20080902_m6jphnei_1_1 recid=1704 stamp=664329683ITPUB个人空间 Ij6o3V9X I
crosschecked backup piece: found to be 'AVAILABLE'ITPUB个人空间4F8KYU_7[ V
backup piece handle=/data1/backup/jiangsu/20080902_m7jphnei_1_1 recid=1705 stamp=664329683ITPUB个人空间"pX4]4ke{*G:S,n'vKe!@
crosschecked backup piece: found to be 'AVAILABLE'ITPUB个人空间bpt,sNG[tW z
backup piece handle=/data1/backup/jiangsu/20080902_m8jphocp_1_1 recid=1706 stamp=664330649
0yHO&a|]-J:UV[0crosschecked backup piece: found to be 'AVAILABLE'ITPUB个人空间u)l0q&n(t@
backup piece handle=/data1/backup/jiangsu/20080902_m9jphou5_1_1 recid=1707 stamp=664331206ITPUB个人空间zr+Brlb-M
crosschecked backup piece: found to be 'AVAILABLE'
:rq cA4Y,d/Nomd*n0backup piece handle=/data1/backup/jiangsu/20080902_c-499478642-20080902-00 recid=1708 stamp=664331208
*r)TD(lH3@ Qo0Crosschecked 9 objects

这种情况可以通过CROSSCHECK BACKUPPIECE的方式对问题备份进行单独的检查:

RMAN> crosscheck backuppiece '/data1/backup/jiangsu/20080814_iljnvkad_1_1';

using channel ORA_DISK_1ITPUB个人空间Jm-?6fT\
crosschecked backup piece: found to be 'EXPIRED'
N1i0t6Y8PL8}5k"MT0backup piece handle=/data1/backup/jiangsu/20080814_iljnvkad_1_1 recid=1611 stamp=662688077
$SN"\/dld.z0Crosschecked 1 objects

ITPUB个人空间5anEIG-AM
RMAN> delete obsolete;

RMAN retention policy will be applied to the command
oD3LS&rfs]0RMAN retention policy is set to recovery window of 14 days
F6Zo:Ll9ksF#s0using channel ORA_DISK_1ITPUB个人空间,bVe u)@'Vx
Deleting the following obsolete backups and copies:
9U.h*{FGl0Type                 Key    Completion Time    Filename/Handle
mF!vw&h!~lF0-------------------- ------ ------------------ --------------------ITPUB个人空间B:B$LK-a\X8?
Backup Set           1611   14-AUG-08        ITPUB个人空间O*` i:uuL&W.yQ(H
  Backup Piece       1611   14-AUG-08          /data1/backup/jiangsu/20080814_iljnvkad_1_1ITPUB个人空间B,f a_rWv3D'A
Backup Set           1612   14-AUG-08        
'Iba_ k8XC$m0  Backup Piece       1612   14-AUG-08          /data1/backup/jiangsu/20080814_imjnvkad_1_1

Do you really want to delete the above objects (enter YES or NO)? yes
U"a ^ ?%|0deleted backup piece
C)q:p T6@1[:eD UT0backup piece handle=/data1/backup/jiangsu/20080814_iljnvkad_1_1 recid=1611 stamp=662688077
Z6g0g(Y4o~0Deleted 1 objects

RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
0F{:q ^OV0RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix statusITPUB个人空间O?4C2f']ts3q
RMAN-06210: List of Mismatched objectsITPUB个人空间?+PF7f'G.d
RMAN-06211: ==========================ITPUB个人空间&Y5PH#T5C"TN+X
RMAN-06212:   Object Type   Filename/Handle
,p,f#m\$Sk9j-I/~#jj0RMAN-06213: --------------- ---------------------------------------------------
+LQ2p jwb#pD8K0RMAN-06214: Backup Piece    /data1/backup/jiangsu/20080814_imjnvkad_1_1

进行检查之后的备份就可以顺利的删除了。

RMAN> crosscheck backupset 1612;

using channel ORA_DISK_1
I*K;Y+}szl0crosschecked backup piece: found to be 'EXPIRED'
xN6L:_(MO Y']jC0backup piece handle=/data1/backup/jiangsu/20080814_imjnvkad_1_1 recid=1612 stamp=662688078ITPUB个人空间N8MLe(T`K
Crosschecked 1 objects


c.sg,OKJ$Yh0RMAN> delete backupset 1612;

using channel ORA_DISK_1

List of Backup PiecesITPUB个人空间;G;M;|TxJRC{
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
/K V n.Y0V%yFaf0------- ------- --- --- ----------- ----------- ----------ITPUB个人空间*IhLz(| Iy)d
1612    1612    1   1   EXPIRED     DISK        /data1/backup/jiangsu/20080814_imjnvkad_1_1

Do you really want to delete the above objects (enter YES or NO)? yesITPUB个人空间 hC"FAcfv
deleted backup pieceITPUB个人空间!yT!?%[*P,RG*c)\4LQ
backup piece handle=/data1/backup/jiangsu/20080814_imjnvkad_1_1 recid=1612 stamp=662688078ITPUB个人空间V;baOHY'OF
Deleted 1 objects

使用CROSSCHECK BACKUPSET的方式也可以,但是比较单独指定被删除的备份,而通过CROSSCHECK BACKUP是无法找到的。其他手工删除的备份,则没有这个问题。

 

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

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

注册时间:2008-02-26

  • 博文量
    17
  • 访问量
    36662