Originally posted by sudheer_nm
I won't be able to connect using sqlplus and it always says 'oracle shutdown in progress' and when I did the following I got 'File 2 needs media recovery error'.
You all missed an important point.. Sudheer_nm since it says "oracle shutdown in progress" abort the database. Make sure all processes connected with the database are down.

Your database is in No archive log mode so here is what you have to do.
If you've backed up your control file to trace we can get this thing recovered (if your datafile is not phyically corrupted).
Lets try this the easy way first and hopefully that will work.
1.start up the database (yea you'll get the .dbf needs recovery that's ok.
2. issue recover database
3. It's going to ask you for an archive log file. Give it the path of your first redo log file. If it doesn't work give it the next redo log file until there are no log files or your database recovers itself.

More than likely your datafile(s) have gotten out of sync and he's looking for a sequence #.

If this doesn't work then we'll have to get down and dirty with it the most important thing is if you have a control file backed up to trace we can get it recovered.