From: Vitaly Sikolenko Subject: Re: sqldba startup problem Date: 1997/08/08 Message-ID: <33EB1C0E.24A62D5C@ru.oracle.com>#1/1 References: <33DFB3B7.57A9@kuala-lumpur.geoquest.slb.com> To: Noorazmi Abdul-Aziz X-Priority: 3 (Normal) Organization: Oracle C.I.S. Reply-To: vsikolen@ru.oracle.com Newsgroups: comp.databases.oracle.server 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: > '..../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@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@ru.oracle.com The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation.