Re: fuzzy hot backup
Date: Fri, 31 Oct 2008 11:27:19 -0700 (PDT)
On Oct 31, 9:07 am, kat <katie..._at_gmail.com> wrote:
> 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
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
-- @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 GodinReceived on Fri Oct 31 2008 - 13:27:19 CDT