Oracle Database Vault Backup_AV

Parent page: Backing up and Restoring Your Altium Vault Installation

A critical requirement for systems that maintain and store valuable design data, such as the Altium Vault, is backing up the data and files hosted by the system. The Altium Vault installation includes a command line tool for this purpose, which offers the capability to both backup and restore the entire Vault content and user data, including the database when the Firebird option has been installed.

For users that have selected an Oracle® database type for use with the Vault however, the backup process is somewhat different and also time-critical.

The different approach required is because the Oracle database is a separate entity from the Vault system, unlike the integrated Firebird database alternative, and therefore must be backed up by its own system and process. That system is most likely in another network location, and more significantly, under control of the Oracle infrastructure, its inherent policies, and the database Administrator (DBA).

Backing up an Altium Vault that uses an Oracle database therefore involves two independent stages:

1. Arranging for the Oracle database and metadata to be backed up.
2. Using the supplied Altium Vault Backup tool to backup all other Vault content and settings.

Important Recommendations

• Complete backups should be performed on a regular basis, and must be mandatory before any significant changes are made to the system or its configuration. This includes software updates, setup changes, hardware replacement, and so on.
   
• Test Vault installation systems should be created that are independent of the main Production system. A Test system can be used for regular test restores to ensure that the systems work as intended, and everyone involved is aware of the exact steps they need to take in the event of a worst case scenario.
   
• As mentioned above, unless both the Vault and Oracle systems are suspended (unlikely for the Oracle system), both the backup (or restore) stages should be completed within the shortest possible time. The simple fact here is that if any changes are made to the Vault, or its database from other sources, within the period between the two backup stages, the two sources will not align in content when they are restored.
   

  The best approach is to stop the Vault server (using Windows' IIS Manager), or prevent access to it, during the period between the two backup processes. The timing and order of the two backups is then not critical, since no changes can be made in the interim.

• Since there are two independent backups performed to create a complete backup of the Vault content, the two data snapshots should be date/time stamped and associated with each other by some overarching system. Such a system would link the two sources that make up a complete Vault backup, and provide the ability to retrieve the 'composite' backup on demand.

Creating a Backup

Contact your Oracle DBA to instigate a suitable backup arrangement for the Vault database. The Oracle database backup should occur in close association with the backup completed by the Altium Vault Backup tool, and be involved with a backup management system that links the two stored backups.

Perform a backup of the Vault using the supplied Vault Backup tool. For more information on the process see the Backing up and Restoring Your Altium Vault Installation page.

In short however, the backup command line tool (avbackup.exe) is located in the Vault installation’s \Tools\BackupTool directory, and its minimal command string is avbackup backup –z <output location\file>. Note that quotes must be used when the path-file includes spaces.

For example, creating a backup of an (Oracle database type) Altium Vault installation might be avbackup backup –z “C:\Backups\Another_Backup.zip”. The completed backup process would appear as below.

When the tool detects that the Vault uses an Oracle database, the database backup part of the process is skipped and a warning is displayed. All other data, content, and settings are backed up as usual.

The content of an Oracle database Vault backup zip file is the same as that for a Firebird-based Vault backup, but does not include a database backup file - in a Firebird backup, this file is DXPServer.fbk.