Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

fuzzy datafiles after recovery

Think_dbaSep 14 2012 — edited Sep 14 2012

Oracle :10.2
OS:Windows server 2003

Hi,

I have lost my system datafile so i hvae restored it from cold backup and then do recovery using archive log.When i queried v$datafile_header i found the datafles are fuzzy

SQL> select substr(name,1,50), recover, fuzzy, checkpoint_change# from v$datafile_header;

SUBSTR(NAME,1,50)                                  REC FUZ CHECKPOINT_CHANGE#
-------------------
------------------------------- --- --- ------------------
E:\ORAHOME_1\ORADATA\PATH\SYSTEM01.DBF             NO  YES             839525
E:\ORAHOME_1\ORADATA\PATH\UNDOTBS01.DBF            NO  YES             839525
E:\ORAHOME_1\ORADATA\PATH\SYSAUX01.DBF             NO  YES             839525
E:\ORAHOME_1\ORADATA\PATH\USERS01.DBF              NO  YES             839525

A datafile that contains a block whose System Change Number (SCN) is more recent than the SCN of its header is called a fuzzy datafile.

Is there is any issue with these fuzzy files on my database?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 12 2012

Added on Sep 14 2012

#general-database-discussions

11 comments

4,233 views