ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-07445异常alert log信息

ORA-07445异常alert log信息

原创 Linux操作系统 作者:dukewyh 时间:2012-03-15 19:22:09 0 删除 编辑

操作系统shutdown前,数据库实例未关闭,报ORA-07445,记录alert.log信息,从中可以了解到操作系统shutdown时,数据库的关闭及重新启动记录:

Mon Mar 12 14:15:44 2012
Errors in file d:\oracle\admin\mes\bdump\mes_s000_6272.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [kghfrf+157] [PC:0x51F4AE9] [ADDR:0x20C5C0DC] [UNABLE_TO_READ] []

Oracle关闭实例:

Mon Mar 12 14:15:57 2012
Shutting down instance: further logons disabled
Mon Mar 12 14:15:58 2012
Stopping background process QMNC
Mon Mar 12 14:15:59 2012
Stopping background process CJQ0
Mon Mar 12 14:15:59 2012
Background process QMNC not dead after 150 seconds
Mon Mar 12 14:15:59 2012
Stopping background process MMNL
Mon Mar 12 14:16:00 2012
found dead shared server 'S000', pid = (62, 3)
failed to start shared server, er=0
Mon Mar 12 14:16:00 2012
Background process MMNL not dead after 10 seconds
Mon Mar 12 14:16:00 2012
Stopping background process MMON
Mon Mar 12 14:16:01 2012
Background process MMON not dead after 30 seconds
Mon Mar 12 14:16:01 2012
Shutting down instance (normal)
License high water mark = 163
Mon Mar 12 14:16:01 2012
Stopping Job queue slave processes, flags = 2
Mon Mar 12 14:16:01 2012
Job queue slave processes stopped
Dump file d:\oracle\admin\mes\bdump\alert_mes.log

数据库实例启动过程:


Mon Mar 12 15:47:46 2012
ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows Server 2003 Version V5.2 Service Pack 2
CPU                 : 8 - type 8664, 2 Physical Cores
Process Affinity    : 0x0000000000000000
Memory (Avail/Total): Ph:19223M/20477M, Ph+PgF:20887M/21833M
Mon Mar 12 15:47:46 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =36
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
  processes                = 300
  sessions                 = 335
  sga_max_size             = 16106127360
  __shared_pool_size       = 4513071104
  __large_pool_size        = 67108864
  __java_pool_size         = 16777216
  __streams_pool_size      = 16777216
  sga_target               = 16106127360
  control_files            = D:\ORACLE\ORADATA\MES\CONTROL01.CTL, D:\ORACLE\ORADATA\MES\CONTROL02.CTL, D:\ORACLE\ORADATA\MES\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 11475615744
  compatible               = 10.2.0.3.0
  log_archive_dest_1       = LOCATION=d:\oracle\arch\mes
  log_archive_format       = ARC%S_%R.%T
  db_file_multiblock_read_count= 16
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  dispatchers              = (protocol=TCP)
  shared_servers           = 1
  utl_file_dir             = D:\oracle\ora102\log\mes_prod_db\
  job_queue_processes      = 10
  audit_file_dest          = D:\ORACLE\ADMIN\MES\ADUMP
  background_dump_dest     = D:\ORACLE\ADMIN\MES\BDUMP
  user_dump_dest           = D:\ORACLE\ADMIN\MES\UDUMP
  core_dump_dest           = D:\ORACLE\ADMIN\MES\CDUMP
  db_name                  = MES
  open_cursors             = 300
  pga_aggregate_target     = 4111357444096
PMON started with pid=2, OS id=4624
MMAN started with pid=6, OS id=4636
DBW0 started with pid=8, OS id=4648
DBW1 started with pid=10, OS id=4652
LGWR started with pid=12, OS id=4656
CKPT started with pid=14, OS id=4660
SMON started with pid=16, OS id=4664
RECO started with pid=18, OS id=4668
CJQ0 started with pid=20, OS id=4672
MMON started with pid=22, OS id=4676
Mon Mar 12 15:47:54 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=24, OS id=4680
Mon Mar 12 15:47:54 2012
starting up 1 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
PSP0 started with pid=4, OS id=4632
Mon Mar 12 15:47:55 2012
alter database mount exclusive
Mon Mar 12 15:47:59 2012
Setting recovery target incarnation to 1
Mon Mar 12 15:47:59 2012
Successful mount of redo thread 1, with mount id 1861340267
Mon Mar 12 15:47:59 2012
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Mar 12 15:47:59 2012
alter database open
Mon Mar 12 15:48:00 2012
Beginning crash recovery of 1 threads
Mon Mar 12 15:48:00 2012
Started redo scan
Mon Mar 12 15:48:00 2012
Completed redo scan
 156 redo blocks read, 57 data blocks need recovery
Mon Mar 12 15:48:00 2012
Started redo application at
 Thread 1: logseq 37831, block 48079
Mon Mar 12 15:48:00 2012
Recovery of Online Redo Log: Thread 1 Group 1 Seq 37831 Reading mem 0
  Mem# 0: D:\ORACLE\ORADATA\MES\REDO01.LOG
Mon Mar 12 15:48:00 2012
Completed redo application
Mon Mar 12 15:48:00 2012
Completed crash recovery at
 Thread 1: logseq 37831, block 48235, scn 822500105
 57 data blocks read, 57 data blocks written, 156 redo blocks read
Mon Mar 12 15:48:01 2012
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=32, OS id=4808
ARC1 started with pid=34, OS id=4812
Mon Mar 12 15:48:01 2012
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Mon Mar 12 15:48:01 2012
Thread 1 advanced to log sequence 37832 (thread open)
Thread 1 opened at log sequence 37832
  Current log# 2 seq# 37832 mem# 0: D:\ORACLE\ORADATA\MES\REDO02.LOG
Successful open of redo thread 1
Mon Mar 12 15:48:01 2012
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Mon Mar 12 15:48:01 2012
ARC0: Becoming the heartbeat ARCH
Mon Mar 12 15:48:01 2012
SMON: enabling cache recovery
Mon Mar 12 15:48:04 2012
Successfully onlined Undo Tablespace 1.
Mon Mar 12 15:48:04 2012
SMON: enabling tx recovery
Mon Mar 12 15:48:04 2012
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=36, OS id=4920
Mon Mar 12 15:48:08 2012
Completed: alter database open
Mon Mar 12 15:48:27 2012
ALTER SYSTEM ARCHIVE LOG
Mon Mar 12 15:48:27 2012
Thread 1 advanced to log sequence 37833 (LGWR switch)
  Current log# 3 seq# 37833 mem# 0: D:\ORACLE\ORADATA\MES\REDO03.LOG
Mon Mar 12 15:48:45 2012
Starting control autobackup
Control autobackup written to DISK device
 handle 'D:\ORACLE\BACKUP\MES\20120312_C-1775973257-20120312-03.BCK'
Mon Mar 12 16:33:26 2012
Thread 1 advanced to log sequence 37834 (LGWR switch)
  Current log# 1 seq# 37834 mem# 0: D:\ORACLE\ORADATA\MES\REDO01.LOG
Mon Mar 12 17:25:38 2012
Thread 1 advanced to log sequence 37835 (LGWR switch)
  Current log# 2 seq# 37835 mem# 0: D:\ORACLE\ORADATA\MES\REDO02.LOG

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15592508/viewspace-718679/,如需转载,请注明出处,否则将追究法律责任。

下一篇: ORA-00265
请登录后发表评论 登录
全部评论

注册时间:2011-04-12

  • 博文量
    28
  • 访问量
    82590