GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

RMAN Not deleting archives with upstream capture process error although it has no capture process

edited Jan 20, 2018 4:18PM in GoldenGate, Streams and Distributed Database (MOSC) 4 commentsAnswered

I got this error when i delete archived log in rman by command: "delete archivelog all"

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

although i drop all capture process.

I query select * from dba_capture, it return 0 rows.

Here's my config for downstream mode:

*.fal_server='OGGDB'

*.log_archive_config='DG_CONFIG=(pe1,oggdb)'

*.log_archive_dest_2='SERVICE=oggdb ASYNC OPTIONAL NOREGISTER TEMPLATE=/u01/app/oracle/fast_recovery_area/OGGDB/TMS/TMS_arch_%t_%s_%r.log VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) REOPEN=10 DB_UNIQUE_NAME=oggdb'

*.log_archive_dest_state_2='ENABLE'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center