Re: extent on W2K caused datafile to go offline

On Thu, 25 Sep 2003 15:08:54 -0700, Michael Rothwell <marothwellRemoveThis_at_yahoo.com> wrote:

>I was called this am to look at a db that I dont normally deal with. A
>datafile had extended to 4G from 3G last night, and now the datafile is
>offline(recovery needed). Tried to recover, got an error that said call
>support. Called support, they tell me that it is a bug on W2K systems,
>and that it is ok if it extends to at least 1G more than the 4G mark.
>This database had just been put into archivelog mode and no backup had
>been made yet. I do have a copy of the datafile before it extended, is
>there any way to get it back up to the point that the copy was made?
>Unfortunately, I do not have a copy of the other datafile in that
>tablespace.
>
>Any help would be appreciated.

 The 4Gb boundary bug in early versions of 9.0 and 9.2 is particularly horrible. Can't offer any help on this point, though.

>Oracle v 9.2.0.1

 Go to 9.2.0.4 immediately. The number of bugs fixed since 9.2.0.1 is enormous; in particular many critical security issues.

--
Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)