Oracle Recovery - Please Help

Fellow Oracle DBAs,

I have a problem. I don't have the log file I need to recover my database. I have tried to apply the log1orcl.ora and log2orcl.ora files (default WinNT install), but they have newer transactions than the one I need. I do not have a backup which would have the log entry (error at 7:15 this morning).

I do know that the information that is in the rollback segment that is corrupted is not needed, but I don't know what I need to do to bring the database back up.

Is there some way to dump the rollbakc file and bring up the database. I can afford to loose the information, but I cannot afford to have the DB down much longer... Any help would be MUCH appreciated.

I am running Oracle 7.1.3.3.13 under Windows NT 3.51. The following is an example session with SQL*DBA which shows how oracle handles my recover directive.

• Start SQL*DBA Session ----------- SQLDBA> connect internal/*** Connected. SQLDBA> startup mount oracle ORACLE instance started. Database mounted. SQLDBA> alter database recover automatic; ORA-00279: Change 725298 generated at 06/10/96 07:05:48 needed for thread 1 ORA-00289: Suggestion : C:\ORANT\RDBMS71\ARC08506.001 ORA-00280: Change 725298 for thread 1 is in sequence #8506 ORA-00278: Logfile 'C:\ORANT\RDBMS71\ARC08506.001' no longer needed for this rec overy ORA-00308: cannot open archived log 'C:\ORANT\RDBMS71\ARC08506.001' ORA-09202: sfifi: error identifying file OSD-04002: unable to open file (OS 2) SQLDBA>
• End SQL*DBA Session -----------

Thanks!

Shan Hemphill Received on Mon Jun 10 1996 - 00:00:00 CEST