Oracle Controlfile Typesby Ed ChenNovember 20, 2021June 13, 2023CONTROLFILE_TYPE After solving ORA-01610, you might have a question: how do I know the currently used controlfile is a BACKUP one or not? We take… Read More »Oracle Controlfile Types
How to Resolve ORA-01610: recovery using the BACKUP CONTROLFILE option must be doneby Ed ChenNovember 19, 2021June 13, 2023ORA-01610 Tried to perform RECOVER DATABASE on a mounted database by SQL statement, but it failed with ORA-01610. SQL> recover database until cancel; ORA-00283: recovery… Read More »How to Resolve ORA-01610: recovery using the BACKUP CONTROLFILE option must be done