操作系统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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15592508/viewspace-718679/