Skip to main content
SnapCenter Software 4.9
A newer release of this product is available.

Restore and recover tablespaces using point-in-time recovery

Contributors netapp-soumikd

You can restore a subset of tablespaces that has been corrupted or dropped without impacting the other tablespaces in the database. SnapCenter uses RMAN to perform point-in-time recovery (PITR) of the tablespaces.

Before you begin

  • The backups that are required to perform PITR of tablespaces should be cataloged and mounted.

  • If you have installed the plug-in as a non-root user, you should manually assign the execute permissions to the prescript and postscript directories.

About this task

During PITR operation, RMAN creates an auxiliary instance at the specified auxiliary destination. The auxiliary destination could be a mount point or ASM disk group. If there is sufficient space in the mounted location, you can reuse one of the mounted locations instead of a dedicated mount point.

You should specify the date and time or SCN and the tablespace is restored on the source database.

You can select and restore multiple tablespaces residing on ASM, NFS, and SAN environments. For example, if tablespaces TS2 and TS3 reside on NFS and TS4 reside on SAN, you can perform on single PITR operation to restore all the tablespaces.

Note In a RAC setup, you can perform PITR of tablespaces from any node of the RAC.

Steps

  1. In the left navigation pane, click Resources, and then select the appropriate plug-in from the list.

  2. In the Resources page, select either Database or Resource Group from the View list.

  3. Select the database of type single instance (multitenant) either from the database details view or the resource group details view.

    The database topology page is displayed.

  4. From the Manage Copies view, select Backups from either the primary or the secondary (mirrored or replicated) storage systems.

    If the backup is not cataloged, you should select the backup and click Catalog.

  5. Select the cataloged backup, and then click restore icon.

  6. In the Restore Scope page, perform the following tasks:

    1. If you have selected a backup of a database in a Real Application Clusters (RAC) environment, select the RAC node.

    2. Select Tablespaces, and then specify the tablespaces you want to restore.

      Note You cannot perform PITR on SYSAUX, SYSTEM, and UNDO tablespaces.
    3. Select Change database state if needed for restore and recovery to change the state of the database to the state required to perform restore and recovery operations.

  7. In the Recovery Scope page, perform one of the following actions:

    • If you want to recover to a specific System Change Number (SCN), select Until SCN and specify the SCN and auxiliary destination.

    • If you want to recover to a specific date and time, select Date and Time and specify the date and time and the auxiliary destination.

      SnapCenter identifies and then mounts and catalogs the optimal number of data and log backups required to perform PITR based on specified SCN or the selected date and time.

  8. In the PreOps page, enter the path and the arguments of the prescript that you want to run before the restore operation.

    You should store the prescripts either in the /var/opt/snapcenter/spl/scripts path or in any folder inside this path. By default, the /var/opt/snapcenter/spl/scripts path is populated. If you have created any folders inside this path to store the scripts, you must specify those folders in the path.

    You can also specify the script timeout value. The default value is 60 seconds.

    SnapCenter allows you to use the predefined environment variables when you execute the prescript and postscript. Learn more

  9. In the PostOps page, perform the following steps:

    1. Enter the path and the arguments of the postscript that you want to run after the restore operation.

      Note If the restore operation fails, postscripts will not be executed and cleanup activities will be triggered directly.
    2. Select the check box if you want to open the database after recovery.

  10. In the Notification page, from the Email preference drop-down list, select the scenarios in which you want to send the email notifications.

  11. Review the summary, and then click Finish.

  12. Monitor the operation progress by clicking Monitor > Jobs.