Dell Avamar for Oracle 19.10 User Guide

Restoring a database to a different client

You can restore Oracle databases to a different client.

1. In the AUI navigation pane on the left, click , and then click Asset Management.
   The Asset Management window is displayed.
2. In the domain tree, select the domain that contains the Oracle server.
   You cannot view clients outside the domain for the login account. To view all clients, log in to the root domain.
   A list of Avamar clients is displayed in the pane below the domains list.
3. From the list of clients, select the client that runs the Oracle server.
4. To locate backups by date:
   1. In the right pane, click VIEW MORE.
   2. Click SEARCH.
   3. In the Date field, select a day or range of days.
   4. Click RETRIEVE.
      The list of backups for the selected dates is displayed.
5. Select the desired backup, and then click Restore.
   The Restore wizard opens on the Destination Client pane.

   NOTE:If you click Restore before selecting a backup, the wizard opens on the Backup List pane, where you can then make the backup selection.
6. In the Destination Client pane, perform the following steps:
   1. Select Restore to a different client.
   2. In the domain tree, select the domain for the client.
   3. In the list of clients, select the destination client.
      The client is displayed in the Destination Client field.
   4. Click NEXT.
      The Backup Content pane is displayed.
7. In the Backup Content pane, perform the following steps:
   1. In the left pane, select the folder from the tree.
      The Backup Content pane displays a list of databases within the backup.
   2. Select the databases that you want to restore.
   3. Click NEXT.
   The Destination Location pane is displayed.
8. In the Destination Location pane, perform the following steps:
   1. Select Restore to a different folder location.
   2. In the Instance Location field, click CHOOSE to browse to the folder available on the destination client.
   3. In the Alternate database location field, type an alternate location in the destination client where the database will be restored. For example, C:\restore.
   4. Click NEXT.
      The More Options pane is displayed.
9. In the More Options pane, set the plug-in options:
   1. To view advanced options, select Show Advanced Options.
   2. Leave the Oracle Instance Name field blank. The Avamar Plug-in for Oracle determines the Oracle instance name when you browse and select a database to restore.
   3. (Optional) For Oracle 12c and later, if the Oracle user has SYSBACKUP privileges (instead of SYSDBA), select SYSBACKUP privilege.
      1. In the User Name field, type the username to use to authenticate the Oracle database. This is the user with SYSDBA (or SYSBACKUP) privileges.
      2. In the Password field, type the password for the account.
      3. (Linux and UNIX only) If the application bitness and operating system bitness are not the same, select the appropriate setting from the Media Management Library Bitwidth list.

         If the application bitness and operating system bitness are the same, leave the Media Management Library Bitwidth set to the Automatic (default).
         

         The Management Library Bitwidth option does not apply to Windows platforms.

      4. In the Number of RMAN Channels list, select the number of channels to allocate during the restore. The maximum number is 10.
   4. (Optional) To prevent a multiple target restore from continuing after one of the restore operations fails, select Exit a multiple target restore when any one restore fails .
   5. (Advanced option) To write maximum information to log files, select Enable debugging message. Selecting this option creates large log files.
   6. (Advanced option) In the NLS_DATE_FORMAT field, type a timestamp format for the target database.
   7. In the Encryption method from Data Domain system list, select the encryption method to use for data transfer between the Data Domain system and the client during the restore.
   8. (Advanced option) If you selected Corrupt blocks from the Recovery Type group box, select Validate database.
      The Validate database option is optional when you perform a corrupt block recovery. The restore operation is slower when you use the Validate database option.
   9. Select an option from the Recovery mode list for the selected recovery type.
      Recovery modes and values provides more information about the Recovery mode options.
   10. In the Recovery value field, type the SCN, log sequence number, or timestamp. This value depends on the option that you select from the Recovery mode list.
   11. To open the database after the recovery finishes, select Open the database with resetlogs after recovery.
       This option is selected by default.
   12. Clear the Open the database with resetlogs after recovery option. When you clear this option, the restore operation does not open the database with resetlogs. You can apply archive logs to recover the database to the most current point-in-time that is available.
10. Select a Recovery Type:
    1. To recover the database to the present time or to a point-in-time in the past, select Point-in-Time (PIT).
       Do not select multiple databases for a point-in-time recovery. Select only one database for the restore.
    2. To recover data blocks from the flash recovery area, select Flashback Database (FRA).
       Configure flash recovery area before you can use the Flashback Recovery (FRA) recovery type. Configuring Flashback Database recovery provides more information.
    3. (Advanced option) To restore corrupt blocks only, and not the entire database, select Corrupt blocks.
       To use the Corrupt blocks recovery option, you must set the DB_BLOCK_CHECKSUM initialization parameter to TYPICAL for the Oracle database. The database must be in a mounted or open state.
    4. From the Encryption method from Data Domain system list, select the encryption method to use for data transfer between the Data Domain system and the client during the restore.
    5. (Advanced option) If you selected Corrupt blocks from the Recovery Type group box, select Validate database.
       The Validate database option is optional when you perform a corrupt block recovery. The restore operation is slower when you use the Validate database option.
11. Specify Point-in-Time/Flashback Recovery options: :
    1. Select an option from the Recovery mode list for the selected recovery type.
       Recovery modes and values provides more information about the Recovery mode options.
    2. Specify the SCN, log sequence number, or timestamp in the Recovery value field. This value depends on the option that you select from the Recovery mode list.
    3. To open the database after the recovery finishes, select Open the database with resetlogs after recovery.
       This option is selected by default.
       To disable this option, clear the Open the database with resetlogs after recovery check box. When you clear this option, the restore operation does not open the database with resetlogs. You can apply archive logs to recover the database to the most current point-in-time that is available.
12. Specify Preprocessing Script options:
    1. To run a user-defined script at the beginning of the restore, type the script name in the Run user-defined script at beginning of restore field.
       The script must be in the avamar\etc\scripts directory on the client.
    2. To stop the script from processing when the script returns a nonzero status code, select Exit restore if script fails.
       This option is selected by default.
       Preprocessing and postprocessing scripts and attributes provides more information about using scripts and specifying attributes.
13. Specify Postprocessing Script options:
    1. To run a user-defined script at the end of the restore, type the script name in the Run user-defined script at end of restore field.
       The script must be in the avamar\etc\scripts directory on the client.
    2. To exit the script when it fails with an exitcode from the script rather than an exitcode from the Avamar Plug-in for Oracle, select Exit process with script failure exitcode.
       This option is selected by default.
       Preprocessing and postprocessing scripts and attributes provides more information about using scripts and specifying attributes.
14. Click NEXT.
    The Summary pane is displayed.
15. Review the provided information, and then click FINISH.