RE: How to recover a OFFLINE OFFLINE datafile?
Date: Wed, 4 Feb 2009 08:59:54 -0600 (CST)
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?
I see a datafile 10 in v$recover_file view
SQL> select * from v$recover_file;
FILE# ONLINE ONLINE_
---------- ------- -------
10 OFFLINE OFFLINE 1.1632E+1002-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.
AnnReceived on Wed Feb 04 2009 - 08:59:54 CST