Path: g2news1.google.com!postnews.google.com!v22g2000pro.googlegroups.com!not-for-mail
From: ddf <orat...@msn.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: fuzzy hot backup
Date: Fri, 31 Oct 2008 09:31:00 -0700 (PDT)
Organization: http://groups.google.com
Lines: 31
Message-ID: <24fd0b56-79a8-47cf-9dab-02e8fa9caa97@v22g2000pro.googlegroups.com>
References: <09f05b87-664d-4dfb-9143-681067ad5018@v13g2000pro.googlegroups.com>
NNTP-Posting-Host: 138.32.32.166
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1225470661 462 127.0.0.1 (31 Oct 2008 16:31:01 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 31 Oct 2008 16:31:01 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: v22g2000pro.googlegroups.com; posting-host=138.32.32.166; 
	posting-account=KXUmygkAAABvBFmgDBe4RBLFwhTRAMZC
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; 
	Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ;  Embedded Web 
	Browser from: http://bsalsa.com/; .NET CLR 1.1.4322; .NET CLR 
	2.0.50727),gzip(gfe),gzip(gfe)

On Oct 31, 11:07=A0am, kat <katie...@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;
>
> =A0 =A0 =A0FILE# CHECKPOINT_CHANGE#
> ---------- ------------------
> =A0 =A0 =A0 =A0 =A01 =A0 =A0 =A09030463382231
> =A0 =A0 =A0 =A0 =A02 =A0 =A0 =A09030463382231
> =A0 =A0 =A0 =A0 =A03 =A0 =A0 =A09030463382231
> =A0 =A0 =A0 =A0 =A04 =A0 =A0 =A09030463382231
> ...
> ...
>
> Thanks.

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


David Fitzjarrell