Oracle DBA, How To, Error, Cause and Action

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

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


Cause:


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.



Action:


Perform recovery using the BACKUP CONTROFILE option.

No comments:

Post a Comment

Thanks for your comment.