Re: datafile error--database won't open

From: Julio <julio.negueruela_at_si.unirioja.es>
Date: Tue, 21 Jul 1998 12:37:18 +0200
Message-ID: <35B46F5E.E57FEE66@si.unirioja.es>

andrea_johnson_at_wolfe.net escribió:
> =

> Running Oracle Server 7.3.2.2 --
> =

> We've got a corrupted datafile -- no backup (oops)
> =

> At this point the IO error reading the block in the specific datafile i=
s
> keeping the database from opening--we shut it down to try to fix the fi=
le.
> =

> The problem began with a bad transaction using SQLloader to
> load data from a flat file.
> =

> What can we do to clear/re-create/or delete this datafile?

Mount the database but not open:

startup mount;

drop the datafile:

alter database datafile '<name>' offline drop;

alter database open;

If you've got any recentrly export drop the tablespace, recreate and import the objects placed there. If not, you should pray, may be you'll be lucky and the database work right without that dafaile but the most probably, you'll hace consistency problems.

Hope this help.

PS: Next time you should define any backup policy. -- =

Julio Negueruela
DBA Servicio Informático

Universidad de La Rioja      -      Spain
Telf: 941-299179     Fax: 941- 299180

mailto:julio.negueruela_at_si.unirioja.es Received on Tue Jul 21 1998 - 05:37:18 CDT