Oracle Database Discussions

Hi all,
Now, I have a trouble in my oracle database, Oracle 10.2.0.4 On Windows server2003 SP1, The oracle service was stopped unexpectedly.
Following is alert log.

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 = 150
__shared_pool_size = 1325400064
__large_pool_size = 16777216
__java_pool_size = 67108864
__streams_pool_size = 0
nls_length_semantics = BYTE
resource_manager_plan =

sga_target = 8589934592
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 7163871232
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
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
undo_retention = 900
recyclebin = OFF
remote_login_passwordfile= EXCLUSIVE
db_domain =

dispatchers = (PROTOCOL=TCP) (SERVICE=cworadbXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\CWORADB\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\CWORADB\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\CWORADB\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\CWORADB\CDUMP
db_name = cworadb
open_cursors = 1000
pga_aggregate_target = 1707081728
aq_tm_processes = 0
PMON started with pid=2, OS id=4168
PSP0 started with pid=3, OS id=2084
MMAN started with pid=4, OS id=4760
DBW0 started with pid=5, OS id=1664
DBW1 started with pid=6, OS id=4304
LGWR started with pid=7, OS id=4888
CKPT started with pid=8, OS id=3332
SMON started with pid=9, OS id=1472
RECO started with pid=10, OS id=4124
CJQ0 started with pid=11, OS id=3532
MMON started with pid=12, OS id=3892
Mon May 24 13:24:42 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=13, OS id=4188
Mon May 24 13:24:42 2010
starting up 1 shared server(s) ...
Mon May 24 13:24:42 2010
ALTER DATABASE MOUNT
Mon May 24 13:24:46 2010
Setting recovery target incarnation to 2
Mon May 24 13:24:46 2010
Successful mount of redo thread 1, with mount id 2969455770
Mon May 24 13:24:46 2010
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Mon May 24 13:24:46 2010
ALTER DATABASE OPEN
Mon May 24 13:24:46 2010
Thread 1 opened at log sequence 13521
Current log# 2 seq# 13521 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
Successful open of redo thread 1
Mon May 24 13:24:46 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon May 24 13:24:46 2010
SMON: enabling cache recovery
Mon May 24 13:24:47 2010
Successfully onlined Undo Tablespace 1.
Mon May 24 13:24:47 2010
SMON: enabling tx recovery
Mon May 24 13:24:47 2010
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 16
replication_dependency_tracking turned off (no async multimaster replication found)
WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected.
Mon May 24 13:24:50 2010
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.
Mon May 24 13:24:51 2010
Completed: ALTER DATABASE OPEN
Mon May 24 13:35:18 2010
Thread 1 advanced to log sequence 13522 (LGWR switch)
Current log# 3 seq# 13522 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO03.LOG
Mon May 24 13:36:39 2010
Thread 1 advanced to log sequence 13523 (LGWR switch)
Current log# 1 seq# 13523 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO01.LOG
Mon May 24 13:37:16 2010
Thread 1 cannot allocate new log, sequence 13524
Checkpoint not complete
Current log# 1 seq# 13523 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO01.LOG
Mon May 24 13:37:18 2010
Thread 1 advanced to log sequence 13524 (LGWR switch)
Current log# 2 seq# 13524 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
Mon May 24 13:37:56 2010
Thread 1 cannot allocate new log, sequence 13525
Checkpoint not complete
Current log# 2 seq# 13524 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
Mon May 24 13:37:57 2010
Thread 1 advanced to log sequence 13525 (LGWR switch)
Current log# 3 seq# 13525 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO03.LOG
Mon May 24 13:41:52 2010
Thread 1 cannot allocate new log, sequence 13526
Checkpoint not complete
Current log# 3 seq# 13525 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO03.LOG
Thread 1 cannot allocate new log, sequence 13526
Private strand flush not complete
Current log# 3 seq# 13525 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO03.LOG
Mon May 24 13:41:56 2010
Thread 1 advanced to log sequence 13526 (LGWR switch)
Current log# 1 seq# 13526 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO01.LOG
Mon May 24 13:57:16 2010
Thread 1 advanced to log sequence 13527 (LGWR switch)
Current log# 2 seq# 13527 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
Mon May 24 14:08:51 2010
Thread 1 advanced to log sequence 13528 (LGWR switch)
Current log# 3 seq# 13528 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO03.LOG
Mon May 24 14:16:26 2010
Thread 1 advanced to log sequence 13529 (LGWR switch)
Current log# 1 seq# 13529 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO01.LOG
Mon May 24 14:32:58 2010
Thread 1 advanced to log sequence 13530 (LGWR switch)
Current log# 2 seq# 13530 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
Mon May 24 14:47:15 2010
Thread 1 advanced to log sequence 13531 (LGWR switch)
Current log# 3 seq# 13531 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO03.LOG
Mon May 24 14:58:38 2010
Thread 1 advanced to log sequence 13532 (LGWR switch)
Current log# 1 seq# 13532 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO01.LOG
Mon May 24 15:11:41 2010
Thread 1 advanced to log sequence 13533 (LGWR switch)
Current log# 2 seq# 13533 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
Mon May 24 15:16:23 2010
Thread 1 advanced to log sequence 13534 (LGWR switch)
Current log# 3 seq# 13534 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO03.LOG
Mon May 24 15:20:33 2010
Thread 1 advanced to log sequence 13535 (LGWR switch)
Current log# 1 seq# 13535 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO01.LOG
Mon May 24 15:27:30 2010
Thread 1 advanced to log sequence 13536 (LGWR switch)
Current log# 2 seq# 13536 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
Mon May 24 15:36:30 2010
Thread 1 advanced to log sequence 13537 (LGWR switch)
Current log# 3 seq# 13537 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO03.LOG
Mon May 24 15:42:53 2010
Thread 1 advanced to log sequence 13538 (LGWR switch)
Current log# 1 seq# 13538 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO01.LOG
Mon May 24 15:45:52 2010
Thread 1 advanced to log sequence 13539 (LGWR switch)
Current log# 2 seq# 13539 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
Mon May 24 15:47:47 2010
Thread 1 cannot allocate new log, sequence 13540
Checkpoint not complete
Current log# 2 seq# 13539 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
Mon May 24 15:47:48 2010
Thread 1 advanced to log sequence 13540 (LGWR switch)
Current log# 3 seq# 13540 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO03.LOG
Mon May 24 15:53:57 2010
Thread 1 advanced to log sequence 13541 (LGWR switch)
Current log# 1 seq# 13541 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO01.LOG
Mon May 24 16:03:36 2010
Thread 1 advanced to log sequence 13542 (LGWR switch)
Current log# 2 seq# 13542 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
Mon May 24 16:12:36 2010
Thread 1 advanced to log sequence 13543 (LGWR switch)
Current log# 3 seq# 13543 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO03.LOG
Mon May 24 16:26:18 2010
Thread 1 advanced to log sequence 13544 (LGWR switch)
Current log# 1 seq# 13544 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO01.LOG
Mon May 24 16:38:18 2010
Thread 1 advanced to log sequence 13545 (LGWR switch)
Current log# 2 seq# 13545 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
Mon May 24 16:56:34 2010
Thread 1 advanced to log sequence 13546 (LGWR switch)
Current log# 3 seq# 13546 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO03.LOG
Mon May 24 17:10:33 2010
Thread 1 advanced to log sequence 13547 (LGWR switch)
Current log# 1 seq# 13547 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO01.LOG
Mon May 24 17:22:15 2010
Thread 1 advanced to log sequence 13548 (LGWR switch)
Current log# 2 seq# 13548 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
Mon May 24 17:35:55 2010
Thread 1 advanced to log sequence 13549 (LGWR switch)
Current log# 3 seq# 13549 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO03.LOG
Mon May 24 18:04:19 2010
Thread 1 advanced to log sequence 13550 (LGWR switch)
Current log# 1 seq# 13550 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO01.LOG
Mon May 24 18:28:28 2010
Thread 1 advanced to log sequence 13551 (LGWR switch)
Current log# 2 seq# 13551 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
Mon May 24 19:41:48 2010
Thread 1 advanced to log sequence 13552 (LGWR switch)
Current log# 3 seq# 13552 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO03.LOG
Mon May 24 22:00:15 2010
Thread 1 advanced to log sequence 13553 (LGWR switch)
Current log# 1 seq# 13553 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO01.LOG
Mon May 24 22:01:11 2010
Thread 1 advanced to log sequence 13554 (LGWR switch)
Current log# 2 seq# 13554 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
Mon May 24 22:03:12 2010
Thread 1 cannot allocate new log, sequence 13555
Checkpoint not complete
Current log# 2 seq# 13554 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
Mon May 24 22:03:12 2010
Thread 1 advanced to log sequence 13555 (LGWR switch)
Current log# 3 seq# 13555 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO03.LOG
Tue May 25 06:03:05 2010
Thread 1 advanced to log sequence 13556 (LGWR switch)
Current log# 1 seq# 13556 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO01.LOG
Tue May 25 07:25:51 2010
Thread 1 advanced to log sequence 13557 (LGWR switch)
Current log# 2 seq# 13557 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
Tue May 25 07:25:58 2010
Thread 1 advanced to log sequence 13558 (LGWR switch)
Current log# 3 seq# 13558 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO03.LOG
Tue May 25 07:59:00 2010
Thread 1 advanced to log sequence 13559 (LGWR switch)
Current log# 1 seq# 13559 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO01.LOG
Tue May 25 08:35:00 2010
Thread 1 advanced to log sequence 13560 (LGWR switch)
Current log# 2 seq# 13560 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
Tue May 25 08:54:05 2010
Thread 1 advanced to log sequence 13561 (LGWR switch)
Current log# 3 seq# 13561 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO03.LOG
Tue May 25 09:05:08 2010
Thread 1 advanced to log sequence 13562 (LGWR switch)
Current log# 1 seq# 13562 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO01.LOG
Tue May 25 09:18:21 2010
Thread 1 advanced to log sequence 13563 (LGWR switch)
Current log# 2 seq# 13563 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
Tue May 25 09:25:00 2010
Thread 1 advanced to log sequence 13564 (LGWR switch)
Current log# 3 seq# 13564 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO03.LOG
Tue May 25 09:31:10 2010
Thread 1 advanced to log sequence 13565 (LGWR switch)
Current log# 1 seq# 13565 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO01.LOG
Tue May 25 09:38:54 2010
Thread 1 advanced to log sequence 13566 (LGWR switch)
Current log# 2 seq# 13566 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
Tue May 25 09:39:34 2010
Thread 1 advanced to log sequence 13567 (LGWR switch)
Current log# 3 seq# 13567 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO03.LOG
Tue May 25 09:48:21 2010
Thread 1 advanced to log sequence 13568 (LGWR switch)
Current log# 1 seq# 13568 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO01.LOG
Tue May 25 09:55:42 2010
Thread 1 advanced to log sequence 13569 (LGWR switch)
Current log# 2 seq# 13569 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
Tue May 25 10:00:27 2010
Thread 1 advanced to log sequence 13570 (LGWR switch)
Current log# 3 seq# 13570 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO03.LOG
Tue May 25 10:06:05 2010
Thread 1 advanced to log sequence 13571 (LGWR switch)
Current log# 1 seq# 13571 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO01.LOG
Tue May 25 10:10:12 2010
Thread 1 advanced to log sequence 13572 (LGWR switch)
Current log# 2 seq# 13572 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
Tue May 25 10:13:09 2010
Thread 1 advanced to log sequence 13573 (LGWR switch)
Current log# 3 seq# 13573 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO03.LOG
Tue May 25 10:19:22 2010
Thread 1 advanced to log sequence 13574 (LGWR switch)
Current log# 1 seq# 13574 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO01.LOG
Tue May 25 10:24:32 2010
Thread 1 advanced to log sequence 13575 (LGWR switch)
Current log# 2 seq# 13575 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
Tue May 25 10:32:01 2010
Thread 1 advanced to log sequence 13576 (LGWR switch)
Current log# 3 seq# 13576 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO03.LOG
Tue May 25 10:46:40 2010
Thread 1 advanced to log sequence 13577 (LGWR switch)
Current log# 1 seq# 13577 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO01.LOG
Tue May 25 10:53:20 2010
Thread 1 advanced to log sequence 13578 (LGWR switch)
Current log# 2 seq# 13578 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
Tue May 25 11:00:00 2010
Thread 1 advanced to log sequence 13579 (LGWR switch)
Current log# 3 seq# 13579 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO03.LOG
Tue May 25 11:06:21 2010
Thread 1 advanced to log sequence 13580 (LGWR switch)
Current log# 1 seq# 13580 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO01.LOG
Tue May 25 11:17:14 2010
Thread 1 advanced to log sequence 13581 (LGWR switch)
Current log# 2 seq# 13581 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
Tue May 25 11:24:37 2010
Thread 1 advanced to log sequence 13582 (LGWR switch)
Current log# 3 seq# 13582 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO03.LOG
Tue May 25 11:31:42 2010
Thread 1 advanced to log sequence 13583 (LGWR switch)
Current log# 1 seq# 13583 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO01.LOG
Tue May 25 11:32:48 2010
Thread 1 advanced to log sequence 13584 (LGWR switch)
Current log# 2 seq# 13584 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
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 = 150
__shared_pool_size = 3338665984
__large_pool_size = 16777216
__java_pool_size = 67108864
__streams_pool_size = 0
nls_length_semantics = BYTE
resource_manager_plan =

sga_target = 8589934592
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 5150605312
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
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
undo_retention = 900
recyclebin = OFF
remote_login_passwordfile= EXCLUSIVE
db_domain =

dispatchers = (PROTOCOL=TCP) (SERVICE=cworadbXDB)
job_queue_processes = 10
audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\CWORADB\ADUMP
background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\CWORADB\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\CWORADB\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\CWORADB\CDUMP
db_name = cworadb
open_cursors = 1000
pga_aggregate_target = 1707081728
aq_tm_processes = 0
PMON started with pid=2, OS id=2132
PSP0 started with pid=3, OS id=3760
MMAN started with pid=4, OS id=2168
DBW0 started with pid=5, OS id=5048
DBW1 started with pid=6, OS id=2088
LGWR started with pid=7, OS id=136
CKPT started with pid=8, OS id=1008
SMON started with pid=9, OS id=1792
RECO started with pid=10, OS id=1956
CJQ0 started with pid=11, OS id=4480
MMON started with pid=12, OS id=4612
Tue May 25 12:34:46 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=13, OS id=3904
Tue May 25 12:34:46 2010
starting up 1 shared server(s) ...
Tue May 25 12:34:46 2010
alter database mount exclusive
Tue May 25 12:34:50 2010
Setting recovery target incarnation to 2
Tue May 25 12:34:50 2010
Successful mount of redo thread 1, with mount id 2969631590
Tue May 25 12:34:50 2010
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Tue May 25 12:34:50 2010
alter database open
Tue May 25 12:34:50 2010
Beginning crash recovery of 1 threads
parallel recovery started with 15 processes
Tue May 25 12:34:50 2010
Started redo scan
Tue May 25 12:34:50 2010
Completed redo scan
*32647 redo blocks read, 1716 data blocks need recovery*
Tue May 25 12:34:51 2010
Started redo application at
Thread 1: logseq 13584, block 5911
Tue May 25 12:34:51 2010
Recovery of Online Redo Log: Thread 1 Group 2 Seq 13584 Reading mem 0
Mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO02.LOG
Tue May 25 12:34:51 2010
Completed redo application
Tue May 25 12:34:51 2010
Completed crash recovery at
Thread 1: logseq 13584, block 38558, scn 270322784
*1716 data blocks read, 1704 data blocks written, 32647 redo blocks read*
Tue May 25 12:34:51 2010
Thread 1 advanced to log sequence 13585 (thread open)
Thread 1 opened at log sequence 13585
Current log# 3 seq# 13585 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO03.LOG
Successful open of redo thread 1
Tue May 25 12:34:51 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue May 25 12:34:51 2010
SMON: enabling cache recovery
Tue May 25 12:34:52 2010
Successfully onlined Undo Tablespace 1.
Tue May 25 12:34:52 2010
SMON: enabling tx recovery
Tue May 25 12:34:52 2010
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 16
replication_dependency_tracking turned off (no async multimaster replication found)
WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected.
Tue May 25 12:34:57 2010
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.
Tue May 25 12:34:59 2010
Completed: alter database open
Tue May 25 13:08:49 2010
Thread 1 advanced to log sequence 13586 (LGWR switch)
Current log# 1 seq# 13586 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\CWORADB\REDO01.LOG


Thank you.

Eric China.