| 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: Datafile "missing"
First back up the database --cold backup obviously since you are in
noarchivelog mode
Now that you have a place to go back to if this doesn't work:
you can rename the datafiles
in svrmgrl
startup mount
alter database rename 'old file name' to 'new file name';
now rename them at the OS level
as for the space, you can TRY:
alter database datafile 'filename' resize integer [K/M];
you can't get rid of it completely but you can make it REALLY small
Rachel
>From: "Daniel Campomanes" <dcampoma_at_telecompersonal.com.ar>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Datafile "missing"
>Date: Wed, 13 Dec 2000 07:15:37 -0800
>
>Hi Lists;
>Our issue:
>A disk crashed in a database, that is a warehouse ( is in NOARCHIVE mode),
>in this disk we had only 6 datafiles that have only one table with old
>information. We did:
>- Startup mount only , and ...
> - alter database datafile 'filename' offline drop
>in each datafile.
>Now, the database is up and OK, but the "drop" didn´t work. The
>datafiles remains in the dictionary and the space is "allocated";
>I means, for oracle, the tablespace have 120 GB , but 20 GB (the
>crashed disk) doesn´t exist. We want to use the same name for
>the news datafiles, but we can´t. We want to drop the ghosts
>datafiles and put free the wrong allocated space .
>Oracle support said: you have to re-create the tablespace and
>then, create the datafiles again ...
>This job is very complicated (remember, 120 GB and without free space
>in others disks)
>How can I drop the datafiles easily?
>SO: Digital Alpha 4d , Oracle 8.0.5.1.1
>
>Thanks in advance ...
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Daniel Campomanes
> INET: dcampoma_at_telecompersonal.com.ar
>
>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).
 |
 |