Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: simple (?) recovery question

Re: simple (?) recovery question

From: Rachel Carmichael <>
Date: Tue, 05 Sep 2000 09:04:03 GMT
Message-Id: <>

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?

>To: Multiple recipients of list ORACLE-L <>
>Subject: simple (?) recovery question
>Date: Mon, 04 Sep 2000 18:38:20 -0800
>Forgive my ignorance but I have only had a couple of months exposure to
>(Sybase background!):
>We are using Oracle 8i ( 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
>our user datafiles only system datafiles.....the database is considered
>non-critical and the backup routines were impeding batch
>I'm sure that situation will change from today ;-) The database is in
>Anyhow, I took the offending datafile offline (used immediate option) and
>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
>SQL Navigator was able to offer some useful log info and identified that
>large inserts were occuring on one of the tables located on this tablespace
>the time the server went down.
>I then attempted to recover the datafile (set autorecovery on) recover
># 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 :
>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],
>[2], [16], [], []
>I am assuming that the only options for recovery now are to recover the
>up to the last consistent SCN or to rebuild the datafile from scratch (I do
>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??
>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: (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

Share information about yourself, create your own public profile at Received on Tue Sep 05 2000 - 04:04:03 CDT

Original text of this message