Re: BIG PROBLEM - NEED HELP

"Sabrina" <missy2bfw_at_aol.com> wrote in message news:3f5aeb14$0$282$4d4ebb8e_at_read.news.de.uu.net...
> 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

you best go find a dba to sort it out for you Received on Sun Sep 07 2003 - 06:09:53 CDT