| ALL DATAFILES ARE FUZZY [message #614039] |
Wed, 14 May 2014 16:21  |
|
|
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 #614578 is a reply to message #614043] |
Fri, 23 May 2014 08:19  |
|
|
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 |
 |
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
|
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
