| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Datafile needs media recovery
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 <ORACLE-L_at_fatcity.com>
:X-Comment: Oracle RDBMS Community Forum
:X-Sender: "Cale, Rick T (Richard)" <RICHARD.T.CALE_at_saic.com>
:From: "Cale, Rick T (Richard)" <RICHARD.T.CALE_at_saic.com>
: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: RICHARD.T.CALE_at_saic.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).
|\ _,,,---,,_
ZZZzz /,`.-'`' -. ;-;;,_
_________________|,4- ) )-,_. ,\ (____-'___________________
'---''(_/--' `-'\_)
Donita Hilfinger donita.hilfinger_at_gwl.com
ISIS Oracle Database Administrator Ph:(303)737-4179
Great-West Life Assurance Co. Fax:(303)737-4850
8515 E. Orchard Rd, m/s 5T2
"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: dohi_at_gwl.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).Received on Fri Apr 20 2001 - 14:59:01 CDT
 |
 |