Oracle start up problem

[sfdba]

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


please help

Regards
Sfdba

[Mr.Hanky]

I do believe the correct technical term for your current situation is "FAWKED!".

Got Backup?

MH

[stecal]

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.

[OracleDoc]

Originally posted by Mr.Hanky
I do believe the correct technical term for your current situation is "FAWKED!".

Just like a football bat Or soup sandwich in your case. Either way tis` not good.

[sfdba]

...hey but there must be certainly a way to retrieve the Internal password or recreate the password...pls help

[stecal]

SQL> startup mount
SQL> alter database datafile 
  2 'D:\ORACLE\ORADATA\DB00\INDX01.DBF' 
  3  offline drop;

Database altered.

SQL> alter database open;

Database altered.

SQL> drop tablespace indx including contents;

Tablespace dropped.

Wait!! Son-of-a-biscuit-eater! That was my index tablespace I just trashed.

[stecal]

Originally posted by sfdba
...hey but there must be certainly a way to retrieve the Internal password or recreate the password...pls help

Look up orapwd.

[SANJAY_G]

Originally posted by sfdba
...hey but there must be certainly a way to retrieve the Internal password or recreate the password...pls help

You can recreate the passwordfile using orapwd utility.
For more information on similar issues go throught this.
http://metalink.oracle.com/metalink/...&p_id=185703.1

[stecal]

Originally posted by stecal
Look up orapwd.

Should I use my power of invisibility for good or evil?

[sfdba]

I don't have a metalink ID, can anyone email me the article as advised by SANJAY_G
email id is : adamsb@indiatimes.com