一次数据库异常down库后的recover

Wed Nov 17 10:08:18 2010
ALTER DATABASE   MOUNT
Wed Nov 17 10:08:28 2010
Successful mount of redo thread 1, with mount id 1115608210
Wed Nov 17 10:08:28 2010
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Wed Nov 17 10:08:28 2010
ALTER DATABASE OPEN
Wed Nov 17 10:09:38 2010
Beginning crash recovery of 1 threads
Wed Nov 17 10:09:39 2010
Started redo scan
Wed Nov 17 10:09:49 2010
Completed redo scan
 36155 redo blocks read, 3171 data blocks need recovery
Wed Nov 17 10:11:24 2010
Started recovery at
 Thread 1: logseq 209, block 8, scn 0.0
Wed Nov 17 10:11:24 2010
Recovery of Online Redo Log: Thread 1 Group 10 Seq 209 Reading mem 0
  Mem# 0 errs 0: /paic/z4ch2010/stg/of/oradata/fmsstg2/redo10.log
Wed Nov 17 10:11:33 2010
Recovery of Online Redo Log: Thread 1 Group 11 Seq 210 Reading mem 0
  Mem# 0 errs 0: /paic/z4ch2010/stg/of/oradata/fmsstg2/redo11.log
Wed Nov 17 10:11:34 2010
Completed redo application
Wed Nov 17 10:12:30 2010
Ended recovery at
 Thread 1: logseq 210, block 2125, scn 1967.3170501735
 3171 data blocks read, 3171 data blocks written, 36155 redo blocks read
Wed Nov 17 10:12:58 2010
Crash recovery completed successfully
Wed Nov 17 10:13:08 2010
Thread 1 advanced to log sequence 211
Wed Nov 17 10:13:35 2010
Thread 1 opened at log sequence 211
  Current log# 12 seq# 211 mem# 0: /paic/z4ch2010/stg/of/oradata/fmsstg2/redo12.log
Successful open of redo thread 1
Wed Nov 17 10:13:35 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Nov 17 10:13:35 2010
SMON: enabling cache recovery
Wed Nov 17 10:13:56 2010
Successfully onlined Undo Tablespace 374.
Wed Nov 17 10:13:56 2010
SMON: enabling tx recovery
Wed Nov 17 10:13:56 2010
Database Characterset is ZHS16GBK
Wed Nov 17 10:13:57 2010
SMON: about to recover undo segment 15
SMON: mark undo segment 15 as available
SMON: Parallel transaction recovery tried
Wed Nov 17 10:17:00 2010
replication_dependency_tracking turned off (no async multimaster replication found)
Wed Nov 17 10:17:27 2010
Completed: ALTER DATABASE OPEN

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15779287/viewspace-678298/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15779287/viewspace-678298/