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 )