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博客 ” ,链接:http://blog.itpub.net/16976507/viewspace-1268721/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/16976507/viewspace-1268721/