Re: Problem in refresh

Ann,

Is there any chance that you have archived off-line versions of backups that stretch back 15 days or so?

r,

Gus

On Tue, Sep 23, 2008 at 10:32 PM, Shastry(DBA) <shastry17_at_gmail.com> wrote:
> Thanks Dennis for your reply,
>
> The datafile does exists but it is overwritten as the name of datafile is
> same in different mount points.
>
> Thanks,
> Ann
>
> On Wed, Sep 24, 2008 at 7:49 AM, Dennis Williams
> <oracledba.williams_at_gmail.com> wrote:
>>
>> Ann,
>>
>> If that datafile doesn't exist on your backup, then you don't have it. You
>> could take a fresh backup, but if the user wants the one that is 15 days
>> old, that doesn't help.
>>
>> If you mean that the datafile only contains indexes, then your best
>> alternative may be to just rebuild the indexes.
>>
>> There are several goodies in 10g that may be of assistance if you have
>> them configured.
>>
>> Dennis Williams
>>
>>
>

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