ALTER SYSTEM RECLAIM LOG 命令用于清理日志文件并释放磁盘空间。
To fix the log volume full situation:
1)stop the database
2)move few of the log segments to new location and create the soft link
3)start the database
4)check the status of the log segments.
select state from m_log_segments;
5)if the state of the log segments is ‘free’ then execute ‘alter system reclaim log’ to clear the space. i.e alter system reclaim log works only if the status of the log segment is ’ free’.
6)if the status is not free, then check the log backups if they are working fine.
注:如果是测试环境,可以将数据库参数log_mode由“normal”值更改为“overwrite”进行循环覆盖。
参考:
note 1679938:Disk Full Event on Log Volume