You'll want to place your database datafiles, online redo logs, control files, password file, and parameter file on this removable media. When you plug this removable media into a database server, that server must have the correct version of Oracle already running on it. You can then copy the parameter file to the default location, $ORACLE_HOME/dbs directory for Unix and Linux or %ORACLE_HOME%\database directory for Windows. Also copy your password file as well. Assuming the directory path to your media is the same on both servers, all you have to do is point your environment to the new database, and it should start. In Windows, you'll have to create a service with the ORADIM utility. In Unix, simply set your ORACLE_HOME, ORACLE_SID, PATH, and any other platform-specific environment variables. When you attempt to start the instance, it will read the parameter file stored in the default location. This parameter file will point to your control files on your media. These control files will point to the rest of your database files.
If the directory structure changes, then it would be a good idea to have a copy of your control file dump to a trace file. The trace file can be used to create a control file with the correct directory structure.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.