/**PageBeginHtml Block Begin **/ /***自定义返回顶部小火箭***/ /*生成博客目录的JS 开始*/ /*生成博客目录的JS 结束*/

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

* 博客文章部分截图及内容来自于学习的书本及相应培训课程以及网络其他博客,仅做学习讨论之用,不做商业用途。
* 如有侵权,马上联系我,我立马删除对应链接。
* @author Alan
* @Email no008@foxmail.com



复制代码
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
复制代码
posted @   一品堂.技术学习笔记  阅读(727)  评论(0编辑  收藏  举报
编辑推荐:
· 一个奇形怪状的面试题:Bean中的CHM要不要加volatile?
· [.NET]调用本地 Deepseek 模型
· 一个费力不讨好的项目,让我损失了近一半的绩效!
· .NET Core 托管堆内存泄露/CPU异常的常见思路
· PostgreSQL 和 SQL Server 在统计信息维护中的关键差异
阅读排行:
· DeepSeek “源神”启动!「GitHub 热点速览」
· 微软正式发布.NET 10 Preview 1:开启下一代开发框架新篇章
· C# 集成 DeepSeek 模型实现 AI 私有化(本地部署与 API 调用教程)
· DeepSeek R1 简明指南:架构、训练、本地部署及硬件要求
· 2 本地部署DeepSeek模型构建本地知识库+联网搜索详细步骤
点击右上角即可分享
微信分享提示