| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Lost ofall redo logsOTHER...
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
> >>>---------------------------------------------------------------------
> >>>---------------------------------------------------------------------
-- 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 Thu Sep 19 2002 - 08:48:29 CDT
 |
 |