High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Archive logs are not getting deleted from physical standby, Primary and Standby are in Sync though,

edited Dec 22, 2015 11:47AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 15 commentsAnswered

Hi,

I have a scenario where archives are not getting deleted from Physical Standby db (11.2.0.3), throwing below error message.

"RMAN-08120: WARNING: archived log not deleted, not yet applied by standby"


This issue started few days back when MRP was not started after the DR DB recycle. After reviewing the issues, MRP was restarted and logs getting applied on standby, both Primary and Standby are in sync. Now when trying to delete the archives from Standby database RMAN throws above error. Upon checking further one of the archive is not marked as applied.


SQL> SELECT THREAD#, MAX(SEQUENCE#) AS "LAST_APPLIED_LOG" FROM V$archived_log where applied=

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center