Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Recover Database with missing log files

orclrunnerOct 31 2005 — edited Nov 1 2005

I ported our production database over to the development environment. And re-created the control files to reflect the dev database name. Now when I try to start the database I get the error message: ORA--1589 must use RESETLOGS or NORESTLOGS option for database open.

Then I run: recover database using backup controlfile;

Then I receive:

ORA-00279 change xxxxxx generated at <date> needed for thread
ORA-00289 suggestion C:|oracle\ora92\rdbms\arc0611.001
ORA-00280: change xxxxxx for thread 1 is in sequence #6611
Specify log:

I have tried every log file there is and none of them contain sequence #6611

Any suggestion on how to get my database back?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 29 2005

Added on Oct 31 2005

#general-database-discussions

6 comments

3,206 views