Start a Conversation

Unsolved

T

1 Rookie

 • 

60 Posts

185

June 21st, 2024 16:08

RMAN archived log not deleted, needed for standby or upstream capture process

Hi All;

I found msg on avamar rman log :

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

How can I fix it ? Thank you.

1 Rookie

 • 

2 Posts

June 21st, 2024 17:29

The RMAN warning "RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process" indicates that RMAN has identified that the archived log files are still needed, possibly by a standby database or an upstream capture process. Here's how you can address this:

  1. Verify Standby and Capture Process Requirements: Ensure that the archived logs are indeed needed by a standby database or an upstream capture process like Oracle Streams or GoldenGate. If these processes are still using the logs, RMAN will not delete them until they are no longer required...

  2. Check Standby Database: If you have a standby database configured, check the synchronization status between the primary and standby databases. You may need to manually transfer or apply the archived logs to the standby database.

SELECT SEQUENCE#, APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

Check Standby Database: If you have a standby database configured, check the synchronization status between the primary and standby databases. You may need to manually transfer or apply the archived logs to the standby database.

SELECT CAPTURE_NAME, STATUS FROM DBA_CAPTURE;

1 Rookie

 • 

60 Posts

June 26th, 2024 21:12

Thank you I will ask DBA team to follow up. 

No Events found!

Top