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:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
