oracle alert log file(告警日志文件)
来源:互联网 发布:出租车gps数据 编辑:程序博客网 时间:2024/06/07 01:45
The alert log is a chronological log of messages and errors, and includes the following items:
All internal errors (ORA-00600), block corruption errors (ORA-01578), and deadlock errors (ORA-00060) that occur
Administrative operations, such as CREATE, ALTER, and DROP statements and STARTUP, SHUTDOWN, and ARCHIVELOG statements
Messages and errors relating to the functions of shared server and dispatcher processes
Errors occurring during the automatic refresh of a materialized view
The values of all initialization parameters that had nondefault values at the time the database and instance start
Oracle Database uses the alert log to record these operations as an alternative to displaying the information on an operator's console (although some systems also display information on the console). If an operation is successful, a "completed" message is written in the alert log, along with a timestamp.
存放位置:由初始化参数background_dump_dest决定(默认:$ORACLE_HOME/rdbms/log/alert_SID.log)
内容包括:系统内部错误(Ora-600);数据块损坏(Ora-1578,Ora-1498);影响数据库结构,初始化参数等的操作记录;Instance启动时记录所有非默认值的初始化参数;
(如果初始化参数log_checkpoints_to_alert设置为true,则还会记录checkpoit的开始和结束时间,未完成的checkpoint,归档日志需要的时间,实例恢复的开始和结束时间等)
All internal errors (ORA-00600), block corruption errors (ORA-01578), and deadlock errors (ORA-00060) that occur
Administrative operations, such as CREATE, ALTER, and DROP statements and STARTUP, SHUTDOWN, and ARCHIVELOG statements
Messages and errors relating to the functions of shared server and dispatcher processes
Errors occurring during the automatic refresh of a materialized view
The values of all initialization parameters that had nondefault values at the time the database and instance start
Oracle Database uses the alert log to record these operations as an alternative to displaying the information on an operator's console (although some systems also display information on the console). If an operation is successful, a "completed" message is written in the alert log, along with a timestamp.
存放位置:由初始化参数background_dump_dest决定(默认:$ORACLE_HOME/rdbms/log/alert_SID.log)
内容包括:系统内部错误(Ora-600);数据块损坏(Ora-1578,Ora-1498);影响数据库结构,初始化参数等的操作记录;Instance启动时记录所有非默认值的初始化参数;
(如果初始化参数log_checkpoints_to_alert设置为true,则还会记录checkpoit的开始和结束时间,未完成的checkpoint,归档日志需要的时间,实例恢复的开始和结束时间等)
0 0
- oracle alert log file(告警日志文件)
- ORACLE告警日志文件( alert log file)存储信息
- 如何查看alert.log告警日志
- 查看alert<sid>.log告警文件路径
- Script:利用外部表实现SQL查询Oracle告警日志Alert.log
- Script:利用外部表实现SQL查询Oracle告警日志Alert.log
- 利用外部表实现SQL查询Oracle告警日志Alert.log
- 利用外部表实现SQL查询Oracle告警日志Alert.log
- Oracle告警日志文件
- ORACLE告警日志文件
- 监控oracle的alert日志文件的ORA-字符串,有则告警
- Linux/Unix shell 监控Oracle告警日志(monitor alter log file)
- Linux/Unix shell 监控Oracle告警日志(monitor alter log file)
- Oracle 联机重做日志文件(ONLINE LOG FILE)
- Oracle 联机重做日志文件(ONLINE LOG FILE)
- Oracle 联机重做日志文件(ONLINE LOG FILE)
- Oracle 联机重做日志文件(ONLINE LOG FILE)
- Oracle 联机重做日志文件(ONLINE LOG FILE)
- oracle order by与union一起使用的用法
- elasticsearch 创建搜索初步
- oracle with语句详解
- 欢迎使用CSDN-markdown编辑器
- ORACLE临时表—ON COMMIT PRESERVE ROWS
- oracle alert log file(告警日志文件)
- 项目管理神器——maven篇(一)
- oracle 11g新特性:Pending Statistics
- LINUX VPS主机之间快速复制备份搬家
- oracle 存储过程执行权限
- oracle O7_DICTIONARY_ACCESSIBILITY参数
- oracle 数据块结构
- javamail实现发送邮件
- PL/SQL导入SQL文件乱码用PL/SQL的importtables->sqlinsert