truncate、recreate后台进程跟踪文件（trace file）

为了

a) 查后台进程PID或OSPID

select pid from v$process where program like ‘%LGWR%’;

或

[oracle@rac03 bdump]$ ps -ef |grep lgwr

oracle 1811 28745 0 11:11 pts/2 00:00:00 grep lgwr

oracle 7370 1 0 Sep09 ? 00:00:18 ora_lgwr_racdb3

或

[oracle@rac03 bdump]$ ll -rt |tail |grep lgwr

-rw-r----- 1 oracle oinstall 1268 Sep 3 14:03 racdb3_lgwr_26203.trc

-rw-r----- 1 oracle oinstall 731 Sep 3 14:05 racdb3_lgwr_8977.trc

-rw-r----- 1 oracle oinstall 703 Sep 3 17:44 racdb3_lgwr_7333.trc

-rw-r----- 1 oracle oinstall 6371 Sep 9 11:30 racdb3_lgwr_7370.trc

b) oradebug setorapid 6或 oradebug setospid 7370

c) 操作系统手动更名文件（相当于truncate操作）

#mv racdb3_lgwr_7370.trc backup_lgwr.trc

d) oradebug close_trace;

当后台进程要写日志则会重新创建trace file；

e) 如果要立即重建丢失的后台进程跟踪文件，则执行oradebug flush

参考文档：

How to recreate background trace file(s) that may have been accidentally deleted (文档 ID 394891.1)

How To Truncate a Background Trace File Without Bouncing the Database (文档 ID 564989.1)

ITPub博客

truncate、recreate后台进程跟踪文件（trace file）