the corruption looks to be bad archived logs -- you'd get a message to
the effect that the database doesn't need recovery if the logs were
okay after you opened normal
Rule 0 in Rachel's Recovery cookbook:
ALWAYS back up what you have right now before you attempt anything, so
if what you try doesn't work, you can go back to the same place and try
something different.
yes, this adds additional time to the recovery process. And most times,
it's unnecessary, the recovery is fairly simplistic and you are fine
and don't need that backup. And then there's times like this one.
Which is why, when I present on backup and recovery, I talk about being
the sort of person who wants to wear a belt, have elastic in my
waistband AND wear suspenders (braces for you non-American types, I
learned the hard way not to say 'suspenders' to Europeans :) )
Rachel
- "Baker, Barbara" <bakerb_at_rockymountainnews.com> wrote:
> Doh!
> Your message came minutes after I'd already opened the database.
> When I attempt the recovery I get the message
> SVRMGR> recover database until cancel using backup controlfile;
> ORA-00279: change 278038264 generated at 11/01/01 01:28:13 needed
> for thread 1
> ORA-00289: suggestion :
> /u14/oradata/ent/arch/arch.logentarch16551.dbf
> ORA-00280: change 278038264 for thread 1 is in sequence #16551
> ORA-00283: recovery session canceled due to errors
> ORA-00356: inconsistent lengths in change description
> ORA-00353: log corruption near block 225 change 29240139592704 time
> 10/31/01 01:
>
> Do you think this is because I did indeed already open the database
> normally? Or do you think it's cuz I really do have bad archive
> files??
>
> Thanks for your response.
> Much appreciated.
> Barb
>
> > ----------
> > From: Paul Drake[SMTP:paled_at_home.com]
> > Reply To: ORACLE-L_at_fatcity.com
> > Sent: Thursday, November 01, 2001 1:05 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: recover on different hardware
> >
> > otn - http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > this site really sucks bad - half the links are broken. wtf?
> > its 8.1.6 that's off of correction, not 8.1.7.
> > my copy of 8i Backup recovery handbook is at the office, and the
> docs
> > are not available online.
> >
> >
> > most important:
> > don't open the database normally after the restore
> >
> > startup mount exclusive
> > <offline drop any datafiles that didn't make it to/from tape>
> > <have all archived redo on disk in the log_archive_dest location>
> > set autorecovery on
> > recover database until cancel using backup controlfile;
> > cancel
> > alter database open resetlogs
> > shutdown
> > cold backup
> >
> > note: apparently, any read-only tablespaces should be offline while
> > recovering using a backup controlfile.
> > I had never heard of this, but stumbled across it while perusing
> the
> > docs.
> >
> >
> > "Baker, Barbara" wrote:
> > >
> > > Been here 18 hours. No database. Looks grim.
> > > Hardware blew chunks. Major ugly.
> > > Plan is to reconstruct entire system on new hardware.
> > > If I get my dbf files from last night's cold backup (as well as
> all my
> > > config files), I should have a database that looks just like last
> night
> > at
> > > 11:00 pm.
> > > DB should come up clean, should think it's a happy camper.
> > >
> > > I do have most of my archived redo logs from today. What
> recovery
> > option do
> > > I use to start applying the redo logs I've been able to salvage?
> (Guess
> > I'm
> > > confused cuz the database will not think it needs recovery.)
> > >
> > > I'm about to RTFM, but I'm a bit bleary-eyed.
> > > Any assistance greatly appreciated.
> > >
> > > Thanks!
> > > Barb
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Baker, Barbara
> > > INET: bakerb_at_rockymountainnews.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).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Paul Drake
> > INET: paled_at_home.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).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Baker, Barbara
> INET: bakerb_at_rockymountainnews.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).
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.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).
Received on Thu Nov 01 2001 - 07:39:03 CST
