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

> 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 Received on Tue Dec 24 2002 - 14:01:51 CST