Oracle DB数据异常关闭的情况

yunvn

Beginning crash recovery of 1 threads　　
parallel recovery started with 7 processes
　　
Started redo scan
　　
Completed redo scan
　　
read 31 KB redo, 26 data blocks need recovery
　　
Started redo application at
　　
Thread 1: logseq 141, block 4690
　　
Recovery of Online Redo Log: Thread 1 Group 3 Seq 141 Reading mem 0
　　
  Mem# 0: /DBBK/oracle/oradata/orcl/redo03.log
　　
Recovery of Online Redo Log: Thread 1 Group 1 Seq 142 Reading mem 0
　　
  Mem# 0: /DBBK/oracle/oradata/orcl/redo01.log
　　
Completed redo application of 0.01MB
　　
Completed crash recovery at
　　
Thread 1: logseq 142, block 2, scn 2582016
　　
26 data blocks read, 26 data blocks written, 31 redo k-bytes read
　　
-- 此处结束Cache Recovery 从Redo日志中扫描到缺失的数据块进行恢复
　　

　　
Mon Jan 12 17:53:18 2015
　　
LGWR: STARTING ARCH PROCESSES
　　
Mon Jan 12 17:53:18 2015
　　
ARC0 started with pid=27, OS id=32295
　　
ARC0: Archival started
　　
LGWR: STARTING ARCH PROCESSES COMPLETE
　　
ARC0: STARTING ARCH PROCESSES
　　
Thread 1 advanced to log sequence 143 (thread open)
　　
Mon Jan 12 17:53:19 2015
　　
ARC1 started with pid=28, OS id=32297
　　
Mon Jan 12 17:53:19 2015
　　
ARC2 started with pid=29, OS id=32299
　　
Thread 1 opened at log sequence 143
　　
  Current log# 2 seq# 143 mem# 0: /DBBK/oracle/oradata/orcl/redo02.log
　　
Successful open of redo thread 1
　　
ARC1: Archival started
　　
Mon Jan 12 17:53:19 2015
　　
ARC3 started with pid=30, OS id=32301
　　
ARC2: Archival started
　　
ARC2: Becoming the 'no FAL' ARCH
　　
ARC2: Becoming the 'no SRL' ARCH
　　
ARC1: Becoming the heartbeat ARCH
　　
Mon Jan 12 17:53:19 2015
　　
SMON: enabling cache recovery
　　
Archived Log entry 85 added for thread 1 sequence 142 ID 0x531a7e3e dest 1:
　　
Successfully onlined Undo Tablespace 2.
　　
Verifying file header compatibility for 11g tablespace encryption..
　　
Verifying 11g file header compatibility for tablespace encryption completed
　　
-- 此处提示开始Transaction Recovery 数据库回滚未提交的事务。
　　
SMON: enabling tx recovery
　　
Database Characterset is WE8MSWIN1252
　　
No Resource Manager plan active
　　
replication_dependency_tracking turned off (no async multimaster replication found)
　　
Starting background process QMNC
　　
Mon Jan 12 17:53:20 2015
　　
QMNC started with pid=31, OS id=32305
　　
Completed: alter database open
　　
ARC3: Archival started
　　
ARC0: STARTING ARCH PROCESSES COMPLETE
　　
Mon Jan 12 17:53:22 2015
　　
Starting background process CJQ0
　　
Mon Jan 12 17:53:22 2015
　　
CJQ0 started with pid=32, OS id=32322
　　
Mon Jan 12 18:03:20 2015
　　
Starting background process SMCO
　　
Mon Jan 12 18:03:20 2015
　　
SMCO started with pid=19, OS id=852
　　
Mon Jan 12 22:00:00 2015
　　
Setting Resource Manager plan SCHEDULER[0x3003]:DEFAULT_MAINTENANCE_PLAN via scheduler window
　　
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
　　
Mon Jan 12 22:00:00 2015
　　
Starting background process VKRM
　　
Mon Jan 12 22:00:00 2015
　　
VKRM started with pid=24, OS id=21736
　　
Mon Jan 12 22:00:02 2015
　　
Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"
　　
End automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"