| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: recover on different hardware
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).Received on Thu Nov 01 2001 - 03:23:38 CST
 |
 |