Oracle Listener Log File清理

本文章基于个人实验环境，仅供交流学习使用。

OFFLINE方式清理

1.检查监听状态

可以看到我们当前日志信息正常,Log File路径也在其中有描述。

[root@asm ~]# su - oracle
[oracle@asm db_1]$ lsnrctl status
···
Listener Parameter File   /u01/app/19c/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/asm/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.88.81)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
  Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "fad59df3160b663de0558df00550a5e0" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "pdb_orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully

2.进入到Log File目录下检查其Log File大小

[oracle@asm db_1]$ cd /u01/app/grid/diag/tnslsnr/asm/listener/alert/
#其它检查其大小的命令还有:du -sh log.xml
[oracle@asm alert]$ ll -h
total 4.0M
-rw-r----- 1 grid oinstall 4.0M Jun 12 18:27 log.xml

3.停止listener Log写入

之所以从oracle进入到lsnrctl命令行会导致log_status off失败是因为当前是ASM环境，监听文件属于grid:oinstall。

[oracle@asm alert]$ lsnrctl
LSNRCTL> set log_status off
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-01190: The user is not authorized to execute the requested listener command
[root@asm ~]# su - grid
LSNRCTL> set log_status off
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.88.81)(PORT=1521)))
LISTENER parameter "log_status" set to OFF
The command completed successfully

4.备份Log File

[grid@asm:/u01/app/grid/diag/tnslsnr/asm/listener/alert]$ mv log.xml log.xml.bak
[grid@asm:/u01/app/grid/diag/tnslsnr/asm/listener/alert]$ ll
total 4080
-rw-r----- 1 grid oinstall 4173149 Jun 12 18:33 log.xml.bak

5.写日志开启

[grid@asm:/u01/app/grid/diag/tnslsnr/asm/listener/alert]$ lsnrctl
#可以看到Listener Log File 由于我们off掉了log_status已经不在了
LSNRCTL> status
···
Listener Parameter File   /u01/app/19c/grid/network/admin/listener.ora
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.88.81)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
···

#开启日志写入
LSNRCTL> set log_status on
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.88.81)(PORT=1521)))
LISTENER parameter "log_status" set to ON
The command completed successfully

#检查状态
LSNRCTL> status
···
Listener Parameter File   /u01/app/19c/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/asm/listener/alert/log.xml
···
LSNRCTL> exit
[grid@asm:/u01/app/grid/diag/tnslsnr/asm/listener/alert]$ ll
total 4084
-rw-r----- 1 grid oinstall     900 Jun 12 18:39 log.xml
-rw-r----- 1 grid oinstall 4173149 Jun 12 18:33 log.xml.bak

/以上为OFFLINE方式/

ONLINE方式清理

1.检查监听状态

[root@asm ~]# su - grid
[grid@asm:/home/grid]$ lsnrctl status
···
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.88.81)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
···

2.进入到对应目录

[grid@asm:/home/grid]$ cd /u01/app/grid/diag/tnslsnr/asm/listener/alert/
[grid@asm:/u01/app/grid/diag/tnslsnr/asm/listener/alert]$ ll -h
total 4.0M
-rw-r----- 1 grid oinstall 6.6K Jun 12 18:50 log.xml
-rw-r----- 1 grid oinstall 4.0M Jun 12 18:33 log.xml.bak

3.清理Log File

#其原理就是以空数据覆写
[grid@asm:/u01/app/grid/diag/tnslsnr/asm/listener/alert]$ cp /dev/null log.xml

4.检查监听状态

[grid@asm:/u01/app/grid/diag/tnslsnr/asm/listener/alert]$ lsnrctl status
···
Listener Parameter File   /u01/app/19c/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/asm/listener/alert/log.xml
···

测试

经测试，无论是OFFLINE还是ONLINE方式均可以清理listener log file,监听状态无异常。