How do I restore a full database on a different node using cold backup.
I have seen one thread here which says the following....
Copying all the files(data/control/redo/init.ora) that constitute your 100GB database to the server you wanted and modify dbname/controlfile/archive destination parameters in init.ora and set environment variables..and start the database...in mount mode and see the locations of your files from V$control/data/logfiles and rename the file locations with new file locations. that should take care off...
My question is how do I start the database in Mount State and alter the datafile locations because I dont have the services set up on this node.
Can somebody put some more light on the setting up of the environment variable thing or point me to a thread/article which gives a step by step instructions on restoring a full cold backup on a different node.