动态的加载显示oracle警告日志文件内容

原创

一品堂_技术学习笔记 2021-07-16 11:23:18 ©著作权

文章标签 Oracle 文章分类 Oracle 数据库

©著作权归作者所有：来自51CTO博客作者一品堂_技术学习笔记的原创作品，请联系作者获取转载授权，否则将追究法律责任

Last login: Fri Jan 25 00:37:47 2019 from oracle
[root@oracle ~]# su - oracle
[oracle@oracle ~]$ sqlplus / as sysdba;

SQL*Plus: Release 12.1.0.2.0 Production on Fri Jan 25 00:47:07 2019

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select value from v$diag_info;

VALUE
--------------------------------------------------------------------------------
TRUE
/u01/app/oracle
/u01/app/oracle/diag/rdbms/orcl/orcl
/u01/app/oracle/diag/rdbms/orcl/orcl/trace
/u01/app/oracle/diag/rdbms/orcl/orcl/alert
/u01/app/oracle/diag/rdbms/orcl/orcl/incident
/u01/app/oracle/diag/rdbms/orcl/orcl/cdump
/u01/app/oracle/diag/rdbms/orcl/orcl/hm
/u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_17796.trc
2
2

11 rows selected.

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@oracle ~]$ cd /u01/app/oracle/diag/rdbms/orcl/orcl/trace/
[oracle@oracle trace]$ tail -20f alert_orcl.log
TABLE SYS.WRP$_REPORTS_TIME_BANDS: ADDED INTERVAL PARTITION SYS_P820 (3311) VALUES LESS THAN (TO_DATE(' 2019-01-25 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
Fri Jan 25 00:11:25 2019
alter database add logfile group 4 ('/u01/app/oracle/oradata/orcl/redo04_1.log','/u01/app/oracle/oradata/orcl/redo04_2.log') size 50m
Completed: alter database add logfile group 4 ('/u01/app/oracle/oradata/orcl/redo04_1.log','/u01/app/oracle/oradata/orcl/redo04_2.log') size 50m
Fri Jan 25 00:22:53 2019
Thread 1 advanced to log sequence 136 (LGWR switch)
  Current log# 4 seq# 136 mem# 0: /u01/app/oracle/oradata/orcl/redo04_1.log
  Current log# 4 seq# 136 mem# 1: /u01/app/oracle/oradata/orcl/redo04_2.log
Fri Jan 25 00:23:19 2019
Thread 1 advanced to log sequence 137 (LGWR switch)
  Current log# 1 seq# 137 mem# 0: /u01/app/oracle/oradata/orcl/redo01.log
alter database add logfile member '/u01/app/oracle/oradata/orcl/redo02_1.log' to group 2
Completed: alter database add logfile member '/u01/app/oracle/oradata/orcl/redo02_1.log' to group 2
Fri Jan 25 00:33:07 2019
 alter database add logfile member '/u01/app/oracle/oradata/orcl/redo01_1.log' to group 1
Completed:  alter database add logfile member '/u01/app/oracle/oradata/orcl/redo01_1.log' to group 1
Fri Jan 25 00:44:23 2019
Thread 1 advanced to log sequence 138 (LGWR switch)
  Current log# 2 seq# 138 mem# 0: /u01/app/oracle/oradata/orcl/redo02.log
  Current log# 2 seq# 138 mem# 1: /u01/app/oracle/oradata/orcl/redo02_1.log