通过关闭trace再次产生日志文件

当日志文件因为某些原因没有时，可以通过下面的方式再次生成日志文件：

oradebug close_trace;

SQL> conn /as sysdba

Connected.

SQL> 

SQL> 

SQL> 

SQL> oradebug setmypid

Statement processed.

SQL> oradebug tracefile_name

/u01/apppp/diag/rdbms/ogg1/ogg1/trace/ogg1_ora_8698.trc

SQL> ! ls -al /u01/apppp/diag/rdbms/ogg1/ogg1/trace/ogg1_ora_8698.trc

-rw-r----- 1 oracle oinstall 1203 Sep  9 19:28 /u01/apppp/diag/rdbms/ogg1/ogg1/trace/ogg1_ora_8698.trc   --存在日志文件

SQL> ! rm /u01/apppp/diag/rdbms/ogg1/ogg1/trace/ogg1_ora_8698.trc   --删掉

SQL>  ! ls -al /u01/apppp/diag/rdbms/ogg1/ogg1/trace/ogg1_ora_8698.trc   --没有了

ls: /u01/apppp/diag/rdbms/ogg1/ogg1/trace/ogg1_ora_8698.trc: No such file or directory

SQL> alter session set sql_trace=true;

Session altered.

SQL> select count(*) from song.t;

  COUNT(*)

----------

         1

SQL> alter session set sql_trace=false;

Session altered.

SQL> oradebug tracefile_name

/u01/apppp/diag/rdbms/ogg1/ogg1/trace/ogg1_ora_8698.trc

SQL> ! ls -al /u01/apppp/diag/rdbms/ogg1/ogg1/trace/ogg1_ora_8698.trc       --根踪之后还是没有

ls: /u01/apppp/diag/rdbms/ogg1/ogg1/trace/ogg1_ora_8698.trc: No such file or directory

SQL> oradebug close_trace;         --关闭之后 重新生成

Statement processed.

SQL> ! ls -al /u01/apppp/diag/rdbms/ogg1/ogg1/trace/ogg1_ora_8698.trc

-rw-r----- 1 oracle oinstall 979 Sep  9 19:30 /u01/apppp/diag/rdbms/ogg1/ogg1/trace/ogg1_ora_8698.trc

by song

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25099483/viewspace-772441/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25099483/viewspace-772441/