| fuzzy from V$datafile_header [message #300904] |
Mon, 18 February 2008 11:22  |
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 #300906 is a reply to message #300905] |
Mon, 18 February 2008 11:50  |
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 |
 |
Mahesh Rajendran
Messages: 10708
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
