Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: fuzzy column in v$datafile_header
My guess is that you (or someone else) run an "alter tablespace X begin backup;
and did not run a "alter tablespacce X end backup";
for all of your tablespace during a hot backup.
"xueyang" <xueyangy_at_singnet.com.sg> wrote in message news:<aqt52u$kjg$1_at_mawar.singnet.com.sg>...
> And I find the fuzzy column is null in a 8.1.6 db.
> Anyone can tell me the difference?
>
> TIA
> "xueyang" <xueyangy_at_singnet.com.sg> wrote in message
> news:aqt3ua$kgg$1_at_mawar.singnet.com.sg...
> > Hi,
> >
> > I read from oracle document that says the fuzzy column'value is changed
> from
> > null to 'YES' when you issue alter tablespace begin backup.
> > But when i go to my 9.2.0 database, do nothing but issue 'select fuzzy
> from
> > v$datafile_header', all values are 'YES' and i am sure no one doing the
> > backup.
> > Any can tell me why that is?
> >
> > TIA
> >
> >
Received on Wed Nov 13 2002 - 15:29:00 CST