标签：capture archived log thread 08137 SQL RMAN
RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process
archived log file name=+ARCH/MARC/ARCHIVELOG/2022_09_21/thread_2_seq_3641.3274.1116019413 thread=2 sequence=3641
RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process
archived log file name=+ARCH/MARC/ARCHIVELOG/2022_09_21/thread_2_seq_3642.3289.1116019417 thread=2 sequence=3642
RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process
archived log file name=+ARCH/MARC/ARCHIVELOG/2022_09_25/thread_2_seq_3643.3294.1116326785 thread=2 sequence=3643
RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process
archived log file name=+ARCH/MARC/ARCHIVELOG/2022_09_25/thread_2_seq_3644.3315.1116326783 thread=2 sequence=3644
SQL> select force_logging,supplemental_log_data_min from v$database;
FORCE_LOGGING SUPPLEME
--------------------------------------- --------
YES YES
SQL> alter database drop supplemental log data;
Database altered.
SQL> select force_logging,supplemental_log_data_min from v$database;
FORCE_LOGGING SUPPLEME
--------------------------------------- --------
YES NO
SQL> select capture_name, status, captured_scn, applied_scn, capture_type from dba_capture;
CAPTURE_NAME
--------------------------------------------------------------------------------
STATUS CAPTURED_SCN APPLIED_SCN CAPTURE_TY
-------- ------------ ----------- ----------
OGG$CAP_EX1
DISABLED 1597101500 1597101424 LOCAL
SQL>
SQL>
SQL> exec dbms_capture_adm.drop_capture(capture_name =>'OGG$CAP_EX1');
PL/SQL procedure successfully completed.
标签：capture,
archived,
log,
thread,
08137,
SQL,
RMAN
From： https://www.cnblogs.com/hanglinux/p/16727439.html