Re: Problem with database startup

Yes, if disk 4 is just Indexes, you can drop the tablespace and recreate the tablespace and and the indexes.

In article <6u2prb$5d2$1_at_trex.antw.online.be>,   "Patrick S" <burcht61_at_hotmail.com> wrote:
> basics : database 7.3.4 on unix aix platform
>
> There are 32 tablespaces on the database. A lot of them are on raid 5, 4
> of the most important tablespaces are on raid 1 (mirroring)
> each on another disk.
>
> disk1 : application 1 (data)
> disk2 : application 1 (index)
> disk3 : application 2 (data)
> disk4 : application 3 (index)
>
> Our unix responsible was convinced he toke a whole backup of all disks. Now
> while restoring the database he found out that there is no backup of disk4
> (there are two backups of disk3 - copy error). This is already so for a few
> months. We cannot open the database while there is a difference between the
> sequence numbers in the headers of the datafiles and the references in the
> controlfile.
>
> How can we restart the database (open). The tablespace on disk4 can be
> removed because it contains only indexes ?
>
> Patrick SOETENS
> Belgium
> burcht61_at_hotmail.com
> bf000232_at_glo.be
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Sep 21 1998 - 18:01:25 CDT