Re: BIG PROBLEM - NEED HELP

Hi Kenneth,

I canīt start this commands in SQL because the database doesnīt start. I canīt connect to SQL.
How can I execute this commands without starting the database??

Thanks for your help!!!!
Sabrina

<Kenneth Koenraadt> schrieb im Newsbeitrag news:3f5a451e.3394621_at_news.inet.tele.dk...
> 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
>
>
>
Received on Sun Sep 07 2003 - 03:24:17 CDT