oracle宕机原因排查,ORACLE服务器宕机问题

下面是日志。宕机是10月10号那天，大家帮忙看下，能看出什么问题么？

Fri Oct 09 00:00:06 2009

Thread 1 advanced to log sequence 196

Current log# 3 seq# 196 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\REDO03.LOG

Fri Oct 09 00:00:37 2009

Thread 1 advanced to log sequence 197

Current log# 1 seq# 197 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\REDO01.LOG

Fri Oct 09 12:17:02 2009

Thread 1 advanced to log sequence 198

Current log# 2 seq# 198 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\REDO02.LOG

Fri Oct 09 22:00:07 2009

Thread 1 advanced to log sequence 199

Current log# 3 seq# 199 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\REDO03.LOG

Fri Oct 09 23:00:11 2009

Thread 1 advanced to log sequence 200

Current log# 1 seq# 200 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\REDO01.LOG

Sat Oct 10 00:00:04 2009

Thread 1 advanced to log sequence 201

Current log# 2 seq# 201 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\REDO02.LOG

Sat Oct 10 00:40:01 2009

Thread 1 advanced to log sequence 202

Current log# 3 seq# 202 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\REDO03.LOG

Dump file d:\oracle\product\10.2.0\admin\dbserver\bdump\alert_dbserver.log

Sat Oct 10 08:43:44 2009

ORACLE V10.2.0.3.0 - Production vsnsta=0

vsnsql=14 vsnxtr=3

Windows NT Version V6.0 Service Pack 1

CPU                 : 12 - type 586, 12 Physical Cores

Process Affinity    : 0x00000000

Memory (Avail/Total): Ph:3653M/4093M, Ph+PgF:8041M/8357M, VA:1926M/2047M

Sat Oct 10 08:43:44 2009

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 2

Autotune of undo retention is turned on.

IMODE=BR

ILAT =61

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.3.0.

System parameters with non-default values:

processes                = 500

sessions                 = 555

__shared_pool_size       = 318767104

__large_pool_size        = 4194304

__java_pool_size         = 8388608

__streams_pool_size      = 0

nls_language             = SIMPLIFIED CHINESE

nls_territory            = CHINA

sga_target               = 1073741824

control_files            = D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\CONTROL03.CTL

db_block_size            = 8192

__db_cache_size          = 734003200

compatible               = 10.2.0.3.0

log_archive_dest_1       = LOCATION=E:\Oracle_Backup\Archive

log_archive_format       = ARC%S_%R.%T

db_file_multiblock_read_count= 8

db_recovery_file_dest    = D:\oracle\product\10.2.0\flash_recovery_area

db_recovery_file_dest_size= 2147483648

undo_management          = AUTO

undo_tablespace          = UNDOTBS1

remote_login_passwordfile= EXCLUSIVE

db_domain                =

dispatchers              = (PROTOCOL=TCP) (SERVICE=dbserverXDB)

job_queue_processes      = 10

audit_file_dest          = D:\ORACLE\PRODUCT\10.2.0\ADMIN\DBSERVER\ADUMP

background_dump_dest     = D:\ORACLE\PRODUCT\10.2.0\ADMIN\DBSERVER\BDUMP

user_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\ADMIN\DBSERVER\UDUMP

core_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\ADMIN\DBSERVER\CDUMP

db_name                  = dbserver

open_cursors             = 300

pga_aggregate_target     = 524288000

MMAN started with pid=4, OS id=2376

DBW0 started with pid=5, OS id=2380

DBW1 started with pid=6, OS id=2384

LGWR started with pid=7, OS id=2388

CKPT started with pid=8, OS id=2392

SMON started with pid=9, OS id=2396

RECO started with pid=10, OS id=2400

CJQ0 started with pid=11, OS id=2404

MMON started with pid=12, OS id=2408

Sat Oct 10 08:43:46 2009

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

Sat Oct 10 08:43:46 2009

starting up 1 shared server(s) ...

Sat Oct 10 08:43:46 2009

alter database mount exclusive

PMON started with pid=2, OS id=2368

MMNL started with pid=13, OS id=2412

PSP0 started with pid=3, OS id=2372

Setting recovery target incarnation to 2

Sat Oct 10 08:43:50 2009

Successful mount of redo thread 1, with mount id 4222118594

Sat Oct 10 08:43:50 2009

Database mounted in Exclusive Mode

Completed: alter database mount exclusive

Sat Oct 10 08:43:50 2009

alter database open

Sat Oct 10 08:43:50 2009

Beginning crash recovery of 1 threads

parallel recovery started with 11 processes

Sat Oct 10 08:43:51 2009

Started redo scan

Sat Oct 10 08:43:51 2009

Completed redo scan

279 redo blocks read, 54 data blocks need recovery

Sat Oct 10 08:43:51 2009

Started redo application at

Thread 1: logseq 202, block 17888

Sat Oct 10 08:43:51 2009

Recovery of Online Redo Log: Thread 1 Group 3 Seq 202 Reading mem 0

Mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\REDO03.LOG

Sat Oct 10 08:43:51 2009

Completed redo application

Sat Oct 10 08:43:51 2009

Completed crash recovery at

Thread 1: logseq 202, block 18167, scn 5633115

54 data blocks read, 54 data blocks written, 279 redo blocks read

Sat Oct 10 08:43:51 2009

LGWR: STARTING ARCH PROCESSES

ARC0 started with pid=27, OS id=2484

Sat Oct 10 08:43:51 2009

ARC0: Archival started

ARC1 started with pid=28, OS id=2488

Sat Oct 10 08:43:51 2009

ARC1: Archival started

LGWR: STARTING ARCH PROCESSES COMPLETE

Thread 1 advanced to log sequence 203

Thread 1 opened at log sequence 203

Current log# 1 seq# 203 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\REDO01.LOG

Successful open of redo thread 1

Sat Oct 10 08:43:51 2009

ARC1: Becoming the 'no FAL' ARCH

ARC1: Becoming the 'no SRL' ARCH

Sat Oct 10 08:43:51 2009

ARC0: Becoming the heartbeat ARCH

Sat Oct 10 08:43:51 2009

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Sat Oct 10 08:43:51 2009

SMON: enabling cache recovery

Sat Oct 10 08:43:53 2009

Successfully onlined Undo Tablespace 1.

Sat Oct 10 08:43:53 2009

SMON: enabling tx recovery

Sat Oct 10 08:43:53 2009

Database Characterset is ZHS16GBK

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process QMNC

QMNC started with pid=29, OS id=2508

Sat Oct 10 08:43:56 2009

db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a

user-specified limit on the amount of space that will be used by this

database for recovery-related files, and does not reflect the amount of

space available in the underlying filesystem or ASM diskgroup.

Sat Oct 10 08:43:57 2009

Completed: alter database open

Dump file d:\oracle\product\10.2.0\admin\dbserver\bdump\alert_dbserver.log

Sat Oct 10 08:58:36 2009

ORACLE V10.2.0.3.0 - Production vsnsta=0

vsnsql=14 vsnxtr=3

Windows NT Version V6.0 Service Pack 1

CPU                 : 12 - type 586, 12 Physical Cores

Process Affinity    : 0x00000000

Memory (Avail/Total): Ph:3651M/4093M, Ph+PgF:8034M/8357M, VA:1926M/2047M

Sat Oct 10 08:58:36 2009

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 2

Autotune of undo retention is turned on.

IMODE=BR

ILAT =61

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.3.0.

System parameters with non-default values:

processes                = 500

sessions                 = 555

__shared_pool_size       = 322961408

__large_pool_size        = 4194304

__java_pool_size         = 8388608

__streams_pool_size      = 0

nls_language             = SIMPLIFIED CHINESE

nls_territory            = CHINA

sga_target               = 1073741824

control_files            = D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\CONTROL03.CTL

db_block_size            = 8192

__db_cache_size          = 729808896

compatible               = 10.2.0.3.0

log_archive_dest_1       = LOCATION=E:\Oracle_Backup\Archive

log_archive_format       = ARC%S_%R.%T

db_file_multiblock_read_count= 8

db_recovery_file_dest    = D:\oracle\product\10.2.0\flash_recovery_area

db_recovery_file_dest_size= 2147483648

undo_management          = AUTO

undo_tablespace          = UNDOTBS1

remote_login_passwordfile= EXCLUSIVE

db_domain                =

dispatchers              = (PROTOCOL=TCP) (SERVICE=dbserverXDB)

job_queue_processes      = 10

audit_file_dest          = D:\ORACLE\PRODUCT\10.2.0\ADMIN\DBSERVER\ADUMP

background_dump_dest     = D:\ORACLE\PRODUCT\10.2.0\ADMIN\DBSERVER\BDUMP

user_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\ADMIN\DBSERVER\UDUMP

core_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\ADMIN\DBSERVER\CDUMP

db_name                  = dbserver

open_cursors             = 300

pga_aggregate_target     = 524288000

PMON started with pid=2, OS id=2384

MMAN started with pid=4, OS id=2392

DBW0 started with pid=5, OS id=2396

DBW1 started with pid=6, OS id=2400

LGWR started with pid=7, OS id=2404

CKPT started with pid=8, OS id=2408

SMON started with pid=9, OS id=2412

RECO started with pid=10, OS id=2416

CJQ0 started with pid=11, OS id=2420

MMON started with pid=12, OS id=2424

Sat Oct 10 08:58:39 2009

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

MMNL started with pid=13, OS id=2428

Sat Oct 10 08:58:39 2009

starting up 1 shared server(s) ...

Sat Oct 10 08:58:40 2009

alter database mount exclusive

PSP0 started with pid=3, OS id=2388

Sat Oct 10 08:58:44 2009

Setting recovery target incarnation to 2

Sat Oct 10 08:58:44 2009

Successful mount of redo thread 1, with mount id 4222104384

Sat Oct 10 08:58:44 2009

Database mounted in Exclusive Mode

Completed: alter database mount exclusive

Sat Oct 10 08:58:44 2009

alter database open

Sat Oct 10 08:58:44 2009

Beginning crash recovery of 1 threads

parallel recovery started with 11 processes

Sat Oct 10 08:58:44 2009

Started redo scan

Sat Oct 10 08:58:44 2009

Completed redo scan

54296 redo blocks read, 3432 data blocks need recovery

Sat Oct 10 08:58:46 2009

Started redo application at

Thread 1: logseq 203, block 3

Sat Oct 10 08:58:46 2009

Recovery of Online Redo Log: Thread 1 Group 1 Seq 203 Reading mem 0

Mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\REDO01.LOG

Sat Oct 10 08:58:47 2009

Completed redo application

Sat Oct 10 08:58:47 2009

Completed crash recovery at

Thread 1: logseq 203, block 54299, scn 5660543

3432 data blocks read, 3432 data blocks written, 54296 redo blocks read

Sat Oct 10 08:58:48 2009

LGWR: STARTING ARCH PROCESSES

ARC0 started with pid=29, OS id=2700

Sat Oct 10 08:58:48 2009

ARC0: Archival started

Sat Oct 10 08:58:48 2009

ARC1: Archival started

LGWR: STARTING ARCH PROCESSES COMPLETE

Thread 1 advanced to log sequence 204

Thread 1 opened at log sequence 204

Current log# 2 seq# 204 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\REDO02.LOG