Oracle Error :: 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.
Comments (Add Comment)
23/02/2007 19:43:33 by Aman
if your database is in noarchivelog...or you have also lost your archive file..then this is solution..
1.alter database backup controlfile to trace noresetlogs;
2.shut immediate;
3.startup nomount;
4.create controlfile from trace file...just copy paste (which is automatically comes into udump)
5.recover database;
6.alter database open
try this n leave comment ...is it working
07/03/2007 04:58:48 by Carol
This solution was perfect. Thank You.. database up and running.
05/10/2007 07:10:48 by Georg
Perfect solution from AMAN. We had an unusable CURRENT Redo-Log-File. This Redo-Log-File even blocked the system during automatic crash recovery.
17/10/2007 13:52:06 by sam
Excelent man!! Thank you
19/04/2008 21:40:03 by VERONICA
AMAN FELICITACIONES, GRACIAS A TU AYUDA PUDE RECUPERAR LA BASE DE DATOS.
28/04/2008 14:13:14 by bknox
It worked. Thank you very much Aman!
24/07/2008 21:06:56 by dschulenberg
This procedure just saved our test instance :) Thanks
28/08/2008 07:54:51 by leo
great steps....
been looking for this for ages, finally did it within 5 minutes...
had a problem understanding step 4. Actually it's just copy and paste what's inside the latest .trc file inside udump directory starting from CREATE CONTROLFILE ......
thanks so much for the guide, really helpful...
15/07/2009 11:14:26 by Martijn
Good stuff. I ran into the ORA-01113, ORA-01610 and the likes, but managed to save my database. You saved my day. Thanx.
11/08/2009 22:44:21 by Tony
I lost half a day's work but thanks to this I don't have to lose a whole day's worth of data! This solution rocks!
17/09/2009 19:15:39 by Fake
What you meant with the step 4?
06/10/2009 15:35:11 by Christine
So simple and yet so perfect. THANK YOU SO MUCH!
22/12/2009 15:09:21 by dheeraj
Hi can you please let me know the syntax for the 4th command "create controlfile from trace file". Thanks in advance.
06/02/2010 01:50:26 by Ben
I need help I'm a new DBA can anybody tell me how to create a controlfile from a trace file
06/02/2010 02:01:10 by ovey
Nice post... You are a DBA master... :)
28/02/2010 17:01:21 by Ion
Simply awesome , after googling for more than 2 hours this solution fixed my issue ....
THANKS A ZILLION !!!!!!!
26/03/2010 15:58:36 by Ranjay
Thanks alot.
This is the best solution you have given.
You are great.
Thanks
02/09/2010 19:47:42 by vivek
hi i am also following d same steps but this error occur
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
pls help me