Re: How to recover a OFFLINE OFFLINE datafile?
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: shastry17@xxxxxxxxx
- Date: Wed, 4 Feb 2009 09:44:00 -0600
First put the file online,
alter database datafile 10 online;
Then recover the datafile.
On Wed, Feb 4, 2009 at 8:47 AM, Shastry(DBA) <shastry17@xxxxxxxxx> 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.'
Other related posts:
