Writer instructions | |
|---|---|
Page title | For most spaces, this page must be titled Space announcements. For spaces with localized content, this page must be titled Space announcements l10n. |
Purpose | Provide an announcement banner on every page of your space. |
Location | Move this page outside of your home branch. |
Guidelines | |
Redo Log Files Not Archived (RedoNotArch)
Description
The RedoNotArchived parameter reports the number of redo log files that have been written but not yet archived, excluding the current online redo log file. This information may be used to alert the database administrator that the archiving process is falling behind. This parameter can only be instantiated when the monitored instance is running in ARCHIVELOG mode.
The default warning and alarm levels do not alert when a single log is waiting for archiving. This prevents false alerts from appearing when the queue is sampled immediately after a redo log switch. When this happens, the queue contains only one file for archiving for a short time. The annotation for this parameter reports the unarchived log files with their date and time of the first time they were written.
Recommendations
You can force a redo log archive using the SQL*DBA command, ALTER SYSTEM ARCHIVE LOG ALL. See your Oracle SQL*DBA manuals for more information.
Thresholds for alarms and warnings
Item | Default threshold | State |
|---|---|---|
Border range | 0-20 | alarm |
Alarm1 range | 2-3 | warn |
Alarm2 range | 3-20 | alarm |
BMC PATROL properties
Attribute | Default value |
|---|---|
Application class | ORACLE_LOG |
Command type | not applicable |
Platform | all |
Icon style | StopLight |
Unit | not applicable |
Border range | 0-20 alarm |
Alarm1 range | 2-3 warn |
Alarm2 range | 3-20 alarm |
Scheduling(poll time) | poll time of collector |
Active at installation | Yes |
Parameter type | Consumer |
Value set by | CollLog |
BMC ProactiveNet Performance Management properties
Attribute | Default value |
|---|---|
Monitor type | Oracle Database Log |
Key Performance Indicator | Yes |
Monitor for abnormalities | Yes |
Graph by default | Yes |
Availability | No |
Response time | No |
Normal distribution | Yes |
Statistical | Yes |