Re: Datafile needs media recovery

From: Brijesh Lal <lal_brijesh_at_yahoo.com>
Date: Sat, 21 Apr 2001 07:01:53 -0700
Message-ID: <F001.002EE971.20010421065022@fatcity.com>

Hi
  Since ur database in in archive log mode you can go for following method also
just move your datafile to some other place. This is just for backup. Now create a new datafile based on existing datafile using following command

alter database create datafile'old_datafile_name+path'

as 'new_datafile_name+path'

where old_datafile_name+path will be the path and name of ur orginal datafile which u have renamed and new_datafile_name+path will be the name and path u desire
Then perform media recovery for that new datafile using
recover datafile 'new_datafile_name+path' This method is basically used to recreate and recover damaged datafile
However for this u must have all archive log files since orginal datafile was created

Hope so this may help u

Brijesh

• "Cale, Rick T (Richard)" <RICHARD.T.CALE_at_saic.com> wrote:
  > 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).
  

  ---

Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Brijesh Lal
  INET: lal_brijesh_at_yahoo.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 Sat Apr 21 2001 - 09:01:53 CDT