--DELETE noprompt force ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-2';
--在主库上配置了Stream后，通过RMAN删除Archivelog时，遇到RMAN-08137错误
---执行删除操作告警
delete noprompt archivelog until time 'sysdate-2';
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/u01/arch/salesdb_1_38821_950811270.arc thread=1 sequence=38821
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/u01/arch/salesdb_1_38822_950811270.arc thread=1 sequence=38822
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/u01/arch/salesdb_1_38823_950811270.arc thread=1 sequence=38823
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
先看看是不是有capture进程有问题
select capture_name, status, captured_scn, applied_scn, capture_type from dba_capture;
如果有问题，可以用如下的命令来删除capture进行
exec dbms_capture_adm.drop_capture(capture_name =>'OGG2$EXT_EMCF3359B3');
select CAPTURE_NAME, QUEUE_NAME, START_SCN, STATUS, FIRST_SCN from dba_capture;
CAPTURE_NAME QUEUE_NAME START_SCN STATUS FIRST_SCN
------------------------------ ------------------------------ ---------- -------- ----------
OGG$CAP_EXTFX OGG$Q_EXTFX 1.2773E+11 DISABLED 1.2773E+11
OGG$CAP_EXT_KAF1 OGG$Q_EXT_KAF1 1.3648E+11 ENABLED 1.3648E+11
OGG$CAP_EXT_KAF2 OGG$Q_EXT_KAF2 1.3648E+11 ENABLED 1.3648E+11
OGG$CAP_EXT_KAF3 OGG$Q_EXT_KAF3 1.3648E+11 ENABLED 1.3648E+11
---删除DISABLED 状态的进程
exec dbms_capture_adm.drop_capture(capture_name =>'OGG$CAP_EXTFX');
---执行删除归档操作
delete noprompt archivelog until time 'sysdate-2';
archived log file name=/u01/arch/salesdb_1_38928_950811270.arc RECID=78145 STAMP=975074816 deleted archived log
archived log file name=/u01/arch/salesdb_1_38929_950811270.arc RECID=78148 STAMP=975075202 deleted archived log
archived log file name=/u01/arch/salesdb_1_38930_950811270.arc RECID=78151 STAMP=975075586 deleted archived log
archived log file name=/u01/arch/salesdb_1_38931_950811270.arc RECID=78154 STAMP=975075965 deleted archived log
archived log file name=/u01/arch/salesdb_1_38932_950811270.arc RECID=78157 STAMP=975076347 deleted archived log
archived log file name=/u01/arch/salesdb_1_38933_950811270.arc RECID=78160 STAMP=975076747 deleted archived log
archived log file name=/u01/arch/salesdb_1_38934_950811270.arc RECID=78163 STAMP=975077126 deleted archived log
archived log file name=/u01/arch/salesdb_1_38935_950811270.arc RECID=78166 STAMP=975077528 deleted archived log
archived log file name=/u01/arch/salesdb_1_38936_950811270.arc RECID=78169 STAMP=975077956 deleted archived log
archived log file name=/u01/arch/salesdb_1_38937_950811270.arc RECID=78172 STAMP=975078373 Deleted 3515 objects
For record type DELETED OBJECT RECIDS from 38258 to 38259 are re-used before resync
日积月累
