8.4. Backing Up and Restoring the Oracle VDI Database

As with all user-level data, it is important to back up the Oracle VDI database periodically. This is also a crucial step if you plan to reinstall an Oracle VDI host.

The following information should be used when backing up data for both the embedded Oracle VDI MySQL Server database and a remote MySQL database. To learn more about Oracle VDI configurations and the corresponding databases, refer to Section 2.1, “About Oracle VDI Centers and Hosts”.

This backup task archives only the content of the Oracle VDI database. The volumes of desktops and templates as well as configuration and settings values are not backed up.

Before You Begin

Here is a list of important notes when backing up and restoring the Oracle VDI database.

Steps

  1. Make a backup of the database.

    • From the CLI, run the vda-backup command.

      # /opt/SUNWvda/sbin/vda-backup [-p <path-to-directory>] [-o <output-file-name>] 

      While the backup job is running, all other jobs are stopped or put in queue in all hosts. A zip archive is created, that includes one file, with an .db extension and a timestamp-based name.

      For a detailed view of the backup command syntax use the following command.

      # /opt/SUNWvda/sbin/vda-backup -h
    • From Oracle VDI Manager:

      1. Select the Settings category, then the VDI Center subcategory.

      2. Select the Database tab, and click Backup in the VDI Database Backup section.

  2. Restore the backed up database on the new Oracle VDI installation.

    • From the CLI, run the vda-restore command.

      # /opt/SUNWvda/sbin/vda-restore -i <path-to-backup.zip>

      For a detailed view of the vda-restore command syntax use the following command.

      # /opt/SUNWvda/sbin/vda-restore -h
  3. After the restore job finishes, restart Oracle VDI system on all hosts.

    # cacaoadm stop -f -i vda 
    # cacaoadm start -i vda

    On Linux platforms, the cacaoadm command is in /opt/sun/cacao2/bin.