刚才又无故宕掉了谁帮忙看下log我看不太懂 Wed Mar 07 10:28:55 2012 Setting recovery target incarnation to 2 Wed Mar 07 10:28:55 2012 Successful mount of redo thread 1, with mount id 1305044450 Wed Mar 07 10:28:55 2012 Database mounted in Exclusive Mode. Completed: alter database mount exclusive Wed Mar 07 10:28:55 2012 alter database open Wed Mar 07 10:28:55 2012 Beginning crash recovery of 1 threads attempting to start a parallel recovery with 7 processes parallel recovery started with 7 processes Wed Mar 07 10:28:56 2012 Started first pass scan Wed Mar 07 10:28:56 2012 Completed first pass scan 5853 redo blocks read, 500 data blocks need recovery Wed Mar 07 10:28:56 2012 Started redo application at Thread 1: logseq 92225, block 16807, scn 0.0 Recovery of Online Redo Log: Thread 1 Group 1 Seq 92225 Reading mem 0 Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO01.LOG Recovery of Online Redo Log: Thread 1 Group 2 Seq 92226 Reading mem 0 Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO02.LOG Wed Mar 07 10:28:56 2012 Completed redo application Wed Mar 07 10:28:57 2012 Completed crash recovery at Thread 1: logseq 92226, block 5013, scn 0.218747061 500 data blocks read, 400 data blocks written, 5853 redo blocks read Wed Mar 07 10:28:58 2012 Thread 1 advanced to log sequence 92227 Maximum redo generation record size = 120832 bytes Maximum redo generation change vector size = 116476 bytes Private_strands 6 at log switch Thread 1 opened at log sequence 92227 Current log# 3 seq# 92227 mem# 0: D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO03.LOG Successful open of redo thread 1 Wed Mar 07 10:28:58 2012 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Wed Mar 07 10:28:58 2012 SMON: enabling cache recovery Wed Mar 07 10:28:59 2012 Successfully onlined Undo Tablespace 1. Wed Mar 07 10:28:59 2012 SMON: enabling tx recovery Wed Mar 07 10:28:59 2012 Database Characterset is ZHS16GBK Wed Mar 07 10:28:59 2012 Published database character set on system events channel Wed Mar 07 10:28:59 2012 All processes have switched to database character set Wed Mar 07 10:29:00 2012 Starting background process QMNC QMNC started with pid=29, OS id=2148 Wed Mar 07 10:29:01 2012 SMON: Parallel transaction recovery tried Wed Mar 07 10:29:02 2012 replication_dependency_tracking turned off (no async multimaster replication found) Wed Mar 07 10:29:03 2012 Starting background process MMON MMON started with pid=30, OS id=2152 Wed Mar 07 10:29:03 2012 Starting background process MMNL MMNL started with pid=31, OS id=2156 Wed Mar 07 10:29:04 2012 Completed: alter database open
Wed Mar 07 10:28:55 2012
Setting recovery target incarnation to 2
Wed Mar 07 10:28:55 2012
Successful mount of redo thread 1, with mount id 1305044450
Wed Mar 07 10:28:55 2012
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed Mar 07 10:28:55 2012
alter database open
Wed Mar 07 10:28:55 2012
Beginning crash recovery of 1 threads
attempting to start a parallel recovery with 7 processes
parallel recovery started with 7 processes
Wed Mar 07 10:28:56 2012
Started first pass scan
Wed Mar 07 10:28:56 2012
Completed first pass scan
5853 redo blocks read, 500 data blocks need recovery
Wed Mar 07 10:28:56 2012
Started redo application at
Thread 1: logseq 92225, block 16807, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 1 Seq 92225 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO01.LOG
Recovery of Online Redo Log: Thread 1 Group 2 Seq 92226 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO02.LOG
Wed Mar 07 10:28:56 2012
Completed redo application
Wed Mar 07 10:28:57 2012
Completed crash recovery at
Thread 1: logseq 92226, block 5013, scn 0.218747061
500 data blocks read, 400 data blocks written, 5853 redo blocks read
Wed Mar 07 10:28:58 2012
Thread 1 advanced to log sequence 92227
Maximum redo generation record size = 120832 bytes
Maximum redo generation change vector size = 116476 bytes
Private_strands 6 at log switch
Thread 1 opened at log sequence 92227
Current log# 3 seq# 92227 mem# 0: D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO03.LOG
Successful open of redo thread 1
Wed Mar 07 10:28:58 2012
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Mar 07 10:28:58 2012
SMON: enabling cache recovery
Wed Mar 07 10:28:59 2012
Successfully onlined Undo Tablespace 1.
Wed Mar 07 10:28:59 2012
SMON: enabling tx recovery
Wed Mar 07 10:28:59 2012
Database Characterset is ZHS16GBK
Wed Mar 07 10:28:59 2012
Published database character set on system events channel
Wed Mar 07 10:28:59 2012
All processes have switched to database character set
Wed Mar 07 10:29:00 2012
Starting background process QMNC
QMNC started with pid=29, OS id=2148
Wed Mar 07 10:29:01 2012
SMON: Parallel transaction recovery tried
Wed Mar 07 10:29:02 2012
replication_dependency_tracking turned off (no async multimaster replication found)
Wed Mar 07 10:29:03 2012
Starting background process MMON
MMON started with pid=30, OS id=2152
Wed Mar 07 10:29:03 2012
Starting background process MMNL
MMNL started with pid=31, OS id=2156
Wed Mar 07 10:29:04 2012
Completed: alter database open