Re: Control files and data files

Hi again,.

    I need to recover the database for getting the datas in it otherwise, i'll have to reenter all datas...

    The following is what i did with the error message:

    I did what some of you suggested me, i copied all the control files and the configuration files

    like listener.ora, tnsnames.ora, .... and so on.

    Now after a reformat and a creation of the same database, i have no problem to access it,

    when i replace the control files and the configurations files by copying them and i try to access

    the database, i receive this error: ORA-01033: ORACLE initialization or shutdown in progress

    I'm using Oracle 9i on W2K SP2.

    Thanks in advance!

Ban Spam <ban-spam_at_operamail.com> wrote in message news:Xns9274BB5BAAB81SunnySD_at_68.6.19.6...
> "Yanick Hudon" <yannik_at_sympatico.ca> wrote in
> news:5eU99.11347$sY3.2121631_at_news20.bellglobal.com:
>
> > Hi all,
> >
> > I'm trying to recover a database. Until here, all the information
> > i've
> > got for those procedures is that you can
> > recover a database with a cold or hot backup of the datafiles.
> >
> > Now, my question is: What about the database recovery without any
> > backups (hot or cold) while i still
> > have the old control files and datafiles and what's the meaning of
> > each
> > one like control01, control02..
> > system01.dbf, users.dbf... and so on and what's th eprocedure to
> > perform
> > a recover??
> >
> > Thanks in advance!
> >
> >
> >
>
> HUH?
>
> Why do you think you need to "recover" the database at all?
>
> What are the specific & exact error message(s) you are getting?
>
> What evrsion of Oracle?
> Which OS & what version?
>
Received on Sat Aug 24 2002 - 23:20:33 CDT