Bill I'm kinda surprised no one has replied. I'm seeing pockets of oracle work in cols most of it is short-term(ie: < 3 months).
This is the best place to find what I'd consider the brightest people in the oracle world(of course the brightest are also the most expensive) :) joe Bill Christison wrote: >Joe T., > When we'd recently posted positions to FATCITY you'd >replyed;..the economy must be getting better (based on the >job(s)posting. > Yes,I agree.However,I'd never tried posting to Fcity.I've >been placing SAS/Statisticians since 1993 and use SAS-L. > *FYI., I didn't obtain any response,other than yours.If >you've any thoughts(why)or could suggest another location to >post/to make ORACLE people aware of career alternatives,I'd >appreciate your insights, >Bill Christison >--- Joe Testa <[EMAIL PROTECTED]> wrote: > >>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). >> >>>>> >>>>> >>>>> >>>>> >=== message truncated === > > >===== >Bill Christison >Knowlton Group, LLC >845-258-5129 >www.knowltongroup.com > >__________________________________________________ >Do you Yahoo!? >New DSL Internet Access from SBC & Yahoo! >http://sbc.yahoo.com > -- 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).
