RE: How to recover a OFFLINE OFFLINE datafile?
- From: "Michael Fontana" <mfontana@xxxxxxxxxxx>
- To: <shastry17@xxxxxxxxx>
- 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
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
Other related posts:
