Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: FILE NEEDS MEDIA RECOVERY!

Re: FILE NEEDS MEDIA RECOVERY!

From: Satar <satar_at_my-dejanews.com>
Date: Tue, 09 Mar 1999 18:36:02 GMT
Message-ID: <7c3pmh$q8b$1@nnrp1.dejanews.com>


Anything in the alert file? Are you running ASYNC/IO or multiple DB writers? Could it be a cableing problem? Such as length?

Good Luck,
Satar
Oracle DBA/UNIX System Admin
"Opinions are the result of the voices in my head only, and do not reflect my employer or Oracle Corporation."

In article <erafCCaa#GA.177_at_pet.hiwaay.net>,   "Jack Jolly" <jgjolly_at_ingr.com> wrote:
> I've had the same db on the same server come up twice in the last two weeks
> with "file needs media recovery" on the same file.
>
> This is a non-archivelog db so I'm stuck going to my exports - but what is
> the root cause of this problem? No one has been doing anything funny like
> swapping control files or anything.
>
> The DB is split between internal drives and external drives - but even if
> the server had problems getting to the "external" files and the file was
> corrupt, wouldn't the db be startable - but perhaps with a "block xxx is
> corrupt" rather that a "file needs media recovery" error?
>
> I guess I'm looking for help as to what problems will result in the "file
> needs media recovery" error.
>
> Thanks!
>
> JJ

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 09 1999 - 12:36:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US