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