OraFAQ Forum: Backup & Recovery » Oracle in Starting (9i)

Home » RDBMS Server » Backup & Recovery » Oracle in Starting (9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle in Starting (9i) [message #144747]

Fri, 28 October 2005 00:36

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

Hi

I delete a datafile of a tablespace manually (I don’t need my database any more so delete a heavy datafile in a tablespace). No my database is not connecting. And giving the following errors.

Command prompt
ORA-01157 : cant identify / lock datafile 11 – see DBWR trace file.
ORA-01110 : data file 11 : ‘file path and name’

OEM
ORA-12560: TNS protocol adopter error.

Note:- I don’t want my data back at all. I need Oracle for a new database. Can some one please tell me how to start oracle now? + can some one tell me how to cleanly uninstall my entire old database.

Wishes
Jawad

Report message to a moderator

Re: Oracle in Starting (9i) [message #144786 is a reply to message #144747]

Fri, 28 October 2005 04:31

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Try the following:

SQL> ALTER DATABASE DATAFILE 11 OFFLINE DROP;
SQL> DROP TABLESPACE ... INCLUDING CONTENTS AND DATAFILES;

Best regards.

Frank

Report message to a moderator

Previous Topic:	remove RMAN contents
Next Topic:	Steps to created Stand By server ...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 08:30:15 CDT 2024