Re: How to recover a OFFLINE OFFLINE datafile?
Date: Wed, 4 Feb 2009 09:44:00 -0600
Message-ID: <ad3aa4c90902040744o44e205dal7f00f6f35d981eb1_at_mail.gmail.com>
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_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-lReceived on Wed Feb 04 2009 - 09:44:00 CST