Failed Index Creation Recovery

Hi Don,

when you finish installing 9201 on your HP box, patch it to 9203 - save yourself some grief.

Cheers,
Norman.

PS. Then do the same for Linux :o)

--
-----------------------------------------------------------------
Norman Dunbar (at home on Linux)
Oracle_at_mssqlBountifulSolutions.co.uk

(Delete a Microsoft database name to reply - clue, mssql !)
-----------------------------------------------------------------

-----Original Message-----
From: don_at_seiler.us (Don Seiler) [mailto:don_at_seiler.us]
Posted At: Wednesday, June 18, 2003 2:25 PM
Posted To: server
Conversation: Failed Index Creation Recovery
Subject: Re: Failed Index Creation Recovery


"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:<vev69ntjgf0819_at_corp.supernews.com>...


> At least you could have created the index using the nologging

attribute.


> There would have been no archive logs during creation and no

archivelogs


> during rollback.


Oracle 7.3.4 has UNRECOVERABLE instead of NOLOGGING.  Either way I
wasn't aware of it until about 3 days into the build.  Needless to say
it is in my script for round 2.



> You would guess the progression of the rollback can be monitored using

> v$rollstat.


Thanks I'll look into this.



> But above all, you should either get rid of the prehistoric version of

> Oracle, or quit your job and, like the wizard Catweazle, travel to the

> current milennium with a current version of Oracle


The second half of this year is dedicated to upgrading to Oracle 9i
(probably 9.2.0.1) for HP-UX.  Then when that settles we'll be
migrating from HP-UX to Linux.