• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1020
  • Last Modified:

RedoArchDelay

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?
0
JohnLucania
Asked:
JohnLucania
  • 3
2 Solutions
 
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';

0
 
JohnLucaniaAuthor Commented:
(SYSDATE-FIRST_TIME)*1440
-------------------------
                      1.3

It seems that the log was updated.
Why do you use 1440?
0
 
johnsoneSenior Oracle DBACommented:
1440 is the number of minutes in a day.
0
 
actonwangCommented:
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.

see:http://www.bmc.com/supportu/onlinehelpfiles/pok/pokpmlg.htm#pok_parm_redoarchdelay

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.

acton
0
 
johnsoneSenior 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.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now