Oracle ORA-08591告警
进行归档恢复的时候数据库报以下错误:
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;
声明:本站所有文章资源内容,如无特殊说明或标注,均为采集网络资源。如若本站内容侵犯了原著者的合法权益,可联系本站删除。