Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can the database go on with a data file withs tatus RECOVER?

Re: Can the database go on with a data file withs tatus RECOVER?

From: Joe Maloney <mpir_at_bellsouth.net>
Date: 11 Oct 2004 12:54:13 -0700
Message-ID: <d17bad25.0410111154.60238f72@posting.google.com>


"Randi W" <randiwolner_at_hotmail.com> wrote in message news:<ckdvmf$897$1_at_services.kq.no>...
> Oracle ver. 8.1.7, NT:
>
> I had a disk crash on the disk containing one of the datafiles in the TEMP
> tablespace. I have no backup routines on this database (yes, I know this is
> stupid, so please do not comment on this).
>
> I managed to get my database running by using this command in svrmgrl:
>
> alter database datafile 'G:\ORADATA\ORAPOO1\TEMP02.DBF' offline drop;
>
> In v$datafile the status of this file is 'RECOVER'. My question is: Can my
> database 'live on' with the file having this status? As it is the TEMP
> tablespace I figure there is no data in the file at this time, and I can add
> more files if more temporary space is needed.
> OR - will Oracle give error messages when trying to allocate more space in
> temp tablespace, and finding that one of the data files has 'RECOVER' status
> ?
>
> Thanks for any help on this,
> Randi W.

Since it is the temporary tablespace, why not just drop the tablespace and recreate it? Received on Mon Oct 11 2004 - 14:54:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US