fuzzy hot backup

[kat]

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.

[ddf]

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

David Fitzjarrell

[joel garry]

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