系統(tǒng)大全為您提供說明/tmp/contrlfile?/tmp/controlfile.bkp??/home/oracle/control01.ctl?已經通過os命令刪除了現(xiàn)在的疑問是如何刪除這些obsolete的記錄：?以下是測試結果：?RMAN>reportobsolete;RMANretentionpolicywillbeappliedtothecommandRMANretentionpolicyissettoredundancy1ReportofobsoletebackupsandcopiesType????????Key??CompletionTime??Filename/Handle----------------------------------------------------------------ControlFilecopy??2???22-APR-13?????/tmp/contrlfile.ControlFilecopy??3???22-APR-13?????/tmp/controlfile.bkpControlFilecopy??4???23-JUL-13?????/home/oracle/control01.ctl??RMAN>?deleteobsolete;RMANretentionpolicywillbeappliedtothecommandRMANretentionpolicyissettoredundancy1Deletingthefollowingobsoletebackupsandcopies:Type????????Key??CompletionTime??Filename/Handle----------------------------------------------------------------ControlFilecopy??2???22-APR-13?????/tmp/contrlfile.ControlFilecopy??3???22-APR-13?????/tmp/controlfile.bkpControlFilecopy??4???23-JUL-13?????/home/oracle/control01.ctlDoyoureallywanttodeletetheaboveobjects(enterYESorNO)?yesRMAN-06207:WARNING:3objectsCouldnotbedeletedfordisKchannel(s)dueRMAN-06208:?????tomismatchedstatus.?UseCROSSCHECKcommandtofixstatusRMAN-06210:ListofMismatchedobjectsRMAN-06211:==========================RMAN-06212:?ObjectType?Filename/HandleRMAN-06213:------------------------------------------------------------------RMAN-06214:Datafilecopy?/tmp/contrlfile.RMAN-06214:Datafilecopy?/tmp/controlfile.bkpRMAN-06214:Datafilecopy?/home/oracle/control01.ctl??----根據(jù)上面的提示，使用crosscheck檢測?RMAN>crosscheckbackupofdatabase;specificationdoesnotmatchanybackupintherepository?RMAN>?crosscheckbackupofcontrolfile;specificationdoesnotmatchanybackupintherepository?RMAN>deleteexpiredbackup;specificationdoesnotmatchanybackupintherepository?RMAN>listbackupsummary;?ListofBackups===============Key??TYLVSDeviceTypeCompletionTime#Pieces#copiesCompressedTag-----------------------------------------------------------------40???B?F?AdisK????19-NOV-13???1???1???NO????TAG20131119T072057RMAN>??請教下大家如何刪除以上的obsolete記錄！??解決方法：RMAN>CROSSCHECKcopY;?specificationdoesnotmatchanydatafilecopyintherepositoryspecificationdoesnotmatchanyarchivedlogintherepositoryvalidationFailedforcontrolfilecopycontrolfilecopyfilename=/home/oracle/control01.ctlRECID=4STAMP=821523959validationFailedforcontrolfilecopycontrolfilecopyfilename=/tmp/controlfile.bkpRECID=3STAMP=813384451validationFailedforcontrolfilecopycontrolfilecopyfilename=/tmp/contrlfile.RECID=2STAMP=813384351Crosschecked3objects??RMAN>reportobsolete;?RMANretentionpolicywillbeappliedtothecommandRMANretentionpolicyissettoredundancy1ReportofobsoletebackupsandcopiesType????????Key??CompletionTime??Filename/Handle----------------------------------------------------------------ControlFilecopy??2???22-APR-13?????/tmp/contrlfile.ControlFilecopy??3???22-APR-13?????/tmp/controlfile.bkpControlFilecopy??4???23-JUL-13?????/home/oracle/control01.ctl?RMAN>deleteexpiredcopy;?specificationdoesnotmatchanydatafilecopyintherepositoryspecificationdoesnotmatchanyarchivedlogintherepositoryListofControlFilecopies===========================?Key??SCompletionTimeCkpSCN??CkpTime????------------------------------------------------4???X23-JUL-13???2243850??23-JUL-13???????Name:/home/oracle/control01.ctl????Tag:TAG20130723T090559?3???X22-APR-13???1495438??22-APR-13???????Name:/tmp/controlfile.bkp????Tag:TAG20130422T040730?2???X22-APR-13???1490032??22-APR-13???????Name:/tmp/contrlfile.????Tag:TAG20130422T040550??Doyoureallywanttodeletetheaboveobjects(enterYESorNO)?yesdeletedcontrolfilecopycontrolfilecopyfilename=/home/oracle/control01.ctlRECID=4STAMP=821523959deletedcontrolfilecopycontrolfilecopyfilename=/tmp/controlfile.bkpRECID=3STAMP=813384451deletedcontrolfilecopycontrolfilecopyfilename=/tmp/contrlfile.RECID=2STAMP=813384351Deleted3EXPIREDobjects??RMAN>reportexpired;?RMAN-00571:===========================================================RMAN-00569:===============ERRORMESSAGESTACKFOLLOWS===============RMAN-00571:===========================================================RMAN-00558:errorencounteredwhileparsinginputcommandsRMAN-01009:Syntaxerror:found"expired":expectingoneof:"device,need,obsolete,schema,unrecoverable"RMAN-01007:atline1column8file:standardinput?RMAN>reportobsolete;?RMANretentionpolicywillbeappliedtothecommandRMANretentionpolicyissettoredundancy1noobsoletebackupsfound?RMAN>??總結：CrosscheckingBackupsTheCROSSCHECKcommandcheckswhetherRMANbackupsandcopiesintherepositoryarestillreadablebyRMAN.Assumingthatyouhaveconfiguredautomaticchannels,youcanrunthesecommands:RMAN>CROSSCHECKBACKUP;#checksRMANbackupsonconfigureddevicesRMAN>CROSSCHECKcopY;#checksRMANimagecopiesonconfigureddevices?這兩個命令還是有點區(qū)別的，主要還是要認清楚備份的類型。Ifbackupsarestoredwithamediamanagerandsbtchannelsarenotconfigured,thenyoumustallocateamaintenancechannelbeforeCROSSCHECKandDELETEcommandsonsbtdevices:RMAN>ALLOCATECHANNELFORMAINTENANCEDEVICETYPEsbt;---如果使用磁帶庫來備份，需要開一個專用的維護通道。RMAN>CROSSCHECKBACKUP;以上就是系統(tǒng)大全給大家介紹的如何使的方法都有一定的了解了吧，好了，如果大家還想了解更多的資訊，那就趕緊點擊系統(tǒng)大全官網吧。?本文來自系統(tǒng)大全http:///如需轉載請注明！推薦：win7純凈版