To create a VDB based on data from specific backup files, click the Attach Multiple Backups option located on the top section of the Virtual Database tab. The Attach Multiple Backups Wizard opens and different options are displayed. Follow these steps:
- Backup Files:
- Click Select to choose a Host Instance from the displayed list.
- Click Browse, select the backup files (.bak & .safe) from the file explorer dialog box or enter manually the files you prefer in the text box and click Add to display them in the Selected Backups section below.
- The Encryption Settings option is available when the chosen backup sets were encrypted during their backup.
- Click Remove to delete all selected backup files from the display. A dialog box opens to confirm the backup removal.
- Click Next to continue.
- Point in Time:
In this step, the user sets a specific restore point in time. The following options can be performed:- Use the point in time slider to select the backup sets you need. This ensures you are not restoring data time-stamped with dates later than the point in time you specified.
- You can enter manually the specific point in time to restore. There are two ways to pick date and time to restore file(s): By Date or by LSN.
Click Next to continue.
When choosing Date use MM/DD/YYYY hh:mm:ss format. And for LSN use '#:#;#' format.
LSN (Log Sequence Numbers) is used internally during a RESTORE sequence to track the point in time to which data has been restored. When a backup is restored, the data is restored to the LSN corresponding to the point in time at which the backup was taken.
- Create As:
- The Host Instance textbox displays the instance name that hosts the VDB, by default.
- In the Virtual Database Name textbox, type a unique name for your VDB. Click Database Files... to customize the location where to store the files for your new VDB and click OK.
- Enter a Description.
- Click Next to continue.
- Summary:
- Confirm the display information in the Summary step.
- Click Prev to go back to previous steps and edit the information, select Cancel to cancel the process and close the wizard, or click Finish to start the process.
- A progress bar displays showing the status of the process. When the process completes, the status changes to Complete.
The results are revealed in the VDB List grid of the Virtual Database tab.