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 -> pb with one datafile

pb with one datafile

From: thierry <thierry.constant2_at_wanadoo.fr>
Date: Sun, 23 Sep 2001 14:25:48 +0200
Message-ID: <3BADD4CC.19F3B094@wanadoo.fr> 





Hi,



I use Oracle 8.1.7.


One datafile for a tablespace (other than system ) was deleted.
When I startup, the base cannot be opened because of the missing file.
I connect internal



V$DATAFILE says the missing file ONLINE ,  why ????



I am NOT in ARCHIVELOG, I have a backup of the file.



What is the procedure to recover my base with the backup of the file ?



Thanks
Received on Sun Sep 23 2001 - 07:25:48 CDT












Original text of this message













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