Oracle 10g: How to create a log file if lost?
1 - Now you are facing a problem that the db doesn't open
2 - log on the db as sysdba
sqlplus / as sysdba
3 - alter database clear logfile group (number of the lost group file);
alter database clear logfile group 2;
4 - open the database
alter database open;