Re: CONFESSION TIME. -- large file on NT

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
>
> ******************************************
>
>
Received on Fri Mar 08 2002 - 09:36:51 CST