Re: How to recover a OFFLINE OFFLINE datafile?

alter database datafile 10 online;

Then recover the datafile.

On Wed, Feb 4, 2009 at 8:47 AM, Shastry(DBA) <shastry17_at_gmail.com> wrote:

> 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
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

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