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!

ora-01610: recovery using the BACKUP CONTROLFILE option must be done.

650215Jul 15 2008 — edited Nov 17 2009

Can anyone help me with this error message? In addition to the ora-01610 message I received ora-00283: Recovery session canceled due to errors. Here are the steps I followed:

1.alter database backup controlfile to trace noresetlogs;

2.shut immediate;

3.startup nomount;

4.create controlfile from trace file...just copy paste (which is automatically comes into udump)

5.recover database;

6.alter database open

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 15 2009

Added on Jul 15 2008

#general-database-discussions

3 comments

10,632 views