Re: Control files and data files

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?
>>
>>