Re: CONFESSION TIME. -- large file on NT

Thanks. This looks a lot more likely to hit people than the 2gb limit that used to exist.

Shame the Oracle TAR was resolved with no reference to this bug.

anyway we live and learn. (and hopefully keep our jobs at the same time. )

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"Hemant K Chitale" <hkchital_nospam_at_singnet_nospam.com.sg> wrote in message
news:a6alpm$4b$1_at_violet.singnet.com.sg...


>

> Niall,

>

> See Bug # 1668488 on NT

>   --- issue is with AutoExtend OR Resize when

> the size is at the 4GB boundary.  Workaround :

> specify 1MB more or less than 4GB.

>

> Never use boundary sizes.

> Even with 64-bit Oracle I set the maxsize

> of datafiles to 1900M or 2000M but not 2048M.

>

> My flames ?

> 1.  Yes, use AutoExtend but ALWAYS hard-code

> the Maxsize (1900M or 2000M)

> 2.  OEM .  blah !  svrmgrl or sqlplus.  Great scripting

> language.

> 3.  NT.  Not worth talking about.

>

> Hemant K Chitale

>

>

> Remove the "_nospam" in my email-id and

> domain-name when replying by email.

>

> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message

> news:3c879eee$0$232$ed9e5944_at_reading.news.pipex.net...

> > Ooops

> >

> > Database is busy filling up disk because tablespace is set to

auto-extend.


> > DBA therefore decides as the largest tablespace is 11gig and only

actually


> > contains 400mb of data (because third party app drops and recreates

> > temporary tables in permanent tablespace!). As he happens to have oem

open


> > resizes the datafile using the handy dandy GUI.

> >

> > Alert log follows

> >

> > Thu Mar 07 15:39:37 2002

> > /* OracleOEM */ ALTER DATABASE DATAFILE 'F:\ORACLE\AGR\AGR_AGRTEMP.DBF'

> > RESIZE  4096M

> > Thu Mar 07 15:39:38 2002

> > Completed: /* OracleOEM */ ALTER DATABASE DATAFILE 'F:\ORACLE

> > Thu Mar 07 15:39:39 2002

> > Errors in file g:\oracle\admin\agr\udump\ORA00630.TRC:

> > ORA-01115: IO error reading block from file 7 (block # 49930)

> > ORA-01110: data file 7: 'F:\ORACLE\AGR\AGR_AGRTEMP.DBF'

> > ORA-27091: skgfqio: unable to queue I/O

> > OSD-04026: Invalid parameter passed. (OS 49929)

> >  etc etc.

> >

> >

> >

> > So now we are recovering. My question is - my understanding was that

> 'ALTER

> > DATABASE DATAFILE BLAH RESIZE <SOME SIZE> would fail if there was data

in


> > the file beyond the requested resize. I am unclear as to why oracle has

> lost

> > its grip on the datafile size. any clues.

> >

> > Flames along the lines of

> >

> > 1. don't use autoextend

> > 2. don't use oem and

> > 3. don't use NT use a man's operating system are gratefully received

> >

> > Windows NT4 sp6a

> > 8.1.6.1 SE database.

> > OEM 2.2

> >

> >

> >

> >

> > --

> > Niall Litchfield

> > Oracle DBA

> > Audit Commission UK

> > *****************************************

> > Please include version and platform

> > and SQL where applicable

> > It makes life easier and increases the

> > likelihood of a good answer

> >

> > ******************************************

> >

> >

>

>