Re: Lost ofall redo logs

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

-- 
===============================================================
Ray Stell   stellr_at_vt.edu     (540) 231-4109     KE4TJC    28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: stellr_at_cns.vt.edu

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