Try this.

SQL>alter database mount;

SQL>alter database datafile '/user24/dbs/temp1***1.dbf' offline;

SQL> alter database open;

If the application tries to access any of the objects in that file, ot
would throw error.If that is a temp file, you are nothing to lose.


Regards,
Ganti



"Sagar " <oracledba-ezmlmshield-x36239551.[Email address protected]
05/05/2005 09:32 AM


To

"LazyDBA Discussion" <[Email address protected]
cc





Subject
Re: ORA-01157,ORA01110






Dxiang, is right, you have no alternative other than to restore from
backup.

Rgds
sagar M.


----- Original Message -----
From: "DXiang" <oracledba-ezmlmshield-x76139402.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, May 04, 2005 9:21 PM
Subject: Re: ORA-01157,ORA01110


>
> 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] "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
>
>
>
>
>
>
>
> --------
> 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
>



--------
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