Re: Crash recovery after shutdown immediate?

On Dec 9, 11:54 am, gazzag <gar..._at_jamms.org> wrote:
> On 9 Dec, 09:05, Helma <helma.vi..._at_hotmail.com> wrote:
>
>
>
>
>
> > 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
>
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/backre...
>
> HTH
>
> -g- Hide quoted text -
>
> - Show quoted text -

Hi gazzag,

So you agree that my case is in conflict of what's in the manual?

" Crash and instance recovery have the following shared characteristics:
Redo the changes using the current online datafiles (as left on disk after the failure or SHUTDOWN ABORT) "

And again, i did a shutdown immediate. That is called a clean shutdown. No crash recovery needs to be done. So why the entries in the logfile? Received on Tue Dec 09 2008 - 05:26:03 CST