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: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Wed, 06 Sep 2000 09:06:04 GMT
Message-Id: <10611.116280@fatcity.com>


Well, that's one way to ensure co-operation about backups. A bit extreme to be sure, but definitely effective :)

Glad things are resolved

>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: Re: simple (?) recovery question
>Date: Tue, 05 Sep 2000 22:17:23 -0800
>
>
>
>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
>(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 Wed Sep 06 2000 - 04:06:04 CDT

Original text of this message

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