| Removing reference of datafiles [message #53944] |
Fri, 18 October 2002 22:11  |
Deepak Khemani
Messages: 5
Registered: April 2002
|
Junior Member |
|
|
Hi all... I have got myself into trouble... I will brief my problem... I have a sun solaris server... the machine was upgraded with new hard disks.. I had created datafiles into it.... The hard disk were removed without my notice ... The problem now is, that i am not able to start up my database... Whenever i startup it gives
ORA-01122: database file 14 failed verification check
ORA-01110: data file 14: '/ora/ora1/app/oracle/OraHome1/oradata/probe/NDMC/ts_nd
mc02.dbf'
ORA-01251: Unknown File Header Version read for file number 14
I would like to mention here that the Database gets mounted.. I donot want to recover the datafile and I just want to reove its reference
I would appreciate if somebody could guide me to rectify this problem
Regards
|
|
|
|
|
|
| no does'nt work [message #53950 is a reply to message #53944] |
Mon, 21 October 2002 01:28  |
B
Messages: 327
Registered: August 1999
|
Senior Member |
|
|
If the database is in NOARCHIVELOG mode, you must specify the DROP clause to take a datafile offline. However, the DROP clause does not remove the datafile from the database. To do that, you must drop the tablespace in which the datafile resides. Until you do so, the datafile remains in the data dictionary with the status RECOVER or OFFLINE.
If the database is in ARCHIVELOG mode, Oracle ignores the DROP keyword.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
