Note: Technical Talk being moved to:

Friday, 25 September 2009

Note to Self - Move Existing Database

To move an Oracle database from one server to another ...

  • Shutdown source database.
  • Create directories on target (/oracle/SID/datafiles, /oracle/admin/SID/sysfiles, /oracle/env/dbs, /oracle/pass)
  • Copy across datafiles, tempfiles, controlfiles, pfile, spfile, password file redo logs and environment files.
  • Add an entry in /etc/oratab.
  • Modify the parameter db_domain (ALTER SYSTEM SET DB_DOMAIN=domain SCOPE=spfile)
  • Alter database rename global_name.
  • Check the parameter service_names.
  • Update oracle names.
  • Setup cron entries / scheduled tasks.