Re: how to determined the recover start point when oracle crash

On Nov 13, 12:16 am, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
> On Nov 11, 9:59 pm, moumouyu <moumo..._at_gmail.com> wrote:
>
> >  Sometimes ,if oracle crash(mediea or instance level) ,we must
> > implement some recover .
> > As  every one knows ,there are vary SCN in oracle,just like start scn,
> > stop scn ,block scn etc...
> > How oracle determined which SCN is the recover start scn?and witch is
> > finall scn?
> > anybody know oracle recover iternal?? and who can exposed the  secret
> > which in recvoer internal?
>
> >  thanks !!
>
> During normal operation Oracle records the highest SCN number written
> to the data file(s) in the control file and the data file header
> block.  On startup Oracle compares the control file SCN to the data
> file SCN and responds accordingly.
>
> The control file contains information of SCN numbers written to the
> archived redo logs.  Oracle uses this to determine which archived redo
> log to start recovery with.
>
> HTH -- Mark D Powell --

thanks for your reply

   regards! Received on Wed Nov 12 2008 - 19:22:44 CST