Re: Is Self Recovery Possible?

If only you'd posted this yesterday...it would have saved us a couple of hours trying to set up just a new service for an 8i database on NT.....

Ah well. At least I'll not forget next time.

--
Cheers

Steve Bright

steve.bright_at_capgemini.co.uk

Sybrand Bakker wrote in message
<925042450.12249.0.muttley.d4ee154e_at_news.demon.nl>...
>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 - 08:29:58 CDT