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: Job postings was:Re: Lost ofall redo logsOTHER...

Re: Job postings was:Re: Lost ofall redo logsOTHER...

From: Bill Christison <knowltongroup_at_yahoo.com>
Date: Fri, 20 Sep 2002 06:23:43 -0800
Message-ID: <F001.004D4DA3.20020920062343@fatcity.com>


JT.,

   Do you have any awareness of www.ORAFAQ.net Oracle-job.net? Thanx,
Bill
--- Joe Testa <jtesta_at_dmc-it.com> 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 <jtesta_at_dmc-it.com> 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"
> >>>>
> >><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>
> >>
>

=== 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: knowltongroup_at_yahoo.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).
Received on Fri Sep 20 2002 - 09:23:43 CDT

Original text of this message

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