Oracle Vault Backups

There are many ways to create database backups using Oracle, and it is normally the responsibility of an Oracle database administrator to configure the backups to best meet the organization's requirements.

Important!

Do not create vault database backups with the Oracle tools without first running the Prepare for Backup Wizard in the Meridian Enterprise Administrator, either interactively or as a scheduled task. The Prepare for Backup Wizard must be used in order to first commit the transaction logs that the EDM Server service generates. These are required for a complete backup.

We recommend the following procedure for backing up Oracle vaults:

Set the UseCompatibleBackup registry value as described in HKEY_LOCAL_MACHINE\Software\Cyco\AutoManager Meridian\CurrentVersion\Installed DataStores\<vaultname>\CompoundItemService depending on whether or not you will use the Oracle tools to create a snapshot of the vault data.
Choose between two options:
- If UseCompatibleBackup is set to 0:
  
  Use the Prepare for Backup Wizard the same as for a Hypertrieve vault database as explained in Prepare For Backups. You can then back up the files in the Backup folder with standard backup software.
- If UseCompatibleBackup is set to 1:
  1. Run the Prepare for Backup Wizard either interactively or as a scheduled task.
  2. Disable and stop the EDM Server service with one of the following methods:
    - Microsoft Management Console (MMC)
    - The EDM Server properties in the Meridian Enterprise Administrator
    - A command line window or batch file (preserve all spaces shown below):
```
sc \\. config EDM_SERVICE start= disabled
net stop EDM_SERVICE
```
  3. Back up the Oracle database with the Oracle tools.
  4. Back up the contents of the vault's Backup folder, the Oracle backup files, and the vault stream files to backup media with standard backup software.
  5. Restart the EDM Server services that were stopped in step b using one of the methods listed in step b.

To restore a backup of an Oracle vault database, restore the backed up files from the backup media to the Backup folder, restore the Oracle database, and then use the Restart After Restore Wizard as described in Restore Backups.