Re: Control files and data files

Hi,

    thank for the advice, I finally succeed.

    Look at the other post i've made...

    Thanks.

Svend Jensen <svend.jensen_at_it.dk> wrote in message news:3D68D313.3020206_at_it.dk...
> You must be kidding or you are in deep s...
> seems you aint got a clue.
>
> Oracle can recover from almost any scenario, except out of blue air -
> no 'old' datafiles copies (hot or cold) nor exports nor archived logs
> => no recovery. Suggest you do some homework by reading some stuff on
> backup and recovery. No matter what, you can only gain.
>
> rgds
>
> Yanick Hudon wrote:
>
> > 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 Sun Aug 25 2002 - 11:59:06 CDT