Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Whats Fuzzy in v$datafile_header

Re: Whats Fuzzy in v$datafile_header

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Thu, 16 Feb 2006 02:25:37 GMT
Message-Id: <pan.2006.02.16.02.25.37.251328@sbcglobal.net>


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 bytes
Database mounted.
SQL>
SQL> select fuzzy from v$datafile_header;

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.com
Received on Wed Feb 15 2006 - 20:25:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US