I got a BMC Patrol alert saying "RedoArchDelay has a value of 72."  
By definition, RedoArchDelay is "Reports the number of minutes from the last time that the redo log was switched. The annotation for this parameter lists the unarchived redo log and the date and time for the first entry for the redo log.  This parameter reports no data if redo log archiving is not enabled."

It is a little vague to understand what it is really about.  Can anyone explain?
Who is Participating?
johnsoneConnect With a Mentor Senior Oracle DBACommented:
Under the covers, Patrol is just running a query to satisfy these requests.

I would suspect it is tied to either V$LOG or V$LOG_HISTORY.  If it is checking since the log was archived, they may be looking for a status of ACTIVE as well as CURRENT.

Technically, you should be able to trace the session that is running Patrol, and grab the queries from there.
johnsoneSenior Oracle DBACommented:
I do not have Patrol, but I can take a guess.

It sounds like this is the number of minutes since the last log switch.

If this query matches the number of minutes reported by Patrol, that that would confirm it.

select(sysdate - first_time)*1440
from v$log
where status = 'CURRENT';

JohnLucaniaAuthor Commented:

It seems that the log was updated.
Why do you use 1440?
johnsoneSenior Oracle DBACommented:
1440 is the number of minutes in a day.
actonwangConnect With a Mentor Commented:
The RedoArchDelay is the number of minutes from the time the start of the oldest unarchived redo log.Normally the parameter will show the number of minutes for which the current log file(s) have been in use and can only have a zero value immediately after a log switch which was immediately followed by archiving the previous log.


It ONLY has meaning if you db is in ARCHIVED mode. It gives you minutes since last time log file has been archived.

I don't see it has anything to with v$log.

v$log is a dynamica view to show status and information for ONLINE log file groups.

They carry different information or serve different purpose. v$log has useful information all the time whether or not db is in archived mode or not.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.