Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Whats Fuzzy in v$datafile_header
On Tue, 14 Feb 2006 22:47:29 -0800, jackal wrote:
> Hi,
> I have a db in which all tablespaces are ONLINE. I ve not issued
> ALTER TABLESPACE BEGIN BACKUP command on any of the tablespaces. But
> still when i query the v$datafile_header table i get a YES value in the
> FUZZY column for all datafiles.
>
> Is there something wrong with the datafiles?
>
> Thanks in advance
> Jackal
Yes. There is a problem with your datafiles. The DBA in charge of them hasn't been reading the concepts manual. Here is the problem: $ svrmgrl
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 15 21:21:41 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 335544320 bytes
Fixed Size 1219304 bytes Variable Size 113247512 bytes Database Buffers 218103808 bytes Redo Buffers 2973696 bytesDatabase mounted.
FUZ
--- NO NO NO NO NO NO NO 7 rows selected. SQL> SQL> alter database open; Database altered. SQL> select fuzzy from v$datafile_header; FUZ --- YES YES YES YES YES YES YES 7 rows selected. SQL> Your files will be OK as long as you don't open the database. That will protect the datafiles from becoming fuzzy. So, keep your database closed and everything will be OK. Having your database closed will also speed up otherwise long running queries. -- http://www.mgogala.comReceived on Wed Feb 15 2006 - 20:25:37 CST