Re: Lost partition containing indexes

"Donald Thompson" <dlt_at_checkmysigforemail.com> wrote in message news:Pine.LNX.4.52.0307080921050.25177_at_junior.lunanet.biz...
>
> On Tue, 8 Jul 2003, Niall Litchfield wrote:
>
> > "Donald Thompson" <dlt_at_checkmysigforemail.com> wrote in message
> > news:Pine.LNX.4.52.0307080902150.24034_at_junior.lunanet.biz...
> > > I've lost the partition containing all of the oracle indexes due to a
> > > drive failure. Is it possible to get oracle up without this and
rebuild
> > > the indexes? Anyone have pointers to docs describing how to recover
from
> > > something like this? TIA.
> >
> > Do you have a backup?
>
> I have an oracle backup, but not a filesystem backup for the indexes. I
> sort of assumed that the oracle backups just contained the data for the
> DB, not necessarily the indexes.

A valid backup and all the archive logs from that time to the time of the crash means that you can perform a recovery. This is what I was getting at. As it sounds like you have not performed a recovery before I'd strongly advise you to call Oracle support and get them to talk you through it.

On the other hand if you have *only* lost indexes (i.e. all the tables are there) then Sybrands suggestion could also make sense. you would drop the tablespaces that are unavailable, create new ones and recreate the indexes in the new tablespaces. This doesn't require backup and recovery, but you do lose all objects in those lost datafiles, so you better be sure you don't have required objects in them that cannot be recreated.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK