Databases Reference
In-Depth Information
It appears that the new redo logs were created on June 22, 2004, at about
10:23
You can also see that the control file was automatically backed up by
EM Database Control when the new redo log files were created.
PM
Maintaining the Alert Log File
The alert log file grows in size slowly but without limit. After a few weeks, it can
become cumbersome to review the file, so it's a good idea to archive or delete the
file on a periodic basis.
The alert log file can be safely renamed or deleted, even when the database is
up and running. The next time an entry needs to be written to the alert log file
and the alert log file is not there, a new one is created.
Janice, the DBA, reviews the alert log file every Friday and renames it with a
name containing the date it was renamed:
[oracle@oltp oracle]$ cd /u01/app/oracle/admin/ord/bdump
[oracle@oltp bdump]$ ls -l alert_*.log
-rw-r--r-- 1 oracle oinstall 4006 Jun 22 22:23 alert_ord.log
