| Lost index file and cannot open database [message #49853] |
Thu, 14 February 2002 00:30  |
EGM
Messages: 2
Registered: February 2002
|
Junior Member |
|
|
Hello,
Due to a server fail, I have lost the file that stores indexes.
This is the scenario: Oracle 8.0.5 (Under Win2k server). I have all database files (they were in 'd:orantdatabase') but I don't have the index file ('e:orantdatabaseidx1orcl.ora').
I have instaled oracle on a new server and used the files that I still have and I can mount the database (using svrmgr30), but no to open it:
ORA-01157: cannot identify data file 5 - file not found
ORA-01110: data file: 'E:ORANTDATABASEIDX1ORCL.ORA'
I've tried 'alter database create datafile ...' but then it says that this file needs media recovery, and when I try to recover, it asks me for a file that I haven't found.
I have an sql script which creates de indexes that I need for the database.
I'm not used to oracle.
Any help is highly appretiated.
EGM
|
|
|
|
|
|
| Re: Lost index file and cannot open database [message #49858 is a reply to message #49853] |
Thu, 14 February 2002 04:52  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
1. If the database is down, mount it.
3. Offline drop the datafile.
ALTER DATABASE DATAFILE '<full_path_file_name>' OFFLINE DROP;
4. If the database is at mount point, open it.
5. Drop the index tablespace.
DROP TABLESPACE
INCLUDING CONTENTS;
6. Recreate the index tablespace.
7. Recreate all the previously existing indexes in the tablespace.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
