| Unable to Open Database [message #60034] |
Mon, 12 January 2004 02:56  |
Vinny75
Messages: 44
Registered: October 2003
|
Member |
|
|
Folks,
I had to drop few tablespaces as part of a cleanup process on a Oracle 9.2 database. Its a sadbox environment to test new 9i installation. After dropping the tbs, the database refuses to open after normal shutdown. I get this error:
ERROR at line 1:
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: '/appl/oradata/dbadev/undo/undo01dbadev.dbf'
Looking at the log file I notice all the datafile are causing the same thing. What is the reselution on this? I do not have any backup on this yet coz its a sandbox to play with.
Thanks
|
|
|
|
| Re: Unable to Open Database [message #60036 is a reply to message #60034] |
Mon, 12 January 2004 03:44  |
Vinny75
Messages: 44
Registered: October 2003
|
Member |
|
|
|
This issue is resolved folks. I removed the reference of each of those files (Alter Database ...offline drop) after mounting the DB. I then opened the DB fine. Closed it clean and opened again.
|
|
|
|
| Re: Unable to Open Database [message #60043 is a reply to message #60036] |
Mon, 12 January 2004 07:08 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Hi,
Alter database datafile 'filename' offline drop;
doesnt get rid of the datafiles from the database.They will be marked with a status of 'RECOVER' or 'OFFLINE' . The only way to drop them completely is to drop the tablespaces cleanly.
If you are dropping UNDO tablespace,you should remove(modify) that reference from the init/spfile.ora
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
