Re: fuzzy hot backup

On Oct 31, 11:07 am, kat <katie..._at_gmail.com> wrote:
> Hi,
> I'm trying to do a restore/recover to a point in time from a hot
> backup in 10.2. When I opened (reset log) the database, it complained
> that datafile 1 was fuzzy. What view can I use to check which datafile
> has a different checkpoint scn or what the issue is?
>
> I ran the following query and it appeared that all data files have the
> same SCNs. I thought with fuzzy backups, the checkpoint scns of data
> files are different which in my case, they were all the same.
>
> Can someone help?
>
> select file#,checkpoint_change# from v$datafile;
>
>      FILE# CHECKPOINT_CHANGE#
> ---------- ------------------
>          1      9030463382231
>          2      9030463382231
>          3      9030463382231
>          4      9030463382231
> ...
> ...
>
> Thanks.

Possibly you should check ONLINE_CHANGE# and OFFLINE_CHANGE# for those datafiles.

David Fitzjarrell Received on Fri Oct 31 2008 - 11:31:00 CDT