Beginning crash recovery" message appear in my log ,when immediate shut
694332Apr 27 2009 — edited Apr 27 2009Dears,
my database took 5hours to shutdown immediate after abort shut .i found this message in my log file "*Beginning crash recovery *"
and then "SMON: about to recover undo segment 12" appears 1000 times in the log, the undo TS is 12 G
Q:is my database in dangerous situation, if so what i have to do?
here is the log file:==>
Beginning crash recovery of 1 threads
Mon Apr 27 00:16:21 2009
Started first pass scan
Mon Apr 27 00:16:23 2009
Completed first pass scan
102137 redo blocks read, 8405 data blocks need recovery
Mon Apr 27 00:16:28 2009
Started recovery at
Thread 1: logseq 192302, block 115866, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 3 Seq 192302 Reading mem 0
Mem# 0 errs 0: /home02/oraprod/proddata/log3.dbf
Mem# 1 errs 0: /home02/oraprod/proddata/log3_2.dbf
Recovery of Online Redo Log: Thread 1 Group 1 Seq 192303 Reading mem 0
Mem# 0 errs 0: /home02/oraprod/proddata/log1.dbf
Mem# 1 errs 0: /home02/oraprod/proddata/log1_2.dbf
Mon Apr 27 00:16:35 2009
Completed redo application
Mon Apr 27 00:16:45 2009
Ended recovery at
Thread 1: logseq 192303, block 13206, scn 27.2349897339
8405 data blocks read, 8232 data blocks written, 102137 redo blocks read
Crash recovery completed successfully
Mon Apr 27 00:16:49 2009
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 192304
Thread 1 opened at log sequence 192304
Current log# 2 seq# 192304 mem# 0: /home02/oraprod/proddata/log2.dbf
Current log# 2 seq# 192304 mem# 1: /home02/oraprod/proddata/log2_2.dbf
Successful open of redo thread 1.
Mon Apr 27 00:16:52 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Apr 27 00:16:52 2009
SMON: enabling cache recovery
Mon Apr 27 00:16:52 2009
ARC0: Evaluating archive log 1 thread 1 sequence 192303
ARC0: Beginning to archive log 1 thread 1 sequence 192303
Creating archive destination LOG_ARCHIVE_DEST_1: '/arclog/PROD/arch_1_192303.arc'
ARC0: Completed archiving log 1 thread 1 sequence 192303
Mon Apr 27 00:16:56 2009
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 386.
Mon Apr 27 00:16:56 2009
SMON: enabling tx recovery
Mon Apr 27 00:16:56 2009
Database Characterset is AR8ISO8859P6
Mon Apr 27 00:16:56 2009
SMON: about to recover undo segment 12
SMON: mark undo segment 12 as available
SMON: about to recover undo segment 12
SMON: mark undo segment 12 as available
SMON: about to recover undo segment 12
SMON: mark undo segment 12 as available
SMON: about to recover undo segment 12
SMON: mark undo segment 12 as available
SMON: about to recover undo segment 12
SMON: mark undo segment 12 as available
SMON: about to recover undo segment 12
SMON: mark undo segment 12 as available
SMON: about to recover undo segment 12
SMON: mark undo segment 12 as available
SMON: about to recover undo segment 12
SMON: mark undo segment 12 as available
SMON: about to recover undo segment 12
SMON: mark undo segment 12 as available
SMON: about to recover undo segment 12
.
.
.
.
.