v$ARCHIVED_LOG doesn't correctly reflect controlfile archivelog information
Hi all,
I faced with a problem about quering old archivelog files (rest from ex incarnation) while I trying to calculate the log difference between primary and standby. When I checked list of archivelog information from v$archived_log view I saw some old (nearly 5 years old) archivelogs. Then I decided to delete them by using catalog. Somehow, even it deleted the logs on disk correctly, it doesn't delete old records on v$archived_log view (it just updated name column as null). From that point, I wonder to learn the main reason that why I see the old records on v$archived_log view and why