Re: ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB
Title: Message An update: We finished the creation of the database in the morning in time for business day. We found that the file system was performing at about 30-50% efficiency. On Sunday we moved the database to a new server and all is OK. Now we are starting to prepare new server so we can return to replication. Yechiel AdarMehish - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Thursday, October 10, 2002 11:53 PM Subject: Re: ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB Thanks for all the replies. We called Oracle support and they come with the DUL utility and extracted the data. As Iwrite this e-mail imports are running. Concurrently wetried to restore the last full backup from more then 2 weeks ago\ and found about 1 day worth of archive logs missing, so this option is out. We now also restoring last night export to a separate database so in case of logical errors in the imported data they will be able to input the deals again and bring the system up to date. So now, eleven hours later we hope to finish in a few hours. Yechiel AdarMehish
ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB
Title: Message Hello all HELP - and I am not an idiot. Oracle 8.1.6.3.4 on NT. We have a problem that the datafile for the application tables autoextended from 3.9 GB to 4.1 GB. We are getting ora-01115 errors and the datafile is offline. We tried export but it gets the same error. The status now is that the datafile is offline. Alter datafile online needsrecovery. Recovery gets I/O error and aborts. Anybody knows how to get the data out? As per Murphy's law, the last full backup of the database ran about 2 weeks ago and nobody noticed that the backup job ended ok but without backing up the files. So recovery means restoring from 2 weeks ago and applying archive logs for some hours. Oracle support are sending someone with a utility that MAY save the day. Any ideas ??? HELP Yechiel AdarMehish
RE: ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB
Title: Message Note # 148894.1 on Metalink has a possible solution... NT has a limit of 4GB for the file size :( - Kirti -Original Message-From: Yechiel Adar [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 10, 2002 10:08 AMTo: Multiple recipients of list ORACLE-LSubject: ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB Hello all HELP - and I am not an idiot. Oracle 8.1.6.3.4 on NT. We have a problem that the datafile for the application tables autoextended from 3.9 GB to 4.1 GB. We are getting ora-01115 errors and the datafile is offline. We tried export but it gets the same error. The status now is that the datafile is offline. Alter datafile online needsrecovery. Recovery gets I/O error and aborts. Anybody knows how to get the data out? As per Murphy's law, the last full backup of the database ran about 2 weeks ago and nobody noticed that the backup job ended ok but without backing up the files. So recovery means restoring from 2 weeks ago and applying archive logs for some hours. Oracle support are sending someone with a utility that MAY save the day. Any ideas ??? HELP Yechiel AdarMehish
RE: ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB
Title: Message Looks like your stuck... Maybe someone else can help... Good luck... Doc ID: Note:148894.1 Subject: ALERT: Problems with Datafile AUTOEXTEND/RESIZE on Oracle8i on NT/2000 Platforms Type: ALERT Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 07-JUN-2001 Last Revision Date: 25-JUL-2002Problems with Datafile AUTOEXTEND/RESIZE on Oracle8i on NT/2000 Platforms ~ Change Record ~~ 27-Dec-01: The fix release in the Patches section of this alert was modified from 8.1.7.2 to 8.1.7.3. Versions Affected ~ The problems described here can affect releases 8.1.6 and 8.1.7. Platforms Affected ~~ The problems affect Oracle8i releases on Windows NT and Windows 2000. Description ~~~ Releases of Oracle8i on Windows NT and Windows 2000 platforms can exhibitserious problems when a datafile autoextends or is resized onto a 4GBboundary (e.g. 4GB, 8GB).When a datafile has been configured such that it will autoextend onto a 4GB boundary, any attempt to autoextend: a. when in noarchive log mode it causes the database to crash b. when in archive log mode the file is marked offline in V$RECOVER_FILEWhen not in archive log mode, it is safe to restart the database andcontinue, 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 restorethe whole database and roll forward to a point before the file autoextended.Likelihood of Occurrence It is highly likely that problems will be encountered if an attempt is made to autoextend or resize a datafile onto a 4Gb boundary. Possible Symptoms ~ The possible symptoms from this problem are:a. The database crashes (when in noarchive log mode) and the alert fileand database writer (DBW0) trace file report: KCF: write/open error block=0xX online=Yfile=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 databasecontinues. The following error appears in the alert.log: KCF: write/open error block=0xX online=Yfile=N '..'error=27069 txt: 'OSD-4026: Invalid parameter passed. (OS-204802)' Automatic datafile offline due to write error on file N: '..' Workaround ~~ The only safe workaround at present is to ensure that no file is resized orcreated to autoextend onto a 4Gb boundary. This is best achieved by makingsure all datafiles have AUTOEXTEND disabled.It is advisable to read the article below which describes potentialissues using files of 2Gb or larger in size as this may influence the maximum datafile size you choose to use. Patches ~~~A fix is now available in 8.1.7.1.4 Bug.1823173 and will be included in8.1.7.3 BUG.1794199References ~~ 2Gb or not 2Gb - File limits in Oracle[NOTE:62427.1] Base bug reporting this problem [BUG:1668488] -Original Message-From: Yechiel Adar [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 10, 2002 11:08 AMTo: Multiple recipients of list ORACLE-LSubject: ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB Hello all HELP - and I am not an idiot. Oracle 8.1.6.3.4 on NT. We have a problem that the datafile for the application tables autoextended from 3.9 GB to 4.1 GB. We are getting ora-01115 errors and the datafile is offline. We tried export but it gets the same error. The status now is that the datafile is offline. Alter datafile online needsrecovery. Recovery gets I/O error and aborts. Anybody knows how to get the data out? As per Murphy's law, the last full backup of the database ran about 2 weeks ago and nobody noticed that the backup job ended ok but without backing up the files. So recovery means restoring from 2 weeks ago and applying archive logs for some hours. Oracle support are sending someone with a utility that MAY save the day. Any ideas ??? HELP Yechiel AdarMehish
RE: ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB
Title: Message This is interesting. I had a vendor do an install on one of our NT servers, and they set the files to autoextend to 8GB. When I modified that limit down to 2GB (our company standard) they clouded up and rained all over me! They said there was no physical reason to limit the file size since it was on a RAID array blah blah blah. I read the note and it talks about extending to a 4GB or 8GB boundary. Is that kinda like the speed of light...where some physicists have theorized that you can travel below the speed of light or above the speed of light, but not AT the speed of light? Gosh! Who knew? Cheers, Mike -Original Message-From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 10, 2002 8:29 AMTo: Multiple recipients of list ORACLE-LSubject: RE: ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB Note # 148894.1 on Metalink has a possible solution... NT has a limit of 4GB for the file size :( - Kirti
Re: ora-01115 after datafile autoexetend from 3.9 GB to 4.1 GB
Title: Message Thanks for all the replies. We called Oracle support and they come with the DUL utility and extracted the data. As Iwrite this e-mail imports are running. Concurrently wetried to restore the last full backup from more then 2 weeks ago\ and found about 1 day worth of archive logs missing, so this option is out. We now also restoring last night export to a separate database so in case of logical errors in the imported data they will be able to input the deals again and bring the system up to date. So now, eleven hours later we hope to finish in a few hours. Yechiel AdarMehish
