| ORA-01157: cannot identify/lock data file 9 - see DBWR trace file [message #51542] |
Wed, 29 May 2002 14:00  |
Oranewbie
Messages: 2
Registered: March 2001
|
Junior Member |
|
|
Deleted/removed the database RW61_DEMO_CATALOG01.dbf manually from explorer and now cannot start any other database. Keep receiving the following error in trying to start the database:
SVRMGR> startup pfile=D:ora8idatabaseinitRW7X.ora
ORACLE instance started.
Total System Global Area 188237852 bytes
Fixed Size 75804 bytes
Variable Size 67375104 bytes
Database Buffers 120709120 bytes
Redo Buffers 77824 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
ORA-01110: data file 9: 'D:ORA8IORADATARW7XRW61_DEMO_CATALOG01RW61_DEMO_CAT
ALOG01.DBF'
Can someone please assist in removing the reference to rw61_demo_catalog01.dbf ?
|
|
|
|
| Re: ORA-01157: cannot identify/lock data file 9 - see DBWR trace file [message #51553 is a reply to message #51542] |
Thu, 30 May 2002 05:07  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
You cannot delete a file from the database without telling the database first. Each data file is associated with a tablespace. You first take the tablespace offline then remove the tablespace from the DB. Then you use explorer to delete the associated data file.
You have two options. Restore your database from backup and recover to the point in time you deleted the file or call Oracle Support and have them walk you through the steps to get you back up without a recover if you do not need the tablespace or data file.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
