Skip to Main Content

Oracle Database Discussions

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

OrcL-FaNMay 29 2018 — edited May 30 2018

Hello Experts,

In one server RMAN is not able to auto purge archive logs though parameters for standby has been set properly.

DB version:- 11.2.0.4

OS:- AIX 7.1

GG:- 12.2.0.2

SQL> show parameter log_archive_dest_state_2;

NAME TYPE        VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_state_2 string      DEFER

SQL> show parameter log_archive_dest_2

NAME TYPE        VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_2 string

SQL> show parameter log_archive_config

NAME TYPE        VALUE

------------------------------------ ----------- ------------------------------

log_archive_config string

SQL> show parameter fal

NAME TYPE        VALUE

------------------------------------ ----------- ------------------------------

fal_client string

fal_server string

Goldengate setup is exist and running without any lag in that server and there is no obsolete EXTRACT also exist which we could unregister as per Doc ID 1993799.1.

Please suggest your valuable suggestion to resolve this issue.

Regards,

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 27 2018
Added on May 29 2018
17 comments
557 views