My Oracle Support Banner

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

Last updated on JULY 06, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.6 and later
Information in this document applies to 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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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