Re: Failed Index Creation Recovery

From: Don Seiler <don_at_seiler.us>
Date: 18 Jun 2003 06:24:40 -0700
Message-ID: <94e86aed.0306180524.57050725@posting.google.com>

"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. Received on Wed Jun 18 2003 - 08:24:40 CDT