首先了解oracle的警报日志文件
警报日志是oracle数据库运行产生的日志信息,主要包含数据库的启动和关闭,数据库内部执行的操作,数据库报错等信息,主要用于DBA对数据库的日常诊断。
当数据库出现问题时,警报日志会指出问题所在,比如说表不能增加存储空间,回滚段问题等等都包含在警报日志中,正因如此,每天都要检查警报日志,看看数据库有没有什么异常。
可通过background_dump_dest参数查看警报日志的路径:
SYS@orcl 05-SEP-14>show parameter background_dump_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest string /u01/app/oracle/diag/rdbms/orc
l/orcl/trace
由于警报日志是持续性写入的,可以使用
tail -f 查看警报日志文件的内容,通过这个命令可以捕捉日志的变化。
[oracle@localhost trace]$ tail -f alert_orcl.log
Current log# 2 seq# 14 mem# 0: /u01/app/oracle/oradata/orcl/redo02.log
Thread 1 advanced to log sequence 15 (LGWR switch)
Current log# 3 seq# 15 mem# 0: /u01/app/oracle/oradata/orcl/redo03.log
Fri Sep 05 18:57:26 2014
Archived Log entry 111 added for thread 1 sequence 14 ID 0x52835472 dest 1:
Archived Log entry 112 added for thread 1 sequence 14 ID 0x52835472 dest 2:
Fri Sep 05 19:01:46 2014
Starting background process SMCO
Fri Sep 05 19:01:46 2014
SMCO started with pid=37, OS id=19485
下面用shutdown abort关闭数据库:
SYS@orcl 05-SEP-14>shutdown abort
ORACLE instance shut down.
再用tail -f查看警报日志的信息:
Shutting down instance (abort)
License high water mark = 13
USER (ospid: 18818): terminating the instance
Instance terminated by USER, pid = 18818
Fri Sep 05 19:37:48 2014
Instance shutdown complete
再打开数据库:
SYS@orcl 05-SEP-14>startup
ORACLE instance started.
Total System Global Area 849530880 bytes
Fixed Size 1339824 bytes
Variable Size 587206224 bytes
Database Buffers 255852544 bytes
Redo Buffers 5132288 bytes
Database mounted.
Database opened.
警报日志是oracle数据库运行产生的日志信息,主要包含数据库的启动和关闭,数据库内部执行的操作,数据库报错等信息,主要用于DBA对数据库的日常诊断。
当数据库出现问题时,警报日志会指出问题所在,比如说表不能增加存储空间,回滚段问题等等都包含在警报日志中,正因如此,每天都要检查警报日志,看看数据库有没有什么异常。
可通过background_dump_dest参数查看警报日志的路径:
SYS@orcl 05-SEP-14>show parameter background_dump_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest string /u01/app/oracle/diag/rdbms/orc
l/orcl/trace
[oracle@localhost trace]$ tail -f alert_orcl.log
Current log# 2 seq# 14 mem# 0: /u01/app/oracle/oradata/orcl/redo02.log
Thread 1 advanced to log sequence 15 (LGWR switch)
Current log# 3 seq# 15 mem# 0: /u01/app/oracle/oradata/orcl/redo03.log
Fri Sep 05 18:57:26 2014
Archived Log entry 111 added for thread 1 sequence 14 ID 0x52835472 dest 1:
Archived Log entry 112 added for thread 1 sequence 14 ID 0x52835472 dest 2:
Fri Sep 05 19:01:46 2014
Starting background process SMCO
Fri Sep 05 19:01:46 2014
SMCO started with pid=37, OS id=19485
SYS@orcl 05-SEP-14>shutdown abort
ORACLE instance shut down.
Shutting down instance (abort)
License high water mark = 13
USER (ospid: 18818): terminating the instance
Instance terminated by USER, pid = 18818
Fri Sep 05 19:37:48 2014
Instance shutdown complete
SYS@orcl 05-SEP-14>startup
ORACLE instance started.
Total System Global Area 849530880 bytes
Fixed Size 1339824 bytes
Variable Size 587206224 bytes
Database Buffers 255852544 bytes
Redo Buffers 5132288 bytes
Database mounted.
Database opened.
在警报日志文件中可以看到如下恢复信息:
Fri Sep 05 19:39:29 2014
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
Started redo scan
Completed redo scan
read 639 KB redo, 183 data blocks need recovery
Started redo application at
Thread 1: logseq 15, block 10756
Recovery of Online Redo Log: Thread 1 Group 3 Seq 15 Reading mem 0
Mem# 0: /u01/app/oracle/oradata/orcl/redo03.log
Completed redo application of 0.33MB
Completed crash recovery at
Thread 1: logseq 15, block 12034, scn 1089266
183 data blocks read, 183 data blocks written, 639 redo k-bytes read
如果以shutdown abort方式关闭数据库,数据库不会进行检查点操作,buffer cache中的脏数据没有写回到数据文件中,数据库不一致,重新启动的时候需要进行数据库恢复,恢复依赖于重做日志文件。
Fri Sep 05 19:39:29 2014
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
Started redo scan
Completed redo scan
read 639 KB redo, 183 data blocks need recovery
Started redo application at
Thread 1: logseq 15, block 10756
Recovery of Online Redo Log: Thread 1 Group 3 Seq 15 Reading mem 0
Mem# 0: /u01/app/oracle/oradata/orcl/redo03.log
Completed redo application of 0.33MB
Completed crash recovery at
Thread 1: logseq 15, block 12034, scn 1089266
183 data blocks read, 183 data blocks written, 639 redo k-bytes read
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29800581/viewspace-1265107/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29800581/viewspace-1265107/