Sorry everyone newbie question here.
I have an older 11g R2 instance that isn't used anymore. We cleared it out after the end of the year since it hadn't been used and the instance was already up and going so we used it for some temp things. Now I need to get it back to before we cleared it out.
I did not make the backups. This setup was before my time.
Anyway, I have all the DBF files and archive logs. I do not have the redo logs.
I have a CONTROL.TRC file and a CONTROLFILE.BAK.
I found the scripts that made these files and they are ALTER DATABASE BACKUP CONTROLFILE TO 'location\CONTROLFILE.BAK and ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
They were then copied off the server for long term storage. I was able to get these out of long term storage.
How do I restore from here? I shutdown the instance, moved the DBF files but I don't know how to restore the control files from what I have. I have googled and a lot of people talk about making these but not about restoring from them. As far as I can tell I don't have an RMAN catalog or if I do I don't know anything about it.
On a side note, I really only need data from one of the DBF files so if someone has a better suggestion I'm all ears.
Thanks