Hi to all ,
I have a oracle server with an index2ordb.ora file of 803MB configured on a second harddisk, due unavoidable circumstances I had to format my second harddisk. When I restarted my server oracle database is not mounting and the trace file clearly indicates that the problem is due to the missing index2ordb.ora file....I don't have the password of Internal user to start the database using nomount command and recover the file....
Will the following soln. work :
(1) Copy the index1ordb.ora form disk1\orant\database to the second harddisk and then rename it to index2ordb.ora and restarting the server
(2) somehow creating a file of 803 mb file and naming it as index2ordb.ora
(3) or is there any way to connect as internal without knowing the password
Why don't you have internal password? Can you login as a member of the dba_group, do sqlplus /nolog, conn / as sysdba?
If you could log on, you could try dropping the tablespace including contents, assuming this was just an index tablespace. Then recreate it.
The only "switch and bait" file manipulation you can perform is for identical files - internally indentical files, that is, as far as Oracle is concerned, like redo log and control files. Datafiles, unless multiplexed (obviously, yours was not), no can do.