- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
archivelogs not becoming reclaimable after switchover
I have never thought this could (not) work, but the reality showed something else.
When we setup dataguard, have a catalog, also a configured archivelog deletion policy, all the best practices, we have to manually remove archivelogs after the switchover, because they do not get reclaimable.
On the new standby we have to use queries to find and delete these forgotten archivelogs. I would expect it to be already automatic and not doing it manually.
select 'delete force noprompt archivelog until sequence '||seq||' thread '||thread#||';' stmt
select max(sequence#) seq,thread#
where not name is null
and not registrar='RFS'
group by thread#
Do you think it would make sense to fix it in 19.14 RU? 😅