The last time I saw fuzzy in relation to a restore was when I was proving that you had to put the tablespaces in backup mode (pre-1995) before one backs them up to tape. The network admins copied the datafiles off to tape on a live database. Upon restore they were all fuzzy. I'm thinking perhaps something similar has occurred here. Joel Patterson Database Administrator 904 727-2546 ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Charles Schultz Sent: Friday, July 17, 2009 10:01 AM To: ORACLE-L Subject: Production problem: Fuzzy standby database Good day, I have a feeling my head is not screwed on right this morning, so forgive me if I am missing something obvious. We have a 10.2.0.2 physical standby on Solaris 10; when put into any kind of recovery mode, all the datafiles have this message in the alert log: Warning: Datafile nnn (xxx) is media recovery fuzzy Standby database will not open with this datafile online! Applying more redo has not helped, yet. Not finding much on google or metalinks, and I hate to open an SR at this point because our experience is that they typically take a long time. Any quick thoughts? Or rather, let me clearly state I would rather not have guesses at this point, but solutions that are known to work and would be relevant to us. -- Charles Schultz