Re: how to determined the recover start point when oracle crash
Date: Wed, 12 Nov 2008 17:22:44 -0800 (PST)
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