Attach Multiple Backups

To open the Attach Multiple Backups Wizard, click Attach Backup Files located under the Attach Multiple Backups option. Follow these steps to create a VDB based on data from specific backup files:

1. 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.
2. 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.

3. 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.
4. 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.