I'm not sure, but don't you need to execute 2 more commands:
alter database recover datafile 'new_file_name';
alter database datafile 'new_file_name' online;
Hope this helps,
donita
:Date: Fri, 20 Apr 2001 10:51:01 -0800
:To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
:X-Comment: Oracle RDBMS Community Forum
:X-Sender: "Cale, Rick T (Richard)" <[EMAIL PROTECTED]>
:From: "Cale, Rick T (Richard)" <[EMAIL PROTECTED]>
:Subject: Datafile needs media recovery
:X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman
:
:Hi All,
:
:Oracle 8 running in Archivelog
:One of my coworkers said they did the following:
:
:1. Added a datafile to a tablespace
:2. Took datafile offline and renamed at OS
:3. ALTER DATABASE RENAME ... to new name
:4. Attempted to bring datafile back online and get file needs media
:recovery.
:
:Tried to alter database recover automatic and other options but does not
:work.
:
:This is all the info I have does anyone have any suggestions on why it needs
:media recovery and how
:he can get it back online. We cannot drop the tablespace and rebuild. We
:could maybe export all objects in that tablespace
:then rebuild.
:
:Thanks
:Rick
:--
:Please see the official ORACLE-L FAQ: http://www.orafaq.com
:--
:Author: Cale, Rick T (Richard)
: INET: [EMAIL PROTECTED]
:
: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: [EMAIL PROTECTED] (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).
|\ _,,,---,,_
ZZZzz /,`.-'`' -. ;-;;,_
_________________|,4- ) )-,_. ,\ (____-'___________________
'---''(_/--' `-'\_)
Donita Hilfinger [EMAIL PROTECTED]
ISIS Oracle Database Administrator Ph:(303)737-4179
Great-West Life Assurance Co. Fax:(303)737-4850
8515 E. Orchard Rd, m/s 5T2
Englewood, CO 80111
"The promise is remembered long after the conditions attached to it are
forgotten"
-- author unknown
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Donita Hilfinger
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
