JT., Do you have any awareness of www.ORAFAQ.com Oracle-job.net? Thanx, Bill --- Joe Testa <[EMAIL PROTECTED]> wrote: > 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]> > >> > === 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: Bill Christison 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).
