Recovering using snapshots without log replay

The following procedure uses the Recovery option. It restores the component database from the snapshot set volumes to the time of the snapshot set. The component database and transaction log volumes are restored but no additional transaction logs are applied.

Note:

The Recovery option is applicable only for EV database components and not for EV Index and Partitions.

To recover EV components without log replay using the VEA

  1. Close the SQL GUI, Explorer windows, applications, consoles (except the VEA), or any third-party system management tools that may be accessing the EV component volumes.

    It is recommended to bring the database offline.

  2. On the VEA, navigate to the Storage Agent node on the left-hand pane and click to expand Applications. Right-click Enterprise Vault and select Enterprise Vault Restore from the context menu.
  3. Review the information on the Welcome page and click Next.
  4. Select the snapshot set XML metadata file to be used for this operation and click Next.

    The XML metadata file contains all required information needed to restore the snapshot set. Click the appropriate header to sort the list of available files by File Name or Creation Time.

  5. On the Select Restore Type panel, select Recovery.

    Complete the information on this page as follows:

    Recovery with missing original volumes

    Enable the checkbox if one or more original volumes are missing.

    Forcefully close any open handles

    Enable the checkbox if some EV component volumes have open handles. This will forcefully close any open handles of the volumes to be restored.

    Click Next.

  6. On the Select Enterprise Vault components for Restore operation page, select the component or components that you want to restore using the Recovery option.

    The original volumes of selected components are restored from the snapshot volumes. Click Next.

  7. Verify the snapshot restore specifications on the summary page and click Finish.

    The database is restored to the time the snapshot set was created or last refreshed. If you took it offline earlier, bring it back online.

To recover EV components without log replay using the vxsnap restore command

  1. Close the SQL Enterprise Manager GUI and all Explorer windows, applications, consoles, or third-party system management tools that may be accessing the volumes.

    It is also recommended to bring the component database offline.

  2. Type the command as in the following example:
    vxsnap -x billing_DB.xml restore RestoreType=RECOVERY
    Writer=EnterpriseVault site=site1/vsg=vsg1/vs=vs1
    component="Directory DB"

    where billing_DB.xml is the name of the metadata file generated by the vxsnap create command. The volumes in the snapshot set are restored and the component database is left in an operational state. The component database is restored to the time the snapshot set was created or last refreshed. If you took it offline earlier, bring it back online.