I am using Oracle 10g on Linux
We have a live 2 node RAC instance and we do have a DR instance located at a different place . Now the DR instance is a single instance database and the backups of RAC instance are shipped to the DR node through snapshots ( NetApp) . The backup would consist of redo logs , archived logs , datafiles , parameter files , control files and the password files.
Now when a media failure happens at live site I need to get the DR database running but I dont know how to convert the RAC database into a single instance database?
Since we would be having a list of redo logs , undo tablespace for the other instance and these might be required when we recover the database in the DR site but since it is a single instance database I can use redo logs , undo tablespaces of only one instance ? Am I correct ? Let me know how to tackle this issue ?