RE: ora-01113 and ora-01110

What shall I do if I have lost the data file? Here's the situation: - Alter Database datafile '/u03/oradata/cmoradb1/rbs02.dbf' offline drop;
(Suceed)

- Now I still have an active rollback segment 'RBSBIG' marked with status 'Need Recovery', and the tablespace status 'Online'

TIA,
Zhong Hong

-----Original Message-----
From: Linda Wang [mailto:lwang_at_messagemedia.com] Sent: Monday, July 10, 2000 2:57 PM
To: Multiple recipients of list ORACLE-L Subject: 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-----
achoto_at_american.edu
Sent: Monday, July 10, 2000 3:21 PM
To: Multiple recipients of list ORACLE-L

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

-- 
Author: Linda Wang
  INET: lwang_at_messagemedia.com

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