数据库正在运行着,如何清理太大的alert.log文件?
不能用mv方法.
官方建议:
How Do You Reduce The Size Of An Alert Log That Is Too Large To Edit while the DB is running? (Doc ID 296354.1)
GOAL:
How do you reduce the size of the alert log while the database is still running and is too large to edit?
SOLUTION:
There really is no way to reduce the size other than start a new file
1) COPY the alert log to a new name
EXAMPLE:
cp ALERT_MYSID.LOG ALERT_MYSID.2004 首先保障2倍空间,但是如果很大会不会?
2) Delete the existing alert log
EXAMPLE:
rm ALERT_MYSID.LOG
After this the database should recreate an empty file and continue logging to it.
If the log will not delete due to file locking ... you will need to delete the copy and try steps
1 and 2 again until it succeeds ... if you continue to fail ... you will need to shutdown to do
the process.
你看,最后一段说明,多麻烦,还是定期重启数据库大 法好,重启时趁机改名字或rm岂不简单。