Re: BIG PROBLEM - NEED HELP

On Sat, 6 Sep 2003 22:05:51 +0200, "Sabrina" <missy2bfw_at_aol.com> wrote:

>Hi everybody,
>
>I tried to start my database and get following error:
>
>*** SESSION ID:(2.1) 2003-09-06 21:49:14.344
>ORA-01157: cannot identify/lock data file 8 - see DBWR trace file
>ORA-01110: data file 8: 'F:\DB STORAGE\USER1TREASURY01.ORA'
>ORA-27048: skgfifi: file header information is invalid
>OSD-04004: invalid file-header
>ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
>ORA-01110: data file 9: 'F:\DB STORAGE\USER1TREASURY02.ORA'
>ORA-27041: unable to open file
>
>The files "user1treasury01 and 02 doesnīt exist. What can I do to start the
>database?
>ITīS VERY URGENT
>
>Thanks for your help!
>Sabrina
>
>

Hi Sabrina,

To start/open the database here and now (assumes 8i or higher):

sql>alter database datafile 'F:\DB STORAGE\USER1TREASURY01.ORA' offline drop;
sql>alter database datafile 'F:\DB STORAGE\USER1TREASURY02.ORA' offline drop;
sql>alter database open;

The tablespace containing the 2 datafiles will of course be unavailable.

Rather than opening the database and expose it to more accidents you should find out what has happened to the 2 files and initiate a complete recovery.

• Kenneth Koenraadt