Re: Corrupted dbf file... help!!

From: Helma <helma.vinke_at_hotmail.com>
Date: Wed, 12 Sep 2007 04:19:22 -0700
Message-ID: <1189595962.152313.181350@57g2000hsv.googlegroups.com>

You seem to advocate to scan the controlfile with an unix command in stead of using the normal oracle features. Your arguments for this are that we 'should assume nothing' from an unexperience DBA. As an example you state that the situation from the OP could have been right after a cold backup :
" How do you know it is the original database?" and
" The controlfile used for that display could have been from a
backup!"

I see no difference in the assumptionlevel between scanning a controlfile and the ASCII backup to trace, except the one that is mentioned before in this thread: It's not what you find in the controlfile, but what Oracle finds in the controlfile.

Cold backup situation or not is not the difference that would justify to leave normal oracle functionality. The only reason to use a scan of a file, AFAIK, is when you prefer it because of your strong Unix background or you simply didn't know you could backup to trace.

H. Received on Wed Sep 12 2007 - 06:19:22 CDT