Re: fuzzy hot backup

On Oct 31, 9: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.

Also see v$datafile_header. It has a fuzzy column.

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/recov003.htm#sthref540 and metalink Notes:1015544.102, 90220.1, 435201.1, 604683.1

jg

--
@home.com is bogus.  "If you have a presence on twitter, squidoo,
blogs, facebook, myspace, linkedin and 20 other sites, the chances of
finding critical mass at any of them is close to zero. But if you
dominate, if you're the goto person, the king of your hill, magical
things happen. One follower in each of twenty places is worthless.
Twenty connected followers in one place is a tribe. It's the
foundation for building something that matters." - Seth Godin