| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Lost ofall redo logs
This is very rare that one would loose every online log files for the
instance.
Hey, I don't think the advice here could be bad, it is the discretion of the user who is going to use it.
KG and/or Arun,
Anyways, I'm more interested in KG's comment about "you will have to do some more tricks to get the database up if it is crashed (read: shutdown ABORT)."
Could you please elaborate please?
Thanks,
Viral Desai.
>From: "Mercadante, Thomas F" <NDATFM_at_labor.state.ny.us>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Lost ofall redo logs
>Date: Thu, 19 Sep 2002 05:13:27 -0800
>
>I agree with you Joe.
>
>I would *never* use an undocumented parameter unless Oracle told me to (or
>unless I was testing something that I could recreate).
>
>Using these params on the advice of someone from this list is very
>dangerous.
>
>The larger question is, why are the redo logs not being backed up?
>
>Arun, you need to establish a backup policy *immediately* so that you are
>not being put into this position again.
>
>Tom Mercadante
>Oracle Certified Professional
>
>
>-----Original Message-----
>Sent: Thursday, September 19, 2002 7:48 AM
>To: Multiple recipients of list ORACLE-L
>
>
>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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Mercadante, Thomas F
> INET: NDATFM_at_labor.state.ny.us
>
>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: Viral Desai INET: viral303_at_hotmail.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).Received on Thu Sep 19 2002 - 09:48:31 CDT
 |
 |