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

Restore and recover pluggable database using point-in-time recovery

Contributors

You can restore and recover a pluggable database (PDB) that has been corrupted or dropped without impacting the other PDBs in the container database (CDB). SnapCenter uses RMAN to perform point-in-time recovery (PITR) of the PDB.

Before you begin

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

    Note In a RAC setup, you should manually close the PDB (changing the state to MOUNTED) on all the nodes of the RAC setup.
  • 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 to perform PITR of the PDB. RMAN can recover READ WRITE, READ ONLY, or dropped PDBs including datafiles.

You can restore and recover only:

  • one PDB at a time

  • one tablespace in a PDB

  • multiple tablespaces of the same PDB

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. Depending on whether you want to restore the PDB or tablespaces in a PDB, perform one of the actions:

      If you want to…​

      Steps…​

      Restore a PDB

      1. Select Pluggable databases (PDBs).

      2. Specify the PDB you want to restore.

        Note You cannot perform PITR on PDB$SEED database.

      Restore tablespaces in a PDB

      1. Select Pluggable database (PDB) tablespaces.

      2. Specify the PDB.

      3. Specify either a single tablespace or multiple 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.

      In a RAC setup, the PDB will be opened only on the node where the database was recovered. You should manually open the recovered PDB on all the other nodes of the RAC setup.

  10. On 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.