Posted on 2006-05-22
Last Modified: 2008-01-09
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?
Question by:JohnLucania
    LVL 34

    Expert Comment

    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';


    Author Comment


    It seems that the log was updated.
    Why do you use 1440?
    LVL 34

    Expert Comment

    1440 is the number of minutes in a day.
    LVL 19

    Assisted Solution

    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.

    LVL 34

    Accepted Solution

    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.

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
    Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now