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: simple (?) recovery question

RE: simple (?) recovery question

From: Glenn Travis <Glenn.Travis_at_wcom.com>
Date: Wed, 06 Sep 2000 12:24:59 -0400
Message-Id: <10611.116309@fatcity.com>


Is it really acceptable that Oracle corrupted it's own datafiles? I think there is a bigger issue and a possibly flawed product if a DBMS cannot go down (hard) and come up in a consistent state. This is rule 1.

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of
> grant.g.holyoake_at_centrelink.gov.au
> Sent: Wednesday, September 06, 2000 2:17 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: simple (?) recovery question
>
>
>
>
> SUN engineers advised the cause of the server spontaneously
> rebooting was due to
> a kernel thread's stack overflow. The size of the kernel stacks
> has since been
> increased however the legacy of the corruption was such that we
> had to rebuild
> the datafile from scratch and reload the data....good fun! Our
> developers are
> now convinced of the importance of an appropriate backup strategy and have
> graciously allowed us a 'window of opportunity' to perform
> essential backup
> routines!
>
> Thanks for the input.
>
> Regards
> Grant
>
>
>
>
> "Rachel Carmichael" <carmichr_at_hotmail.com> on 06/09/2000 01:44:40
>
> Please respond to ORACLE-L_at_fatcity.com
>
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc: (bcc: GRANT G HOLYOAKE/NSO/CSDA)
>
>
>
> You could call Oracle Support as well to see if there is
> something else you
> can do.
>
> But since you don't have backups, you don't have a clean copy of the
> datafile to start recovery from.
>
> Sounds to me like you will have to rebuild from scratch.
>
> And implement backups -- how were the backups impeding batch
> processes? and
> couldn't you take at least a once a week backup?
>
>
> >From: grant.g.holyoake_at_centrelink.gov.au
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: simple (?) recovery question
> >Date: Mon, 04 Sep 2000 18:38:20 -0800
> >
> >
> >
> >Hi,
> >
> >Forgive my ignorance but I have only had a couple of months exposure to
> >Oracle
> >(Sybase background!):
> >
> >We are using Oracle 8i (8.1.6.0.0) on Solaris 2.6.
> >
> >Situation is that yesterday afternoon around 15:30 our server
> complete with
> >Oracle instance shutdown without warning. Upon startup one of
> the (large)
> >datafiles was identified as corrupt. Unfortunately we don't
> keep backups
> >of
> >our user datafiles only system datafiles.....the database is considered
> >non-critical and the backup routines were impeding batch
> >processes....although
> >I'm sure that situation will change from today ;-) The database is in
> >ARCHIVELOG mode.
> >
> >Anyhow, I took the offending datafile offline (used immediate option) and
> >opened
> >the database to enable our developers to continue with their
> processing. A
> >dbverify of the datafile gave me very little insight into the cause of
> >corruption let alone how to fix it....are there any integrity/consistency
> >checks/fixes that can be performed on corrupt datafiles such as the dbcc
> >commands used by Sybase (dare I say that word again!!) even if they are
> >offline?
> >SQL Navigator was able to offer some useful log info and identified that
> >many
> >large inserts were occuring on one of the tables located on this
> tablespace
> >at
> >the time the server went down.
> >
> >I then attempted to recover the datafile (set autorecovery on) recover
> >datafile
> ># and the following info was displayed:
> >
> >ORA-00279: change 5741944 generated at 09/04/2000 15:25:04 needed for
> >thread 1
> >ORA-00289: suggestion :
> >/data/oracle12/app/oracle/admin/ora3/arch/arch_1_72457.arc
> >ORA-00280: change 5741944 for thread 1 is in sequence #72457
> >ORA-00283: recovery session canceled due to errors
> >ORA-00600: internal error code, arguments: [3020], [46468570], [1],
> >[72457],
> >[2], [16], [], []
> >
> >I am assuming that the only options for recovery now are to recover the
> >database
> >up to the last consistent SCN or to rebuild the datafile from
> scratch (I do
> >have
> >a copy of the ddl) and to then manually copy all the data back
> in. Is this
> >assumption correct or is/are there other options I should consider??
> >
> >TIA
> >
> >Grant
> >
> >
> >--
> >Author:
> > INET: grant.g.holyoake_at_centrelink.gov.au
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >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).
>
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.
>
> --
> Author: Rachel Carmichael
> INET: carmichr_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).
>
>
>
>
>
>
> --
> Author:
> INET: grant.g.holyoake_at_centrelink.gov.au
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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
Received on Wed Sep 06 2000 - 11:24:59 CDT

Original text of this message

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