RE: ora-01113 and ora-01110

SVRMGR> alter database recover automatic datafile '/oracle/data/DEEP/data_sub_1b.dbf';
Statement processed.
SVRMGR> alter database datafile '/oracle/data/DEEP/data_sub_1b.dbf' online; Statement processed.

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of achoto_at_american.edu
Sent: Monday, July 10, 2000 3:21 PM
To: Multiple recipients of list ORACLE-L Subject: ora-01113 and ora-01110

I need some help. I deleted a datafile by mistake. I need to recover it. The datafile is still there and offline. I get the error

ora-01113 and ora-01110. Indicating I need to do a media recovery. I've never done this and I'm not sure what do I need to do.

Can someone out there help me with some pointers to recover it?

Thanks

Ana E. Choto
Systems Programmer
American University
Office of Information Technology
Phone (202) 885-2275
Fax (202) 885-2224

--
Author:
  INET: achoto_at_american.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).