| datafile missing [message #53701] |
Sun, 06 October 2002 16:06  |
Lesley
Messages: 2
Registered: October 2001
|
Junior Member |
|
|
this is the problem:
I have a tablespace with 9 datafiles, each 8G in size.
I add a datafile, number 10, with size 2G.
By accident the datafile is removed from disk, the datafile exist still in the database.
It gives in Oracle the state RECOVER.
Is there a way to get rid of the datafile in Oracle ? The datafile is not on disk anymore.
Is restore of the tablespace the only option or are there other options available ??
Please let me know.
Thanks in advance.
|
|
|
|
| Re: datafile missing [message #53706 is a reply to message #53701] |
Sun, 06 October 2002 22:15  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Are you running in archivelog mode? If so then you can use:
ALTER DATABASE DATAFILE "datafile name" OFFLINE DROP;
or
ALTER DATABASE DATAFILE "datafile name" OFFLINE;
Both will allow you to open your database and then recover the tablespace.
Once you take the datafile offline, Oracle will no longer attempts to access it. But will consider it part of the tablespace. So the only one choice to get your data back is to recover that tablespace.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
