Data Refresh helps you refresh the external database backups in a golden database node, mask the data in the golden database, and clone any number of database nodes from the golden database node. You must prepare an environment to provision and clone the database nodes.

The preparing a data refresh environment checklist provides a high-level overview of the sequence of steps required to prepare an environment to generate a golden database.

Table 1. Preparing a Data Refresh Environment Checklist

Task

Comments

Check Box Complete all required IaaS configurations, and set up reservation policies and network profiles.

For information about required IaaS configurations, reservation policies, and network profiles, see IaaS Configuration for Virtual Platforms.

Check Box Register vRealize Automation server from the Application Services client in Application Services.

See Using Application Services.

Check Box Create the cloud provider and deployment environment in Application Services.

See Using Application Services.

Check Box Log in to Application Services as a system administrator.

Verify that the server or directory that contains the backups and control file is secured.

Check Box Download the database installation files from the database website to any location on the server.

Ensure that the server access channel is secured.

See Oracle or Microsoft website to download the installation files.

Check Box Prepare a set of backups (plus control file backup) in a server or directory appropriately.

Check Box Prepare a virtual machine on vCenter Server with vRealize Automation and the Application Services agent installed.

Check Box Create a vRealize Automation machine blueprint of type vSphere vCenter based on the virtual machine in vCenter Server.

See IaaS Configuration for Virtual Platforms.

Check Box Add the vSphere vCenter machine blueprint in the cloud provider and logical template in Application Services.

See Using Application Services.

Check Box In Application Services, create an application and application version.

  1. Create a blueprint.

  2. Add a database node.

  3. Add an appropriate database service in the database node.

  4. Add additional disks with appropriate disk tags in the database node.

  5. Set the properties in the appropriate database service.

  6. Bind the disk_layout_info to self:disk_layout_info.

See Using Application Services.

Check Box Create a deployment profile for the application version.

See Using Application Services.