Re: How to recover a OFFLINE OFFLINE datafile?
- From: "Shastry(DBA)" <shastry17@xxxxxxxxx>
- To: Andrew Kerber <andrew.kerber@xxxxxxxxx>, mfontana@xxxxxxxxxxx
- Date: Fri, 6 Feb 2009 00:03:03 +0530
Thank you so much... it did work fine.
On Wed, Feb 4, 2009 at 9:14 PM, Andrew Kerber <andrew.kerber@xxxxxxxxx>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@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:
