Follow

Moving Oracle Data via Cold Backup and Restore

Created by: Nate Oleson
Created date:
Last Updated date:

Problem

The Oracle data for an FTK or eDiscovery installation needs to be moved to a new host system (or restored to a system).

 

Resolution

Pre-reqs:

Before attempting any changes or moving any data, it is important to note that this method REQUIRES the system have the following attributes:

The system to which the Oracle data is being restored MUST:

  1. Have the exact same system HOSTNAME as the original Oracle database host.
  2. The Oracle data folder must be restored to a drive that has the same drive letter as the drive originally hosting the Oracle data.
  3. Use the same version of Oracle Enterprise Server 10.2.0.x from the same installation media as the original install.

Procedure to Create Cold Backup of Oracle Data :

  1. On the original (existing) Oracle host system, note down or identify any and all file system folders to which Oracle is configured to save data files (aka "Oracle Home" folder).  For installations using AccessData's Oracle install disk, the Oracle home folder by default will be:

    "[DRIVE]:\Oracle\"

    By default, the Oracle data files are stored at:

    "[DRIVE]:\Oracle\Product\10.2.0\oradata\FTK2\DATAFILE"

  2. Cleanly stop Oracle services.  

    In other words do not force shutdown, end task, or kill Oracle services.  You may want to use sqlplus to execute "shutdown immediate" which will allow Oracle to stop cleanly.

  3. Make a copy of "Oracle home" folder(s) noted in step 1.  Typically it is recommended to copy the "Oracle" folder at "[DRIVE]:\Oracle\".

    In some non-AccessData Oracle installations datafiles may have been configured to paths outside the oracle home folder structure. 

Restoring Cold Backup of Oracle Data:

  1. On new system hosting Oracle installation, cleanly stop Oracle services.
  2. Backup the "new system's" empty Oracle home folder(s).
  3. Copy the original host system's cold backup to the root of the drive with the appropriate drive letter (must match original system's drive letter for Oracle home).
  4. Start Oracle services after folder copy has completed.

 

Cause

Any of the following are potential causes for needing to move the Oracle data.

  1. System hardware change / failure.
  2. System hardware / or OS upgrade.
  3. Disaster recovery.

 

(be sure to add labels to help others find your article)

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk