Re: Lost ofall redo logs

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" <ORACLE-L_at_fatcity.com>
>Sent: Wednesday, September 18, 2002 5:43 PM
>
>
>
>
>>What about mirrored redo group members?
>>
>>Igor Neyman, OCP DBA
>>ineyman_at_perceptron.com
>>
>>
>>
>>----- Original Message -----
>>To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>>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
>>gampert@upf.br http://www.upf.br
>>:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
>>
>>
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>--
>>Author: Gilberto Gampert
>> INET: gampert_at_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_at_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_at_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_at_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_at_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_at_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).