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

Mehmet Salih Deveci May 31, 2021 Leave a comment

I got ” ORA-01610: recovery using the BACKUP CONTROLFILE option must be done ” error in Oracle database.

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

Details of error are as follows.

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

Cause: Either:

1:  An earlier database recovery session specified BACKUP CONTROLFILE, or

2:  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 CONTROLFILE option.

Recovery using the BACKUP CONTROLFILE option must be done

This ORA-01610 error is related to the 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.

Perform recovery using the BACKUP CONTROLFILE option.

1) dump controlfile to trace

SQL> alter database backup controlfile to trace as '/home/oracle/controlfile.sql';

2) startup database nomount

SQL> startup nomount

3) create the control file

SQL> @/home/oracle/controlfile.sql
Control file created.


SQL> recover database using backup controlfile until cancel;

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1904510 generated at 12/11/2020 11:12:13 needed for thread 1
ORA-00289: suggestion : +DATA
ORA-00280: change 1904510 for thread 1 is in sequence #1453

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
+DATA/MSDB/onlinelog/group_1.224.492141654
ORA-00310: archived log contains sequence 24; sequence 1453 required
ORA-00334: archived log: '+DATA/MSDB/onlinelog/group_1.224.492141654'

Now open database resetlogs mode.

SQL> ALTER DATABASE OPEN RESETLOGS;

Database altered.

SQL>

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial

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