Database Administration (MOSC)

MOSC Banner

V$ARCHIVED_LOG holds records

edited Oct 24, 2014 10:02AM in Database Administration (MOSC) 6 commentsAnswered

Oracle RDBMS 11.1.0.7

My control_file_record_keep_time is 36, today is 10/16/2014.

I have 9792 records in v$archived_log with min(first_time) as 4/29/2014.

I read a note that MAXLOGHISTORY managed this prior to Oracle 10, so I don't think that is it.  This note says that control_file_record_keep_time takes care of this now, but 36 days would be 9/10/2014.  I got way more than that.

Any insights as to why so many are retained? 

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