Database Administration (MOSC)

MOSC Banner

The Data Guard status of standby db is Error ORA-07286: sksagdi: error in primary db 11g

edited Feb 19, 2025 1:58PM in Database Administration (MOSC) 2 commentsAnswered

On standby db reco disk group is alert log are errors:

ORA-19816: WARNING: Files may exist in db_recovery_file_dest that are not known to database.

ORA-17502: ksfdcre:4 Failed to create file +RECOC

ORA-15041: diskgroup "RECOC" space exhausted

Last arch log which is applied on standby is 23.12.2024.

I tried to delete arch logs with

DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-90'

CROSSCHECK ARCHIVELOG ALL;

DELETE OBSOLETE;

I checked the space in reco disk group in asm but the space is still not freed up.

When I check this:

Primary: SELECT MAX(sequence#) FROM v$archived_log WHERE applied = 'YES'; result is 99901

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