Re: alter tablespace ... end backup.... OR not?

"Peter van Rijn" <pgm.van.rijnRM_at_THIShccnet.nl> wrote in message news:auaem7$ar$1_at_news.hccnet.nl...
>
> > SQL> shutdown abort;
> > ORACLE instance shut down.
> > SQL> startup
> > ORACLE instance started.
> >
> > Total System Global Area 51452388 bytes
> > Fixed Size 453092 bytes
> > Variable Size 33554432 bytes
> > Database Buffers 16777216 bytes
> > Redo Buffers 667648 bytes
> > Database mounted.
> > ORA-01113: file 14 needs media recovery
> > ORA-01110: data file 14: 'C:\BOWIE\FRED01.DBF'
> >
> >
> > SQL> recover datafile 14;
> > Media recovery complete.
> > SQL> alter database open;
> >
> > Database altered.
> >
> > SQL> select * from v$backup where file# = 14;
> >
> > FILE# STATUS CHANGE# TIME
> > ---------- ------------------ ---------- ---------
> > 14 NOT ACTIVE 20711628 24/DEC/02
> >
> > 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.
>
> I suppose your children will be sleeping in happy expectation (again!) of
> the new day. What exactly will Santa bring them?
>
> Have a nice time, and thanks for your reply.
>
> Peter
>

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 Received on Tue Dec 24 2002 - 18:53:16 CST