Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: alter tablespace ... end backup.... OR not?
> > > So yes, it's expected behaviour.
> > >
> >
> > Hm, well, I would think you've just demonstrated that we share the same
> > experience with this behaviour. A discussion about it's expectedness (a
> nice
> > discussion on Christmas Eve when many people celebrate the birth of the
> > expected one) is perhaps a bit too much for this time of the day.
> >
> >
> Hi Peter,
>
> I don't have much time so I'll be quick.
>
> When you place a data file in backup mode, you lock to the header to that
> particular time (so Oracle knows from when to apply redo).
>
> When you recover a file, you re-sync the header such that it is consistent
> to the time of the redo logs you apply.
>
> Therefore, for this process to occur you must "unlock" the file header.
> Therefore if you unlock the file header, Oracle must take the file out of
> backup mode.
>
> Hence it is expected behaviour although as I said, it would be nicer if
> Oracle were more clear with all this with the messages it produces.
>
> Hope this makes sense.
>
> Have a *great* day !!
>
> Richard
>
Richard, you convinced me, and I suppose I should have known this. Thanks again.
Peter Received on Fri Dec 27 2002 - 08:28:06 CST