Crash recovery after shutdown immediate?
Date: Tue, 9 Dec 2008 01:05:47 -0800 (PST)
Message-ID: <2286aa40-c154-40e0-b8cd-f8ca579ba3aa@a12g2000pro.googlegroups.com>
Hello *,
Odd problem i had after i had shut down the database (immediate) and made a media copy. After restoring and opening with resetlogs, the database stated it wanted a recovery. After i did a recover until cancel, and cancelled immediately on first occasion, the database started.
I ignored this incident, but now i am curious about this entry in the logfile. Yesterday, i did again a shutdown immediate ( i never do abort) , made a copy of the database and restarted the database. In the errorlog, it seems that a crash recovery occured. This shoudn't happen? What am i missing?
ALTER DATABASE OPEN
Mon Dec 8 18:03:40 2008
Beginning crash recovery of 1 threads
Mon Dec 8 18:03:40 2008
Started redo scan
Mon Dec 8 18:03:40 2008
Completed redo scan
156 redo blocks read, 66 data blocks need recovery
Mon Dec 8 18:03:40 2008
Started recovery at
Thread 1: logseq 58, block 16913, scn 0.0
Mon Dec 8 18:03:40 2008
Recovery of Online Redo Log: Thread 1 Group 3 Seq 58 Reading mem 0
Mem# 0 errs 0: /oracle/log_a/xxx/log3A.log
Mem# 1 errs 0: /oracle/log_b/xxx/log3B.log
Mon Dec 8 18:03:40 2008
Completed redo application
Mon Dec 8 18:03:41 2008
Ended recovery at
Thread 1: logseq 58, block 17069, scn 0.4242238601
66 data blocks read, 66 data blocks written, 156 redo blocks read
Crash recovery completed successfully
Received on Tue Dec 09 2008 - 03:05:47 CST