用户的SIEBEL RAC系统中配置了OGG 11.1.1.1.2 ，在最近发现备份脚本未正常将归档日志备份后删除掉，示例日志如下：
iece handle=al_18090002_1_848331814 tag=TAG20140523T154330 comment=API Version 2.0,MMS Version 5.0.0.0 channel ch00: backup set complete, elapsed time: 00:01:35 channel ch00: deleting archived log(s) RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=/ora/archivelog/2014_05_21/o1_mf_2_171530_1cccD0E1h_.arc thread=2 sequence=171530 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=/ora/archivelog/2014_05_21/o1_mf_2_171531_1cccD0VDr_.arc thread=2 sequence=171531 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=/ora/archivelog/2014_05_21/o1_mf_1_84695_1cccD0K8I_.arc thread=1 sequence=84695 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=/ora/archivelog/2014_05_21/o1_mf_2_171532_1cccD0C2h_.arc thread=2 sequence=171532 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process archived log file name=/ora/archivelog/2014_05_21/o1_mf_2_171533_1cccD0Y2l_.arc thread=2 sequence=171533 channel ch00: starting archived log backup set channel ch00: specifying archived log(s) in backup set input archived log thread=1 sequence=84696 RECID=261042 STAMP=848117115 input archived log thread=2 sequence=171534 RECID=261053 STAMP=848117139 input archived log thread=2 sequence=171535 RECID=261051 STAMP=848117138 input archived log thread=2 sequence=171536 RECID=261054 STAMP=848117139 input archived log thread=1 sequence=84697 RECID=261048 STAMP=848117125 channel ch00: starting piece 1 at 23-MAY-14 channel ch00: finished piece 1 at 23-MAY-14 piece handle=al_18090003_1_848331909 tag=TAG20140523T154330 comment=API Version 2.0,MMS Version 5.0.0.0 channel ch00: backup set complete, elapsed time: 00:01:35 channel ch00: deleting archived log(s) RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
针对该问题用户提交了SR，并禁用了TRANLOGOPTIONS LOGRETENTION DISABLED特性：
USERID ggs, password ************************************************ , ENCRYPTKEY default exttrail ./dirdat/or --HANDLECOLLISIONS --FETCHOPTIONS FETCHPKUPDATECOLS --FETCHOPTIONS, MISSINGROW IGNORE, NOFETCH THREADOPTIONS OUTQUEUESIZE 512 INQUEUESIZE 1024 --TRANLOGOPTIONS _NOREADAHEAD ANY TRANLOGOPTIONS LOGRETENTION DISABLED --EOFDELAY 30 --BR BROFF GETUPDATEBEFORES
但仍无法有效删除对应归档日志，相关的Note:
1. Disable logretention. 2. Make sure the capture process is removed from dba_capture. 3. Please follow the solution as per below document to cleanup the Orphan entries from metadata tables. Ora-1 ''Unique Constraint (System.Logmnr_session_uk1) Violated'' During Streams Config (Doc ID 413774.1) 4. Please enable logretention which recreates the capture process again. Make sure it has only one session for logminer. Registered Extract - Archivelog Delete Problem (Doc ID 1487374.1)
这个case通过delete force 强制删除命令绕过了,例如：
delete force archivelog sequence 171532 thread 2 ;
对于备份后delete input 的 删除也可以使用：
backup archivelog until time 'sysdate-1' delete input force;
Comment