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 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

Reply via email to