fuzzy v$datafile

After A Tablespace Hot Backup Ended Fuzzy Value Not Set To Null (Doc ID 353606.1)Oracle Server - Enterprise Edition - Version: 9.2.0.6.0 This problem can occur on any platform. SYMPTOMS After an 'alter tablespace <tablespace_name> end backup' command issued the value in V$DATAFILE_HEADER view for the FUZZY column is still  showing ' YES.'  Ealier in 8i versions "After the ALTER TABLESPACE <tbs_name> END BACKUP command is issued, the value in the FUZZY column column  would change to NULL." From version  9i onwards  we see this as 'YES' SQL> select * from v$backup;      FILE# STATUS                      CHANGE# TIME ---------- ------------------ ---------------- --------------------          1 NOT ACTIVE            8236405405836 25-JAN-2006 03:58:01          2 NOT ACTIVE            8236405405840 25-JAN-2006 03:58:01          4 NOT ACTIVE            8236405405844 25-JAN-2006 03:58:01          5 NOT ACTIVE            8236405405924 25-JAN-2006 03:59:49          6 NOT ACTIVE            8236405405850 25-JAN-2006 03:58:01          7 NOT ACTIVE            8236405405854 25-JAN-2006 03:58:02          8 NOT ACTIVE            8236405405903 25-JAN-2006 03:59:46          9 NOT ACTIVE            8236405405847 25-JAN-2006 03:58:01         10 NOT ACTIVE            8236405405858 25-JAN-2006 03:58:03         11 NOT ACTIVE            8236405405862 25-JAN-2006 03:58:03         12 NOT ACTIVE            8236405405899 25-JAN-2006 03:59:46         13 NOT ACTIVE            8236405405906 25-JAN-2006 03:59:47         14 NOT ACTIVE            8236405405910 25-JAN-2006 03:59:47         15 NOT ACTIVE            8236405405913 25-JAN-2006 03:59:47         16 NOT ACTIVE            8236405405921 25-JAN-2006 03:59:48         17 NOT ACTIVE            8236405405917 25-JAN-2006 03:59:48 16 rows selected. SQL> select FILE#,FUZZY from v$datafile_header;      FILE# FUZ ---------- ---          1 YES          2 YES          4 YES          5 YES          6 YES          7 YES          8 YES          9 YES         10 YES         11 YES         12 YES         13 YES         14 YES         15 YES         16 YES         17 YES CHANGES None CAUSE  Bug 1158714, fixed in V901 SQL > select file#, fuzzy, name from v$datafile_header Should return YES for fuzzy when database is open. It should return 'YES' at least for all datafiles that are  ONLINE and READ WRITE  because they are online fuzzy.  A file that is OFFLINE clean or READ ONLY should not have any fuzzy column set The view v$datafile_header will show 'YES' for the fuzzy column when the  datafile is online an in read write mode.  If you change the tablespace to read  only mode then the fuzzy value changes to NO.  What  is seen is a normal behavior.  SOLUTION Question now would be :  The   only  way to know if the database datafile is in hot backup mode  would be  to  use the  V$BACKUP view and check if STATUS is ACTIVE? Yes,  status column  from the V$backup  view  shows the detailed information about datafiles in backup.mode It's the best view you should check to identify if the data files are in backup mode. This was incorrect behaviour at 8i and in fact was bugged at 817 - this was fixed in 9i.   The correct and normal behaviour is what you  are seeing now.   Use V$backup to check backup status.