| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Data Warehouse on Windows
It is a problem with Oracle DataFiles on the 4GB boundary.
Doc ID: Note:148894.1
Subject:
ALERT: Problems with Datafile
AUTOEXTEND/RESIZE on Oracle8i on
NT/2000 Platforms
Type: ALERT
Status: PUBLISHED
Problems with Datafile AUTOEXTEND/RESIZE on Oracle8i on NT/2000 Platforms
Change Record
Versions Affected
Platforms Affected
Description
When a datafile has been configured such that it will autoextend onto a 4GB boundary, any attempt to autoextend:
When not in archive log mode, it is safe to restart the database and continue, altering datafiles to autoextend onto different boundaries asap. NOTE: It may be necessary to stop and restart the OracleService itself.
The only way to recover this file when in archive log mode is to restore the whole database and roll forward to a point before the file autoextended.
Likelihood of Occurrence
Possible Symptoms
KCF: write/open error block=0xXXXXX online=Y
file=N '......'
error=27069 txt: 'OSD-4026: Invalid parameter passed. (OS-204802)'
b. The file is marked offline in V$RECOVER_FILE and access to the database
continues. The following error appears in the alert.log:
KCF: write/open error block=0xXXXXX online=Y
file=N '......'
error=27069 txt: 'OSD-4026: Invalid parameter passed. (OS-204802)'
Automatic datafile offline due to write error on file N: '......'
Workaround
created to autoextend onto a 4Gb boundary. This is best achieved by making sure all datafiles have AUTOEXTEND disabled.
It is advisable to read the article below which describes potential issues using files of 2Gb or larger in size as this may influence the maximum datafile size you choose to use.
Patches
References
2Gb or not 2Gb - File limits in Oracle [NOTE:62427.1]
Base bug reporting this problem [BUG:1668488]
At 09:53 AM 15-08-02 -0800, you wrote:
>Was that corruption problem in Oracle or in the windows OS? > >I asked a Microsoft person here and he says that the file size limit for >windows2000 is in exabytes. (2^64 bytes) > >Regards, >Patrice Boivin >Systems Analyst (Oracle Certified DBA) > >Systems Admin & Operations | Admin. et Exploit. des systèmes >Technology Services | Services technologiques >Informatics Branch | Direction de l'informatique >Maritimes Region, DFO | Région des Maritimes, MPO > >E-Mail: boivinp_at_mar.dfo-mpo.gc.ca > > > -----Original Message----- >Sent: Thursday, August 15, 2002 11:44 AM >To: Multiple recipients of list ORACLE-L >Subject: RE: Data Warehouse on Windows > >Don't forget the Oracle/Windows 4GB boundary corruption problem! > >Lewis Bishop >--- >Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant >Phone - 020 8298 3418 >Mobile - 07950 380857 >Email - lewis.bishop_at_woolwich.co.uk > > >-----Original Message----- >Sent: 15 August 2002 14:58 >To: Multiple recipients of list ORACLE-L > >This header confirms that this email message has been swept for the >presence of computer viruses. > >Corporate IT >THE WOOLWICH >---------------------------------------------------------------------- > >Hi, >I was asked to give some hint for the hardware for a data warheouse running >on Win 2k and holding about 20-40 GB data. >Project will have about 40 small and 7-8 large tables. Users <20. Probably >long running queries. >Which hardware would you use? How many processors? Which disks? >The os-system is set and cannot be Unix/Linux according to management >decision. >Any tips/recommendations appreciated >Antje Sackwitz > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Sackwitz, Antje > INET: Antje.Sackwitz_at_ppi.de > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists >-------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > > >The information, attachments and opinions contained in this message are >those of its author only and do not necessarily represent those of The >Woolwich and or any other members of the Barclays Group and are intended >solely for the use of the individual or entity to whom they are addressed. >The sender may not be authorised to give financial advice, and nothing in >this message should be construed as offering such advice. > >The message may contain privileged and confidential information and you may >not copy, distribute or take any action in reliance on it. If you have >received this email in error please notify the Information Security Manager >at ADMINISTRATOR_at_WOOLWICH.CO.UK > >Replies to this email may be monitored for operational or business reasons. > >Woolwich plc. Registered in England Number : 3295699. > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Bishop Lewis > INET: Lewis.Bishop_at_woolwich.co.uk > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists >-------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Boivin, Patrice J > INET: BoivinP_at_mar.dfo-mpo.gc.ca > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists >-------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing).
Hemant K Chitale
Now using Eudora Email. Try it !
My home page is : http://hkchital.tripod.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: hkchital_at_singnet.com.sg Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Aug 16 2002 - 10:28:32 CDT
 |
 |