Oracel12.2 Standby rebuild has left primary with archivelogs not applied from earlier causing rman t
edited May 27, 2020 5:12AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 11 commentsAnswered ✓
Standby was dropped to be recreated but primary still thinks these archivelogs are needed for the standby cauing rman to hold onto these archives and backups.
From primary
1 select dest_id, THREAD#, SEQUENCE#, FIRST_TIME, APPLIED, DELETED, STATUS, STANDBY_DEST
2* from v$archived_log where STANDBY_DEST='YES' and APPLIED='NO'
SQL> /
DEST_ID THREAD# SEQUENCE# FIRST_TIM APPLIED DEL S STA
---------- ---------- ---------- --------- --------- --- - ---
2 1 528982 07-MAR-20 NO NO A YES
2 2 231029 07-MAR-20 NO NO A YES
I am forcing the archive and backup deletions to manage space but I need the primary to finish off these archives for dest_id 2
0