There is no other way. You have to restore it back from your backup.

David Xiang
Canadian Depository For Securities Ltd.
85 Richmond St. West.
Toronto, Ontario
M5H 2C9
(416) 815-2029
email: [Email address protected]



"muley_cd"
<oracledba-ezmlmshield-x31808565.[Email Address Removed] To: "LazyDBA Discussion" <[Email address protected]
zyDBA.com> cc:
Subject: ORA-01157,ORA01110
05/04/2005 02:25 AM






Dear All,
we are having oracle7.0.16.4 loaded on unix.one of our hard disk containing
dbf file was removed the data on this disk can not be retrived.now when i
am
trying to start oracle it's giving error as mentioned below.i had tried to
load the data from back but it does't
SQLDBA> startup

ORACLE instance started.

Database mounted.

ORA-01157: cannot
identify data file 3 - file not found

ORA-01110: data file 3:
'/user24/dbs/temp1***1.dbf'

Attempting to dismount database........Database
dismounted.

Attempting to shutdown instance........ORACLE instance shut
down.

Kindly advise how to start oracle if any dbf file is corrupt.or can not be
accessed.


regards

muley




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html






Oracle LazyDBA home page