进行归档恢复的时候数据库报以下错误:

RMAN-08591:WARNING:invalidarchivedlogdeletionpolicy

查看ORA错误解释:

[oracle@021Y-SH-BKAP~]$oerrrman85918591,3,"WARNING:invalidarchivedlogdeletionpolicy"//*Cause:AninvalidARCHIVELOGDELETIONPOLICYwassupplied.Thearchived//logdeletionpolicywasAPPLIEDbuttherewasnomandatory//archivedlogdestinations.//*Action:Oneofthefollowing://1)ChangearchivedlogdeletionpolicyusingCONFIGUREcommand//2)MakeoneormoreofstandbydestinationasMANDATORY.

说明这是由于备库是从主库获取的日志归档,而不是归档的传输者,因此该策略部符合该库的角色,进入rman工具:

[oracle@021Y-SH-BKAP~]$rmantarget/RecoveryManager:Release11.2.0.1.0-ProductiononMonFeb213:59:102015Copyright(c)1982,2009,Oracleand/oritsaffiliates.Allrightsreserved.connectedtotargetdatabase:ORCL(DBID=1394247230)RMAN>showall;usingtargetdatabasecontrolfileinsteadofrecoverycatalogRMANconfigurationparametersfordatabasewithdb_unique_nameORCLare:CONFIGURERETENTIONPOLICYTOREDUNDANCY1;#defaultCONFIGUREBACKUPOPTIMIZATIONOFF;#defaultCONFIGUREDEFAULTDEVICETYPETODISK;#defaultCONFIGURECONTROLFILEAUTOBACKUPON;CONFIGURECONTROLFILEAUTOBACKUPFORMATFORDEVICETYPEDISKTO'/DBBK/oracle/backup/control%F.bkp';CONFIGUREDEVICETYPEDISKPARALLELISM1BACKUPTYPETOBACKUPSET;#defaultCONFIGUREDATAFILEBACKUPCOPIESFORDEVICETYPEDISKTO1;#defaultCONFIGUREARCHIVELOGBACKUPCOPIESFORDEVICETYPEDISKTO1;#defaultCONFIGUREMAXSETSIZETOUNLIMITED;#defaultCONFIGUREENCRYPTIONFORDATABASEOFF;#defaultCONFIGUREENCRYPTIONALGORITHM'AES128';#defaultCONFIGURECOMPRESSIONALGORITHM'BASIC'ASOFRELEASE'DEFAULT'OPTIMIZEFORLOADTRUE;#defaultCONFIGUREARCHIVELOGDELETIONPOLICYTOSHIPPEDTOSTANDBY;#defaultCONFIGURESNAPSHOTCONTROLFILENAMETO'/DBBK/oracle/product/11.2.0.1.0/dbs/snapcf_orcl.f';#default

修改RMAN配置

RMAN>configureARCHIVELOGDELETIONPOLICYclear;