I want to recover a database where I have lost the redo logs. The database is in archivelog mode and I have the appropriate archived logs. However, I have lost all my online redo logs. In addition, I have lost the binary copy of my control file, but I have the CREATE CONTROLFILE statement from a "backup controlfile to trace" command.
I know I'll have to do an incomplete recovery through the last archived redo log, which is fine. However, I can't create the control file because my CREATE CONTROLFILE statement contains entries for the online redo logs which are missing. What's the best way to proceed?
This is just an excersise.