This topic describes how to manually refresh a virtual database (VDB).

Refreshing a VDB will re-provision it from the dSource. As with the normal provisioning process, you can choose to refresh the VDB from a snapshot or a specific point in time. However, you should be aware that refreshing a VDB would delete any changes that have been made to it over time. When you refresh a VDB, you are essentially re-setting it to the state you select during the refresh process. You can refresh a VDB manually, as described in this topic, or you can set a VDB refresh policy, as described in the topics Managing Policies: An Overview and Creating Custom Policies.

Although the VDB no longer contains the previous contents, the previous Snapshots and TimeFlow still remain in Delphix and are accessible through the Command Line Interface (CLI).


Prerequisites

To refresh a VDB, you must have the following permissions:
  • PROVISIONER permissions on the dSource associated with the VDB
  • PROVISIONER permissions on the group that contains the VDB
  • Owner permissions on the VDB itself
  • Data is a role which allows DB_ROLLBACK, DB_REFRESH, READ_ACTION, DB_SYNC, JOB_CANCEL.
  • Read is a role which allows the user to inspect objects via the READ_ACTION permission.

A user with Delphix Admin credentials can perform a VDB Refresh on any VDB in the system.

Procedure

  1. Login to the Delphix Management application.
  2. Click Manage.
  3. Select Datasets.
  4. Select the VDB you want to refresh.
  5. Click the Refresh VDB button (2 circular arrows).
  6. Select More Accurate and Next.
  7. Select desired refresh point snapshot or click the eye icon to choose Latest available range, A point in time, or An SCN to refresh from.
  8. Click Next

  9. Click Submit to confirm.

  10. Click the Actions link to watch the progress of the refresh job
  11. To see when the VDB was last refreshed/provisioned, check the Time Point on the Status page