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).