| FUZZY value always a YES [message #59887] |
Wed, 31 December 2003 08:51  |
scott
Messages: 73
Registered: September 1999
|
Member |
|
|
I am running the following commands and not everything is according to Oracle Docs
SYSTEM : Oracle 9.2 on Windows 2000 machine
SCRIPT
--------
ALTER TABLESPACE INDX BEGIN BACUP;
> Tablespace altered
SELECT NAME, STATUS, FUZZY FROM V$DATAFILE_HEADER;
The INDX datafile is showing fuzzy = YES
Now I backup with OS commands and issue
ALTER TABLESPACE INDX END BACUP;
> Tablespace altered
ALTER SYSTEM ARCHIVE LOG CURRENT
and then
SELECT NAME, STATUS, FUZZY FROM V$DATAFILE_HEADER;
FUZZY is still YES and not NULL as the Oracle Doc says
Any info ?
Thanks
Scott
|
|
|
|
| Re: FUZZY value always a YES [message #59888 is a reply to message #59887] |
Wed, 31 December 2003 09:26  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Good catch. From 9i onwards,use v$backup.status (ACTIVE or NOT ACTIVE) instead. v$datafile_header.FUZZY = YES for any ONLINE READ WRITE datafiles and otherwise for READ ONLY or OFFLINE files becos of 'online fuzziness'! in 9i.
Hotbackup status doesnt affect this column anymore,according to Oracle support.
In prior versions,the FUZZY column denoted only Hotbackup fuzziness.
Hope this helps
Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
