I'm dealing with a problem whereby a I have a database that is managed using data guard using Redo Apply, so redo logs are copied to the target database, applied and kept in sync ready for fail over.
The target (DR) database has been offline for a while, and upon investigating found to be offline, and unable to start due to control file missing.
The original database was an exact copy, so relative file paths and name consistent with the primary database.
I have a few ideas on sorting this and wondered whether anyone can offer some experience.
1) Copy the missing control file from primary to DR server and try to start up. I'm guessing over time additional files may have been added to primary which may not be in the DR. I'm also concerned about messing up what could currently be recovered?
2) Export the current primary control file to trace > sql, and modifying to fit target database, then creating the control file using sql
3) Start again, create a new DR target.. Having not created the initial DR (data guard) setup I'm not entirely sure of how easy this is, but I know it would work at least.
Any advice welcome TIA