Home » RDBMS Server » Server Administration » fuzzy from V$datafile_header
fuzzy from V$datafile_header [message #300904] Mon, 18 February 2008 11:22 Go to next message
itguru
Messages: 19
Registered: July 2007
Junior Member
When tablespace / datafile put in backup mode with begin backup command.

Its header get freeze. One can verify it by querying fuzzy value from V$datafile. If its in backup mode will display YES else null.

But here no file is in backup mode than too display YES including for SYSTEM data file. Why?


SQL> select file#,status from v$backup ;

FILE# STATUS
---------- ------------------
1 NOT ACTIVE
2 NOT ACTIVE
3 NOT ACTIVE


SQL> select file#,name,status,fuzzy from V$datafile_header;

FILE#
----------
NAME
--------------------------------------------------------------------------------
STATUS FUZ
------- ---
1
J:\DATA\T1\SYSTEM01.DBF
ONLINE YES

2

J:\DATA\T1\UNDOTBS01.DBF
ONLINE YES

FILE#
----------
NAME
--------------------------------------------------------------------------------
STATUS FUZ
------- ---

3
J:\DATA\T1\USERS01.DBF
ONLINE YES


Re: fuzzy from V$datafile_header [message #300905 is a reply to message #300904] Mon, 18 February 2008 11:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Depends on your Oracle Version. In certain versions, this is the expected behavior and in certain older versions it has been reported as bug.
After 9i and above, fuzzy=y is expected.
Check documentation?
Re: fuzzy from V$datafile_header [message #300906 is a reply to message #300905] Mon, 18 February 2008 11:50 Go to previous messageGo to next message
itguru
Messages: 19
Registered: July 2007
Junior Member
Its Oracle 9.0.1.0.1.


but actually its sql release. How to get oracle version.


Eg. show parameters....?




Mahesh Rajendran wrote on Mon, 18 February 2008 11:32
Depends on your Oracle Version. In certain versions, this is the expected behavior and in certain older versions it has been reported as bug.
After 9i and above, fuzzy=y is expected.
Check documentation?


Re: fuzzy from V$datafile_header [message #300911 is a reply to message #300906] Mon, 18 February 2008 12:03 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Check CONNECTED TO
and
V$VERSION.
Last login: Mon Feb 18 13:04:54 2008 from wibr-vpn-7-101.
oracle@mutation#sqlplus xx/xx@xx

SQL*Plus: Release 9.2.0.8.0 - Production on Mon Feb 18 13:05:00 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning and Data Mining options

xx > select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi
PL/SQL Release 10.2.0.2.0 - Production
CORE    10.2.0.2.0      Production
TNS for Linux: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production

[Updated on: Mon, 18 February 2008 12:04]

Report message to a moderator

Previous Topic: critical patch update(CPUJAN2008)
Next Topic: TNS:no listener
Goto Forum:
  


Current Time: Sun Dec 11 00:18:22 CST 2016

Total time taken to generate the page: 0.14997 seconds