Re: sqldba startup problem

Noorazmi Abdul-Aziz wrote:

> I've dropped a project using 'drop user dbname cascade' and manually
> deleted all the associated files. In sqldba (oracle 7.2) I tried to
> shutdown the instance but got an error message, so I used shutdown
> abort
> instead. Now I cannot startup my instance at all.
>
> >startup
> ORACLE instance started.
> Database mounted.
> ORA-01122: database file 9 failed verification check
> ORA-01110: data file 9:
> '..<snipped>../db/DBNAME_INDEX'
> Attempting to dismount database........Database dismounted.
> Attempting to shutdown instance........ORACLE instance shut down.
>
> Any help is highly appreciated.
>
> Noorazmi Abdul-Aziz
> azmi_aziz_at_hotmail.com

  DROP USER CASECADE deletes all the schema objects, but not tablespaces, so you were to perform DROP TABLESPACE before deleting the files. Since you've not done that you have a corrupt database structure now, so you are to re-create the controlfile, which is not an easy task unless you've preformed BACKUP CONTROLFILE TO TRACE before.

--
Vitaly Sikolenko                  Senior Sales Consultant
                                  Server & Gateways
ORACLE C.I.S.
Moscow Russia                      E-mail: vsikolen_at_ru.oracle.com

The statements and opinions expressed here are my own and do not
necessarily represent those of Oracle Corporation.