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