-
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
-
Canot open oracle database
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;
Jeff Hunter
-
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...
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|