Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Lost ofall redo logs

RE: Lost ofall redo logs

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Fri, 20 Sep 2002 05:48:26 -0800
Message-ID: <F001.004D4BFF.20020920054826@fatcity.com>


Well, it didn't sound like he was using Rman (which does not backup redo logs). So I assumed that he was/should be using a cold-backup strategy - which, if it were me, would backup the redo logs.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Friday, September 20, 2002 8:48 AM To: Multiple recipients of list ORACLE-L

Tom, that statement will open a can of worms(like a religion following) about if/when to backup redo logs. :)

joe

Mercadante, Thomas F wrote:

>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).
Received on Fri Sep 20 2002 - 08:48:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US