Re: Urgent DBA question

From: Jerry Gitomer <jgitomer_at_p3.net>
Date: 1997/10/31
Message-ID: <34598266.7C2C@p3.net>#1/1

Victor,

Sorry to say that it probably unrecoverable. You will have to delete the datafile in order to start up Oracle. What you will have to do is start up either SQL*DBA or SVRMGR (depending on what version of Oracle you are running) and then connect as internal, start up the database (if I remember correctly you want to mount but not open) and then issue the following:

"ALTER DATABASE 'filename' OFFLINE DROP;"

This will eliminate the corrupt file and allow you to open the database. I hope this helps.

Jerry

Victor Slootsky wrote:
>
> Data file was corrupted and can't be restored.
> The datafile size does not match the size specified in the control file.
>
> Startup does not go.
> What is the way around?
Received on Fri Oct 31 1997 - 00:00:00 CST