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 -> Lost control files and a data file

Lost control files and a data file

From: Martin Krivak <martin.krivak_at_berit.cz>
Date: 27 Apr 1998 11:51:23 GMT
Message-ID: <01bd71d1$655a6b50$39c3657e@mkrivak>


I've lost all control files and one datafile. No backups. Is there any way to recover?

When I try to recreate the control file I get the message: ORA-01565: error in identifying file 'E:\DATABASE\ZR1ORC1.ORA'

Since I have no control file I can't mount the database and recreate the datafile with:
ALTER DATABASE CREATE DATAFILE 'E:\DATABASE\ZR1ORC1.ORA' AS 'E:\DATABASE\ZR1ORC1.ORA'; I'm afraid the file is lost.
Anyone help?

--
Martin Krivak Received on Mon Apr 27 1998 - 06:51:23 CDT

Original text of this message

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