Enhancing Oracle Restore Performance

You can perform a restore operation more quickly when you set a maximum number of concurrent open data files for RMAN to read simultaneously. Use the following steps to enhance the restore operation:

  1. From the CommCell Browser, go to Client Computers > client > Oracle.
  2. Right-click the instance, then go to All Tasks > Browse and Restore.

    The Browse and Restore Options dialog box appears.

  3. Select Latest Backup, and then click the View Content button.
  4. Optional: Use non-default browse and restore options. For more information, see Browse and Restore.
  5. Select the database, and then click the Recover All Selected button.

    The Oracle Restore Options dialog box appears.

  6. Depending on the type of restore to be run, click Restore in place or Restore out of place, and then click Next.

    The Oracle In Place Restore Options or Oracle Out of Place Restore Options dialog box appears.

  7. Click Advanced.

    The Advanced Restore Options dialog box appears.

  8. On the Options tab, select the number of open files from the Max Open Files list.
  9. On the Copy Precedence tab, select the Restore from Copy Precedence check box.
  10. In the Copy Precedence box, type the copy precedence number for the backup copy.
  11. Click OK.
  12. Click OK to start the restore.

Last modified: 1/2/2020 6:23:56 PM