Re: Read error in .dbf file on Sun server

"Bill Hutchison" <billh_at_gci.net> wrote in message news:3cf6581b.6918338_at_news.gci.net...
> We have a read error which is reported when backing up with BRU,
> however it is apparently beyond the area which is used by Oracle at
> this point. It is the 2nd of two 50MB dbf files which are part of
> tablespace Prestige. I'm wondering if I can do a full export, shut
> down Oracle, rename the bad file to something else, copy the good
> file to the name of the former bad file, start Oracle, import the full
> export, then exclude the renamed bad file from the BRU backup and be
> in good shape.
>
> If that won't work because of internal structures in the .dbf files,
> what would be a better approach?
>
> Thanks!
> Bill Hutchison
> Anchorage Alaska

Question: will the database come up if you simply replace one file? No, you will force the database to recover.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address