Re: Is Self Recovery Possible?

You don't specify which platform and version you are on. If this is any Unix port, make sure the /etc/oratab is correct (/var/opt/oracle/oratab on Solaris), run oraenv to point to the instance, and it should startup.

If this is NT, you need to create a new service only. You should use the oradimxx utility in command line mode (Note: this is very important, as this won't create a new database) to recreate the service. General syntax (and from the top of my head): oradimxx -new -sid <database sid> -password <password of the internal user> -pfile <location of init.ora> -startmode <srvc,inst>

Hth,

Sybrand Bakker, Oracle DBA
huntbright_at_my-dejanews.com wrote in message <7fujh2$njk$1_at_nnrp1.dejanews.com>...
>Hello,
>
>In fact I had tried like you said but failed, the point is I have to create
a
>new instance specifying the init file (this is no problem and the control
>files' location are included in it) and the redo logs and data files. I
don't
>know if I have to specify all of these parameters precisely because
there're
>quite a lot of datafiles and redo logs to specify if I need to do, and said
by
>the documentation if I create a new instance using "reuse controlfiles"
then
>the control files will be overwritten, will this be a problem? All I want
to
>know is how to create this new instance successfully and make the previous
>controlfiles and all others files used by the new instance. Can you help on
>this?
>
>B.R.
>
>In article <3722BB6B.5B01ECF0_at_mail.com>,
> Andrew Babb <andrewb_at_mail.com> wrote:
>> If you have all the control files, datafiles and on line redo log files,
all
>you
>> need to do is change the init.ora file to have the correct db_name, and
the
>> control_files parameter pointing to the control files. After this, the
>database
>> should start without any problems. If, as you say, you did not loose any
>Oracle
>> data files, all that Oracle will do is Crash Recovery.
>>
>> Andrew
>>
>> huntbright_at_my-dejanews.com wrote:
>>
>> > Hello,
>> >
>> > OS and Oracle crashed due to disk permanent failure, but all the
>> > controlfiles, datafiles, redo logs and init file are fine since they
were
>> > stored on other disks. I've reinstalled OS and Oracle, now the
challenge is
>> > how to make the new Oracle recoganize previous files to recover the
>database.
>> > There's no backup at all. I'm considering startup a new database and
replace
>> > it with previous files but I'm not sure. Is it possible for Oracle to
do
>such
>> > a "self-recovery"? Or, can I use the saved previous files as the backup
and
>> > do recovery from them? Please help me out of this issue.
>> >
>> > B.R.
>> > Hunt
>> >
>> > -----------== Posted via Deja News, The Discussion Network ==----------
>> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>>
>>
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sun Apr 25 1999 - 07:11:38 CDT