If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Thans for your input. I tried recreating the controlefiles. Now when I try to open the database I get:
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'E:\ORACLE\ORADATA\TRAIN1\SYSTEM01.DBF'

U need to perform a media recovery.
Issue the following statements from SQL.
1.Shutdown immediate.
2.Startup mount
3.SELECT member FROM v$log l, v$logfile f WHERE l.group# = f.group# AND l.status = 'CURRENT';
4.Recover database until cancel;
5.Apply the log member from step 3.
6.Alter database open resetlogs;
Once ur database is succssefully open then take immediate system backup.

Really it is bad that if the database is no archive mode u have a few option.

Do as following

1.Mount the database
2. SELECT V1.GROUP#, MEMBER, SEQUENCE#, FIRST_CHANGE#
FROM V$LOG V1, V$LOGFILE V2
WHERE V1.GROUP# = V2.GROUP# ;
This will list all the redo log files and their change numbers.
3. SELECT FILE#, CHANGE# FROM V$RECOVER_FILE;
If the CHANGE# is GREATER than the minimum FIRST_CHANGE#
of your logs, the datafile can be recovered.
4.Recover datafile 'E:\ORACLE\ORADATA\TRAIN1\SYSTEM01.DBF';
5.keep on applying the redo logs it will request to aplly until u will see the message 'Media recovery complete'.
5.Then open database and take a full backup.

It's exactly what Iam saying. I recover all the datafiles. When I attempt to open the database, I get SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced.