How to recover a OFFLINE OFFLINE datafile?

  • From: "Shastry(DBA)" <shastry17@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 4 Feb 2009 20:17:21 +0530

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: