Home » RDBMS Server » Server Administration » ALL DATAFILES ARE FUZZY (Oracle 10.2.0.5.0, AIX 6)
ALL DATAFILES ARE FUZZY [message #614039] Wed, 14 May 2014 16:21 Go to next message
ganesh_gvn
Messages: 39
Registered: February 2012
Location: PUNE
Member

Dear All,
I have added 12 datafiles in production database , each of size 10gb. the standby recovery is going on , but while checking FUZZY column in v$datafile_header, it is showing ALL file are FUZZY. While putting this comment , recovery is in progress.

select FILE#,STATUS ,ERROR,RECOVER,FUZZY,CREATION_TIME ,NAME from v$datafile_header;

FILE# STATUS ERROR REC FUZ CREATION_ NAME
----- ------- ---------------------------------------- --- --- --------- -----------------------------------------------
1 ONLINE YES 09-JUN-10 +DATA/detuper_dr/data1/system01.dbf
2 ONLINE YES 09-JUN-10 +DATA/detuper_dr/data1/undotbs01.dbf
3 ONLINE YES 09-JUN-10 +DATA/detuper_dr/data1/sysaux01.dbf
4 ONLINE YES 09-JUN-10 +DATA/detuper_dr/data1/users01.dbf
5 ONLINE YES 19-AUG-10 +DATA/detuper_dr/data1/users02.dbf
6 ONLINE YES 08-OCT-10 +DATA/detuper_dr/data1/users03.dbf
7 ONLINE YES 01-DEC-10 +DATA/detuper_dr/data1/users04.dbf
8 ONLINE YES 23-DEC-10 +DATA/detuper_dr/data1/users05.dbf
9 ONLINE YES 17-JAN-11 +DATA/detuper_dr/data1/users06.dbf
10 ONLINE YES 17-JAN-11 +DATA/detuper_dr/data1/users07.dbf
11 ONLINE YES 17-JAN-11 +DATA/detuper_dr/data1/users08.dbf
12 ONLINE YES 17-JAN-11 +DATA/detuper_dr/data1/users09.dbf
13 ONLINE YES 21-JAN-11 +DATA/detuper_dr/data1/users10.dbf
14 ONLINE YES 21-JAN-11 +DATA/detuper_dr/data1/users11.dbf
15 ONLINE YES 14-MAY-11 +DATA/detuper_dr/data1/users12.dbf
16 ONLINE YES 17-APR-12 +DATA/detuper_dr/data3/data_depture1.dbf
17 ONLINE YES 17-APR-12 +DATA/detuper_dr/data3/data_depture2.dbf
18 ONLINE YES 17-APR-12 +DATA/detuper_dr/data3/data_depture3.dbf
19 ONLINE YES 17-APR-12 +DATA/detuper_dr/data3/data_depture4.dbf
20 ONLINE YES 04-MAY-12 +DATA/detuper_dr/data3/data_depture5.dbf
21 ONLINE YES 29-MAY-12 +DATA/detuper_dr/data2/data_depture6.dbf
22 ONLINE YES 29-MAY-12 +DATA/detuper_dr/data2/data_depture7.dbf
23 ONLINE YES 20-SEP-12 +DATA/detuper_dr/data3/kiosk_tbs01.dbf
24 ONLINE YES 30-MAR-13 /rmanbkp_new/posidex_dbf/undotbs02.dbf
25 ONLINE YES 01-JUN-13 +DATA/detuper_dr/data2/data_depture8.dbf
26 ONLINE YES 01-JUN-13 +DATA/detuper_dr/data3/data_depture9.dbf
27 ONLINE YES 14-AUG-13 +DATA/detuper_dr/data2/data_depture10.dbf
28 ONLINE YES 16-OCT-13 +DATA/detuper_dr/data2/undotbs03.dbf
29 ONLINE YES 14-MAY-14 +DATA/detuper_dr/data1/users13.dbf
30 ONLINE YES 14-MAY-14 +DATA/detuper_dr/datafile/users.298.847537667
31 ONLINE YES 14-MAY-14 +DATA/detuper_dr/datafile/users.299.847537715
32 ONLINE YES 14-MAY-14 +DATA/detuper_dr/datafile/users.300.847588809
33 ONLINE YES 14-MAY-14 +DATA/detuper_dr/datafile/users.301.847589843
34 ONLINE YES 14-MAY-14 +DATA/detuper_dr/datafile/users.302.847590735
35 ONLINE YES 14-MAY-14 +DATA/detuper_dr/datafile/users.303.847591379
36 ONLINE YES 14-MAY-14 +DATA/detuper_dr/datafile/users.304.847591797
37 ONLINE YES 14-MAY-14 +DATA/detuper_dr/datafile/users.305.847592191
38 ONLINE YES 14-MAY-14 +DATA/detuper_dr/datafile/users.306.847592595
39 ONLINE FILE MISSING

HOW i can make fuzzy as NO. please help

thanks ,
Ganesh
Re: ALL DATAFILES ARE FUZZY [message #614043 is a reply to message #614039] Thu, 15 May 2014 00:03 Go to previous messageGo to next message
Michel Cadot
Messages: 65389
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This is expected.

Please read How to use [code] tags and make your code easier to read.

[Updated on: Thu, 15 May 2014 00:05]

Report message to a moderator

Re: ALL DATAFILES ARE FUZZY [message #614578 is a reply to message #614043] Fri, 23 May 2014 08:19 Go to previous messageGo to next message
ganesh_gvn
Messages: 39
Registered: February 2012
Location: PUNE
Member

Sorry Sir. I resolved the issue on the same day.

Recovery was in progress at the time of posting this message. After recovery , all datafile was online.

I will be more careful while posting next message. thanks
Re: ALL DATAFILES ARE FUZZY [message #614598 is a reply to message #614578] Fri, 23 May 2014 10:51 Go to previous message
Michel Cadot
Messages: 65389
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

But after recovery the data file headers still show FUZZY.
As soon as the database is open, the data file headers show FUZZY.

Previous Topic: Excessive Archive logs creation
Next Topic: CLOB's not reclaiming space
Goto Forum:
  


Current Time: Fri Feb 23 19:25:05 CST 2018

Total time taken to generate the page: 0.01524 seconds