Re: Lost ofall redo logs

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" <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 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_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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Arun Chakrapanirao
> INET: ArunC_at_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_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).