Cannot recover database 9i to OPEN

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.

you cant recover past that point if you dont have that archive log, if your datafiles / control file are in sync then you can open resetlogs

Dave,

I don't mind recovering mt DB at ANY POINT right now.
What I want to know is this. I recreated the control files from the dump file script. When recreating the control files, does it update the database files?.

All that has happened is that I cannot open the database.

Does that mean that my database is gone for ever?.

Right now, when I start, the database starts and mounts.

When I try to open, it says in Enterprise Manager, you should open with resetlogs. I say OK.

Then it gives me an error : ORA-01152 file 11 was not restored from a sufficiently old backup.

ORA-01110: data file 11; 'F:\opapps\octrn\ocl_app.dbf'

turn it back around - why did you do what you did?

sounds like you are shafted

did you try:

recover database until cancel;

then type cancel press enter and:

alter database open resetlogs

RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;

but the logs are missing, that will be no good

I'm assuming ARC40008.001 is the last log archived. You'd have to verify from your alert.log, though...