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 AM To: Multiple recipients of list ORACLE-L Subject: 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
needs recovery.
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 Adar
Mehish |
Title: Message
- ora-01115 after datafile autoexetend from 3.9 GB to... Yechiel Adar
- RE: ora-01115 after datafile autoexetend from ... Deshpande, Kirti
- RE: ora-01115 after datafile autoexetend from ... Johnston, Tim
- RE: ora-01115 after datafile autoexetend from ... Vergara, Michael (TEM)
- Re: ora-01115 after datafile autoexetend from ... Yechiel Adar
- Re: ora-01115 after datafile autoexetend from ... Yechiel Adar