There is the other expensive avenue of calling in Oracle and the DUL team. It depends on the criticality of the data. A few years ago a former dba here had the experience and it is said to have cost a mere $20K. Maybe the data is worth more than that.
On Wed, Sep 18, 2002 at 10:08:19PM -0800, Arun Chakrapanirao wrote: > 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" <[EMAIL PROTECTED]> > >Sent: Wednesday, September 18, 2002 5:43 PM > > > > > > > > > >>What about mirrored redo group members? > >> > >>Igor Neyman, OCP DBA > >>[EMAIL PROTECTED] > >> > >> > >> > >>----- Original Message ----- > >>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > >>Sent: Wednesday, September 18, 2002 4:30 PM > >> > >> > >>Hi people... > >> > >>What to do if I have LOST ALL REDO LOGS and i don?t have any backup? > >> > >>Thanks in advance! > >> > >>::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: > >>Gilberto Gampert Universidade de Passo Fundo > >>Administrador de Banco de Dados Passo Fundo - RS - Bra5il > >>[EMAIL PROTECTED] http://www.upf.br > >>::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: > >> > >> > >>-- > >>Please see the official ORACLE-L FAQ: http://www.orafaq.com > >>-- > >>Author: Gilberto Gampert > >> INET: [EMAIL PROTECTED] > >> > >>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > >> > >>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). -- =============================================================== Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
