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

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

阅读量：6872 次

发布时间：2019-06-26

本文共 2389 字，大约阅读时间需要 7 分钟。

login: Fri Jan 25 00:37:47 2019  oracle[root@oracle ~]# su - oracle[oracle@oracle ~]$ sqlplus /  sysdba;*Plus: Release 12.1.0.2.0 Production  Fri Jan 25 00:47:07 2019Copyright (c) 1982, 2014, Oracle.   rights reserved.Connected :Oracle  12c Enterprise Edition Release 12.1.0.2.0 - 64 Production the Partitioning, OLAP, Advanced Analytics   Application Testing options>    v$diag_info;--------------------------------------------------------------------------------/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.trc2211  selected.> Disconnected  Oracle  12c Enterprise Edition Release 12.1.0.2.0 - 64 Production the Partitioning, OLAP, Advanced Analytics   Application Testing options[oracle@oracle ~]$ cd /u01/app/oracle/diag/rdbms/orcl/orcl/trace/[oracle@oracle trace]$ tail -20f alert_orcl.log SYS.WRP$_REPORTS_TIME_BANDS: ADDED  PARTITION SYS_P820 (3311)  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   logfile  4 ('/u01/app/oracle/oradata/orcl/redo04_1.log','/u01/app/oracle/oradata/orcl/redo04_2.log')  50mCompleted:    logfile  4 ('/u01/app/oracle/oradata/orcl/redo04_1.log','/u01/app/oracle/oradata/orcl/redo04_2.log')  50mFri Jan 25 00:22:53 2019Thread 1 advanced  log sequence 136 (LGWR switch)   log# 4 seq# 136 mem# 0: /u01/app/oracle/oradata/orcl/redo04_1.log   log# 4 seq# 136 mem# 1: /u01/app/oracle/oradata/orcl/redo04_2.logFri Jan 25 00:23:19 2019Thread 1 advanced  log sequence 137 (LGWR switch)   log# 1 seq# 137 mem# 0: /u01/app/oracle/oradata/orcl/redo01.log   logfile member '/u01/app/oracle/oradata/orcl/redo02_1.log'   2Completed:    logfile member '/u01/app/oracle/oradata/orcl/redo02_1.log'   2Fri Jan 25 00:33:07 2019    logfile member '/u01/app/oracle/oradata/orcl/redo01_1.log'   1Completed:     logfile member '/u01/app/oracle/oradata/orcl/redo01_1.log'   1Fri Jan 25 00:44:23 2019Thread 1 advanced  log sequence 138 (LGWR switch)   log# 2 seq# 138 mem# 0: /u01/app/oracle/oradata/orcl/redo02.log   log# 2 seq# 138 mem# 1: /u01/app/oracle/oradata/orcl/redo02_1.log

转载于:https://www.cnblogs.com/ios9/p/10317712.html

你可能感兴趣的文章

externkeyword放到函数体内而导致的linkage问题

查看>>

linux常用命令 3

查看>>

Environment.SpecialFolder.CommonApplicationData

查看>>

ng-repeat-start ng-repeat-end 的使用

查看>>

Response.Redirect 打开新窗体的两种方法

查看>>