howto reinitialize database after copying control and dbf files
Posted on 2007-11-30
Going on a trip and want to copy my 10.2.0.3 database (sid: db05) to an external hard drive. I have oracle 10.2.0.3.0 installed on my laptop's C: drive. The database is too big for the laptop so I copied the data files to an external E: drive. Originally the database and files were on a G: drive. I also copied the initdb05.ora file from the /database directory to C:/oracle/database. I have already changed the paths in that file to correctly represent the new location E:/db05.
Now I just need help with the correct steps to take to mount the data and create the database service/instance etc... I know I'll have to probably run "alter system rename...." for all the data/log/control files.