The Data Guard status of standby db is Error ORA-07286: sksagdi: error in primary db 11g
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