Unable to delete archivelog from rman and got
error RMAN-08137: WARNING: archived log not deleted, needed for standby or
upstream capture process
RMAN> delete archivelog sequence 510 thread 2
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=10299
instance=psrinc012 device type=DISK
RMAN-08137: WARNING: archived log not deleted, needed for
standby or upstream capture process
archived log file name=+RECOC1/psrinc01/archivelog/2019_02_28/thread_2_seq_510.790.1001376017
thread=2 sequence=510
Verified no standby configured and db cloned
from production where golden gate configured,
OGG processes are in present db and they are
disabled , Dropped ogg capture since they are not used
SQL> select CAPTURE_NAME, STATUS from dba_capture;
CAPTURE_NAME STATUS
------------------------------ --------
OGG$CAP_X4PBTR DISABLED
OGG$CAP_TST_PBTR DISABLED
SQL> exec DBMS_CAPTURE_ADM.DROP_CAPTURE ('OGG$CAP_X4PBTR');
PL/SQL procedure successfully completed.
SQL> exec DBMS_CAPTURE_ADM.DROP_CAPTURE ('OGG$CAP_TST_PBTR');
PL/SQL procedure successfully completed.
SQL> select CAPTURE_NAME,STATUS from
dba_capture;
no rows selected
Archive deletion will work fine now:
RMAN> delete archivelog sequence 510
thread 2;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=10299
instance=psrinc012 device type=DISK
List of Archived Log Copies for database with
db_unique_name PSRINC01
=====================================================================
Key
Thrd Seq S Low Time
------- ---- ------- - ---------
2434
2 510 A 27-FEB-19
Name: +RECOC1/psrinc01/archivelog/2019_02_28/thread_2_seq_510.790.1001376017
Do you really want to delete the above
objects (enter YES or NO)? yes
deleted archived log
archived log file
name=+RECOC1/psrinc01/archivelog/2019_02_28/thread_2_seq_510.790.1001376017
RECID=2434 STAMP=1001376036
Deleted 1 objects