RE: How to recover a OFFLINE OFFLINE datafile?

From: Michael Fontana <mfontana_at_enkitec.com>
Date: Wed, 4 Feb 2009 08:59:54 -0600 (CST)
Message-ID: <3504310.13701233759594006.JavaMail.root_at_mail.enkitec.com>

This is one of those scenarios where there are a hundred different answers based upon the details of the recover situation. That being said, let's assume it's a simple case of the file being unavailable at one point, and has been restored from a valid backup. If so, it's this easy:  

Recover datafile 'datafile-name';  

(you may be prompted for archive log apply)  

Alter database datafile 'datafile-name' online;  

Now, if the file is not where the database thinks it is (select file_name from dba_datafiles where file_id = 10), then you'll need to restore it first.  

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Shastry(DBA)
Sent: Wednesday, February 04, 2009 8:47 AM To: oracle-l
Subject: How to recover a OFFLINE OFFLINE datafile?  

Hi all,  

I see a datafile 10 in v$recover_file view

SQL> select * from v$recover_file;

   FILE# ONLINE ONLINE_
---------- ------- -------
ERROR
CHANGE#

---

---

TIME

---

      10 OFFLINE OFFLINE
                                                                1.1632E+10

02-FEB-09   Could you please advice on this on how to recover this datafile? Do i need to bring this online and then recover, please let me know what steps i need to take ahead on this scenario.  

Thanks,

Ann

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 04 2009 - 08:59:54 CST