Example: Recovering a PDB in an Oracle RAC Environment

The process to restore and recover a PDB in an Oracle Real Application Clusters (Oracle RAC) environment has some slight additions to the non-Oracle RAC process. This example demonstrates how to recover a PDB in an Oracle RAC environment.

To restore and recover a PDB in an Oracle RAC environment:

  1. Ensure that the prerequisites described in "Prerequisites for Restoring and Recovering Data from Recovery Appliance" are met.
  2. Use RMAN to connect to the root of the CDB as TARGET and the Recovery Appliance catalog as CATALOG as described in "Connecting to the Protected Database and Recovery Appliance Using CLI".
  3. Ensure that all instances of the affected PDB are closed.

    The following command closes all instances of the PDB hr_pdb.

    ALTER PLUGGABLE DATABASE "hr_pdb" CLOSE IMMEDIATE INSTANCES=all;
    
  4. Restore and recover the affected PDB in your protected database.

    The following command restores and recovers the hr_pdb.

    RUN 
    {
      ALTER PLUGGABLE DATABASE "hr_pdb" CLOSE IMMEDIATE;
      RESTORE PLUGGABLE DATABASE 'hr_pdb';
      RECOVER PLUGGABLE DATABASE 'hr_pdb';
      ALTER PLUGGABLE DATABASE "hr_pdb" OPEN RESETLOGS;
      ALTER PLUGGABLE DATABASE "hr_pdb" OPEN INSTANCES=all;
    }