I am attempting to recover my database and I have a problem doing that.

I tried many things and finally managed to recreate my CONTROL files from _udump_dest after using backup controlfile to trace.

when I type RECOVER DATABASE, it said that I must use backup controlfile. So, I typed

RECOVER DATABSSE USING BACKUP CONTROLFILE;

This is what I got. It asked for ARCHIVELOG ARC00049.001 but I don't find it on my system or it must have got deleted for some reason. Who knows?. It's just not there. I have ARC40008.001 and earlier. How to I recover my database without the ARCHIVELOG now, that that particular one is not there?.

spool 1.txt contents.
SQL> recover database using backup controlfile;
ORA-00279: change 6500935 generated at 03/15/2006 20:13:50 needed for thread 1
ORA-00289: suggestion : E:\ORACLE\ORA92\RDBMS\ARC00049.001
ORA-00280: change 6500935 for thread 1 is in sequence #49


Specify log: {=suggested | filename | AUTO | CANCEL}
E:\oracle\ora92\rdbms\ARC00049.001
ORA-00308: cannot open archived log 'E:\oracle\ora92\rdbms\ARC00049.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.


Specify log: {=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00308: cannot open archived log 'E:\ORACLE\ORA92\RDBMS\ARC00049.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.


ORA-00308: cannot open archived log 'E:\ORACLE\ORA92\RDBMS\ARC00049.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.


SQL> spool off
-----------------------------------------------------

Note: I am not a DBA and hence do not know much or I should say that I am learning. I do not have a backup because I have archivelogs set on. I don't mind recovering at any point right now. I just need to recover the database to open it.

I have the control files but I guess they are not in sych.

When I type alter database using backup controlfile to trace;
I got database altered.

then I typed recover database;
it says ORA-00283 recovery seesion canceled due to error
ORA-01610 recovery using backup controlfile option must be used.
And that's what was just done. This seems to send me in circles.

What is it that I need to do now to OPEN the database.