- 求职 : Linux运维
- 论坛徽章:
- 10
|
最近测试环境的Oracle总是莫名的自动关闭,很是奇怪。在查看了其中的一些日志后发现并没有明显的错误信息。烦请各位指点一下。谢谢~
数据库应该是在2016年12月13日23:59:00关闭的,之后的14日已经没有日志信息了。后在15日上午11:30手工进行了启动数据库操作。
alert.log
- Mon Dec 12 18:00:09 2016
- Thread 1 advanced to log sequence 2179 (LGWR switch)
- Current log# 1 seq# 2179 mem# 0: /u01/app/oradata/editorcl/redo01.log
- Mon Dec 12 18:00:09 2016
- Archived Log entry 2174 added for thread 1 sequence 2178 ID 0xe2bb5f73 dest 1:
- Tue Dec 13 04:00:24 2016
- Thread 1 advanced to log sequence 2180 (LGWR switch)
- Current log# 2 seq# 2180 mem# 0: /u01/app/oradata/editorcl/redo02.log
- Tue Dec 13 04:00:24 2016
- Archived Log entry 2175 added for thread 1 sequence 2179 ID 0xe2bb5f73 dest 1:
- Tue Dec 13 11:00:00 2016
- Setting Resource Manager plan SCHEDULER[0x3003]:DEFAULT_MAINTENANCE_PLAN via scheduler window
- Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
- Tue Dec 13 11:00:00 2016
- Starting background process VKRM
- Tue Dec 13 11:00:00 2016
- VKRM started with pid=21, OS id=20463
- Tue Dec 13 11:00:00 2016
- Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
- End automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
- Tue Dec 13 11:00:15 2016
- Thread 1 advanced to log sequence 2181 (LGWR switch)
- Current log# 3 seq# 2181 mem# 0: /u01/app/oradata/editorcl/redo03.log
- Tue Dec 13 11:00:15 2016
- Archived Log entry 2176 added for thread 1 sequence 2180 ID 0xe2bb5f73 dest 1:
- Tue Dec 13 15:00:00 2016
- Closing scheduler window
- Closing Resource Manager plan via scheduler window
- Clearing Resource Manager plan via parameter
- Tue Dec 13 19:00:45 2016
- Thread 1 advanced to log sequence 2182 (LGWR switch)
- Current log# 1 seq# 2182 mem# 0: /u01/app/oradata/editorcl/redo01.log
- <font color="#ff0000">Tue Dec 13 19:00:46 2016
- Archived Log entry 2177 added for thread 1 sequence 2181 ID 0xe2bb5f73 dest 1:</font>
- <font color="#0000ff">Thu Dec 15 11:30:19 2016
- Starting ORACLE instance (normal)</font>
- ****************** Large Pages Information *****************
-
- Total Shared Global Region in Large Pages = 0 KB (0%)
-
- Large Pages used by this instance: 0 (0 KB)
- Large Pages unused system wide = 0 (0 KB) (alloc incr 16 MB)
- Large Pages configured system wide = 0 (0 KB)
- Large Page size = 2048 KB
-
- RECOMMENDATION:
- Total Shared Global Region size is 3890 MB. For optimal performance,
- prior to the next instance restart increase the number
- of unused Large Pages by atleast 1945 2048 KB Large Pages (3890 MB)
- system wide to get 100% of the Shared
- Global Region allocated with Large pages
- ***********************************************************
- LICENSE_MAX_SESSION = 0
- LICENSE_SESSIONS_WARNING = 0
- Picked latch-free SCN scheme 3
- Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST
- Autotune of undo retention is turned on.
- IMODE=BR
- ILAT =85
- LICENSE_MAX_USERS = 0
- SYS auditing is disabled
- Starting up:
复制代码 orc.trc文件
|
|