Question: What do I do to monitor
my archived redo log directory to keep it from getting full
and locking up my database? Is there a script to
monitor my alert log directory?
Answer: You
can easily monitor your archived redo log directory to send
an alert when it reaches 90% full. The solution fix is
to delete the oldest archived redo log files, or move them
into another mount point. Low free space in the
archived redo log directory requires a special procedure.
If the archived redo log directory becomes full, your Oracle
database will hang up. This procedure send a text message
alert to the DBA’s phone and allows the Oracle Remote DBA to
add space (or move old redo logs) before the database hangs.
Here is an example of a UNIX script for keeping the
archived redo log directory free of elderly files. As
we know, it is important to keep room in this directory,
because Oracle may “lock-up” if it cannot write a current
redo log to the archived redo log filesystem. This script
could be used in coordination with Oracle Recovery Manager (rman)
to only remove files after a full backup has been taken.
This can be scheduled to run using a crontab (cron) task:
#!/bin/ksh
# Cleanup archive redo logs that
are more than 7 days old
find /u01/app/oracle/admin/mysid/arch/arch_mysid*.arc
-ctime +7 -exec rm {} ;
As we see, it is very easy to clean-out the redo log
directory, and you can monitor the spaced used in the
archived redo log directory with the df –k UNIX/Linux
command. You can also monitor the archived redo log
directory status with Oracle Enterprise Manager (OEM).
|
|
|
|
|
Oracle Training from Don Burleson
The best on site
"Oracle
training classes" are just a phone call away! You can get personalized Oracle training by Donald Burleson, right at your shop!
|
|
|
|
| |
|
Burleson is the American Team
Note:
This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.
Verify
experience!
Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.
Errata?
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just
e-mail:
 and include the URL for the page.
Copyright © 1996 - 2020
All rights reserved by
Burleson
Oracle ®
is the registered trademark of Oracle Corporation.
|
|
