Expand To Show Full Article
Oracle Error ORA-01610: recovery using the BACKUP CONTROLFILE option must be done - Developer Publish

Oracle Error ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

Oracle Error Message

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

Reason for the Error

Either an earlier database recovery session specified BACKUP CONTROLFILE, or the control file was recreated with the RESETLOGS option, or the control file being used is a backup control file. After that only BACKUP CONTROLFILE recovery is allowed and it must be followed by a log reset at the next database open.

Solution

Perform recovery using the BACKUP CONTROFILE option.