Return-path: Envelope-to: oracle-l@orafaq.net Delivery-date: Thu, 19 Sep 2002 19:23:10 +0800 Received: from newsfeed.cts.com ([209.68.248.164]) by jean.onefuse.com with esmtp (Exim 3.36 #1) id 17rzOn-0008QT-00 for oracle-l@orafaq.net; Thu, 19 Sep 2002 19:23:09 +0800 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id EAA14448; Thu, 19 Sep 2002 04:22:49 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 004D3657; Thu, 19 Sep 2002 03:48:26 -0800 Message-ID: Date: Thu, 19 Sep 2002 03:48:26 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Joe Testa Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Joe Testa Subject: Re: Lost ofall redo logs Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit KG, doesn't anyone think not having a backup is a bad thing. You can go down that route if you wish but as I remember undocumented parameters are best used with the assistance of OWS and not just used at will. joe K Gopalakrishnan wrote: >Arun: > >You are right. The original poster *clearly* said > >LOST ALL REDO LOGS >NO BACKUP. > >In the above situation, you have to open the >databases using the some special tricks and >I don't think you need to go back and refer >BAckup and Recovery Manuals (You can not >find anything for this situation, that is >another story) > >Those parameters will bring up the database >if the database is cleanly shudowned (read: >Shutdown Normal/Immediate) and you will >have to do some more tricks to get the >database up if it is crashed (read: shutdown >ABORT). > >I don't think it is a bad advice.. > >YMMV > >KG > > >-----Original Message----- >Chakrapanirao >Sent: Wednesday, September 18, 2002 11:08 PM >To: Multiple recipients of list ORACLE-L > > >Well one I do want to make clear I have never tried to give bad advice to >people. >Since the user in his mail had said that he does not have a backup and does >not have any online redo logs can you please let me know how else can he >open the database, when he said he does not have a back it assumes that he >does not have a os backup and also the rman backup. >This might be the undocumented thing but this Is the only way it works >And this had happened in one our case and the only way we could open the >database is to force open the database in a corrupt mode take an export and >import back into the new database. > >If you still think I am trying to give a bad advice well sorry that I am >giving bad advices. > > >-----Original Message----- >Sent: Thursday, September 19, 2002 12:33 AM >To: Multiple recipients of list ORACLE-L > >Arun, since WHEN has been using undocumented parameters the normal way >of doing things, I think you need to go back and lookup backup/recovery >concepts. > >Feel free to read both user managed and RMAN backup recovery docs/scenarios. > >You are giving bad advice to people on the list who might be new. > >joe > > >Arun Chakrapanirao wrote: > > > >>The only way u can open your database is to add a parameter file >>as >> >>_allow_resetlogs_corruption=TRUE >> >>_corrupted_rollback_segments= TRUE >> >>_offline_rollback_segments=(the rollback segment names) >> >>activate the database and then immediately take an export of the whole >>database. >>Create a new database and then import all the data to this new database. >> >> >>-----Original Message----- >>Sent: Wednesday, September 18, 2002 5:23 PM >>To: Multiple recipients of list ORACLE-L >> >>Nop, all redo logs gone away... >> >>----- Original Message ----- >>To: "Multiple recipients of list ORACLE-L" >>Sent: Wednesday, September 18, 2002 5:43 PM >> >> >> >> >> >> >>>What about mirrored redo group members? >>> >>>Igor Neyman, OCP DBA >>>ineyman@perceptron.com >>> >>> >>> >>>----- Original Message ----- >>>To: "Multiple recipients of list ORACLE-L" >>>Sent: Wednesday, September 18, 2002 4:30 PM >>> >>> >>>Hi people... >>> >>>What to do if I have LOST ALL REDO LOGS and i don4t have any backup? >>> >>>Thanks in advance! >>> >>>::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: >>>Gilberto Gampert Universidade de Passo Fundo >>>Administrador de Banco de Dados Passo Fundo - RS - Bra5il >>>gampert@upf.br http://www.upf.br >>>::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: >>> >>> >>>-- >>>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>>-- >>>Author: Gilberto Gampert >>> INET: gampert@upf.br >>> >>>Fat City Network Services -- 858-538-5051 http://www.fatcity.com >>>San Diego, California -- Mailing list and web hosting services >>>--------------------------------------------------------------------- >>>To REMOVE yourself from this mailing list, send an E-Mail message >>>to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in >>>the message BODY, include a line containing: UNSUB ORACLE-L >>>(or the name of mailing list you want to be removed from). You may >>>also send the HELP command for other information (like subscribing). >>> >>>-- >>>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>>-- >>>Author: Igor Neyman >>> INET: ineyman@perceptron.com >>> >>>Fat City Network Services -- 858-538-5051 http://www.fatcity.com >>>San Diego, California -- Mailing list and web hosting services >>>--------------------------------------------------------------------- >>>To REMOVE yourself from this mailing list, send an E-Mail message >>>to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in >>>the message BODY, include a line containing: UNSUB ORACLE-L >>>(or the name of mailing list you want to be removed from). You may >>>also send the HELP command for other information (like subscribing). >>> >>> >>> >>> >>> >> >> >> > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Joe Testa > INET: jtesta@dmc-it.com > >Fat City Network Services -- 858-538-5051 http://www.fatcity.com >San Diego, California -- Mailing list and web hosting services >--------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Arun Chakrapanirao > INET: ArunC@1800FLOWERS.com > >Fat City Network Services -- 858-538-5051 http://www.fatcity.com >San Diego, California -- Mailing list and web hosting services >--------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: jtesta@dmc-it.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).