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