Skip to main content

RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process


Well, the error clearly says, either goldengate integrated captures or dataguard is used, which still need those archives.
However, We are not using any of these. It is just a standalone database, still getting the error. Then we recalled, that the database was cloned from a production database where goldengate integrated capture is used.

So to fix this, I have removed the capture processes.


RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process
[oracle@rac1 ~]$ rman target /


Recovery Manager: Release 19.0.0.0.0 - Production on Tue Jan 25 23:08:05 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

connected to target database: RACDB (DBID=1091256415)

RMAN> delete archivelog all;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=512 instance=RACDB1 device type=DISK
RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process
archived log file name=+OCRVOTE/RACDB/ARCHIVELOG/2022_01_24/thread_1_seq_73.328.1094839909 thread=1 sequence=73
RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process
archived log file name=+OCRVOTE/RACDB/ARCHIVELOG/2022_01_24/thread_1_seq_74.329.1094839911 thread=1 sequence=74
RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process
archived log file name=+OCRVOTE/RACDB/ARCHIVELOG/2022_01_24/thread_1_seq_75.330.1094840379 thread=1 sequence=75


select CAPTURE_NAME,QUEUE_OWNER,status from dba_capture;
CAPTURE_NAME QUEUE_OWNER STATUS
------------------------------ ---------------------------------------- --------
OGG$CAP_EXTPATO C##GOLDEN ENABLED
OGG$CAP_E_CDB C##GOLDEN DISABLED
OGG$CAP_E_SCOTT C##GGADMIN DISABLED

SQL> exec DBMS_CAPTURE_ADM.DROP_CAPTURE('OGG$CAP_E_CDB');
PL/SQL procedure successfully completed.
SQL> exec DBMS_CAPTURE_ADM.DROP_CAPTURE('OGG$CAP_E_SCOTT');
PL/SQL procedure successfully completed.

RMAN> delete archivelog all;
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=512 instance=RACDB1 device type=DISK
List of Archived Log Copies for database with db_unique_name RACDB
=====================================================================

Key Thrd Seq S Low Time
------- ---- ------- - ---------
1 1 73 A 24-JAN-22
Name: +OCRVOTE/RACDB/ARCHIVELOG/2022_01_24/thread_1_seq_73.328.1094839909
2 1 74 A 24-JAN-22
Name: +OCRVOTE/RACDB/ARCHIVELOG/2022_01_24/thread_1_seq_74.329.1094839911
3 1 75 A 24-JAN-22
Name: +OCRVOTE/RACDB/ARCHIVELOG/2022_01_24/thread_1_seq_75.330.1094840379
.
.
.
.
.

archived log file name=+OCRVOTE/RACDB/ARCHIVELOG/2022_01_25/thread_2_seq_65.399.1094937081 RECID=72 STAMP=1094937082
deleted archived log
archived log file name=+OCRVOTE/RACDB/ARCHIVELOG/2022_01_25/thread_2_seq_66.309.1094937243 RECID=73 STAMP=1094937244
deleted archived log
archived log file name=+OCRVOTE/RACDB/ARCHIVELOG/2022_01_25/thread_2_seq_67.287.1094938063 RECID=76 STAMP=1094938062
deleted archived log
archived log file name=+OCRVOTE/RACDB/ARCHIVELOG/2022_01_25/thread_2_seq_68.403.1094940499 RECID=83 STAMP=1094940500
deleted archived log
archived log file name=+OCRVOTE/RACDB/ARCHIVELOG/2022_01_25/thread_2_seq_69.406.1094940559 RECID=86 STAMP=1094940559
Deleted 86 objects




Comments

Post a Comment

Popular posts from this blog

Hard dependency with ip address Oracle RAC Cluster.

Command error out due to hard dependency with ip address [-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl relocate resource RDBMS_DB -n Node2 CRS-2527: Unable to start 'RDBMS_DB' because it has a 'hard' dependency on 'sDB' CRS-2525: All instances of the resource 'sDB' are already running; relocate is not allowed because the force option was not specified CRS-4000: Command Relocate failed, or completed with errors. [-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl relocate resource sDB  -n Node2 CRS-2529: Unable to act on 'DB' because that would require stopping or relocating 'LISTENER_DB', but the force option was not specified CRS-4000: Command Relocate failed, or completed with errors. [-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl relocate resource LISTENER_DB  -n Node2 CRS-2527: Unable to start 'LISTENER_DB' because it has a 'hard' dependency on 'sD...
Post a Comment
Read more

19C NID ( Rename Database)

 [oracle@localhost ~]$ nid DBNEWID: Release 19.0.0.0.0 - Production on Thu Dec 23 00:05:36 2021 Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved. Keyword     Description                    (Default) ---------------------------------------------------- TARGET      Username/Password              (NONE) DBNAME      New database name              (NONE) LOGFILE     Output Log                     (NONE) REVERT      Revert failed change           NO SETNAME     Set a new database name only   NO APPEND      Append to output log           NO HELP        Displays these messages    ...
Post a Comment
Read more

ORA-01017/ORA-28000 with AUDIT_TRAIL

With default profile in Oracle 11g, accounts are automatically locked 1 day ( PASSWORD_LOCK_TIME ) after 10 failed login attempt ( FAILED_LOGIN_ATTEMPTS ): SQL > SET lines 200 SQL > SET pages 200 SQL > SELECT * FROM dba_profiles WHERE PROFILE = 'DEFAULT' ORDER BY resource_name; PROFILE                         RESOURCE_NAME                      RESOURCE LIMIT ------------------------------ -------------------------------- -------- ---------------------------------------- DEFAULT                         COMPOSITE_LIMIT                 ...
Post a Comment
Read more