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

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>
>>
>>>>>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
>>
>>>>>gampert@upf.br http://www.upf.br
>>>>>
>>>>:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
>>>>
>>>>>
>>>>>--
>>>>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>>>>--
>>>>>Author: Gilberto Gampert
>>>>>INET: gampert_at_upf.br
>>>>>
>>>>>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).
>>
>>>>>--
>>>>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>>>>--
>>>>>Author: Igor Neyman
>>>>>INET: ineyman_at_perceptron.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).
>>
>>>>>
>>>>>
>>>>>
>>>>>
>=== 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: jtesta_at_dmc-it.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).