Re: How to recover a OFFLINE OFFLINE datafile?
Date: Fri, 6 Feb 2009 00:03:03 +0530
Message-ID: <5b294dab0902051033i30a28ba3ge158a99cf20d3047_at_mail.gmail.com>
Thank you so much... it did work fine.
On Wed, Feb 4, 2009 at 9:14 PM, Andrew Kerber <andrew.kerber_at_gmail.com>wrote:
> 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 Thu Feb 05 2009 - 12:33:03 CST