After A Tablespace Hot Backup Ended Fuzzy Value Not Set To Null (Doc ID 353606.1)

Last updated on JANUARY 17, 2023

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.