Database Administration (MOSC)

MOSC Banner

v$ARCHIVED_LOG doesn't correctly reflect controlfile archivelog information

edited Apr 23, 2018 5:02AM in Database Administration (MOSC) 1 commentAnswered

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

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