Xref: alice comp.databases.oracle.server:47261 Path: alice!news-feed.fnsi.net!hammer.uoregon.edu!logbridge.uoregon.edu!newsfeed.stanford.edu!su-news-feed4.bbnplanet.com!news.gtei.net!inet16.us.oracle.com!not-for-mail From: Pete Sharman Newsgroups: comp.databases.oracle.server Subject: Re: Is Self Recovery Possible? Date: Mon, 26 Apr 1999 09:23:12 -0700 Organization: Oracle Corporation Lines: 123 Message-ID: <372492F0.508DFB0A@us.oracle.com> References: <7fubgi$gh4$1@nnrp1.dejanews.com> <3722BB6B.5B01ECF0@mail.com> <7fujh2$njk$1@nnrp1.dejanews.com> Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="------------748117DA0DB715B46B45F764" X-Trace: inet16.us.oracle.com 925143726 4874 144.25.183.79 (26 Apr 1999 16:22:06 GMT) X-Complaints-To: usenet@inet16.us.oracle.com NNTP-Posting-Date: 26 Apr 1999 16:22:06 GMT X-Mailer: Mozilla 4.06 [en] (WinNT; U) --------------748117DA0DB715B46B45F764 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit B.R. Andrew was correct. All you should need to change in the init.ora file is the DB_NAME parameter and the CONTROL_FILES parameter. All the datafile and logfile information is kept in the control files, so if you haven't overwritten them you should be OK. Even easier if you have a backup of the init.ora file. Then just use it! HTH. Pete huntbright@my-dejanews.com wrote: > 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@mail.com>, > Andrew Babb 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@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 -- Regards Pete ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Peter Sharman Email: psharman@us.oracle.com WISE Course Development Manager Phone: +1.650.607.0109 (int'l) Worldwide Internal Services Education (650)607 0109 (local) San Francisco SQL> select standard_disclaimer, witty_remark 2 from company_requirements; Opinions are mine and do not necessarily reflect those of Oracle Corporation "Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook "Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ --------------748117DA0DB715B46B45F764 Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Pete Sharman Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: Pete Sharman n: Sharman;Pete org: Oracle Corporation adr: 500 Oracle Parkway M/S OPL-B1024;;;Redwood Shores;California;94065;USA email;internet: psharman@us.oracle.com title: Courseware Development Manager tel;work: +1.650.607.0109 tel;fax: +1.650.633.1669 x-mozilla-cpt: ;0 x-mozilla-html: FALSE version: 2.1 end: vcard --------------748117DA0DB715B46B45F764--